From Data Warehouses to Streaming Warehouses: A Survey on the Challenges for Real-Time Data Warehousing and Available Solutions
Year: 2013
Type: article
Abstract: Data Warehouses usually work on history data.In most cases, the Data Warehouse is loaded with data from operational or transactional systems on a weekly or nightly basis.As today's decisions in the business world are becoming real-time, it is only natural that Data Warehouse, Business Intelligence, Decision Support and OLAP systems must quickly begin incorporating real-time data.When shifting from a traditional offline and time-consuming data warehousing system to a real-time system, two important considerations are speeding up the ETL and the OLAP process.This survey looks into the various challenges involved in building a real-time Data Warehouse and some of the solutions available to overcome them.
DOI: 10.5120/13984-1990
Language: English
Subfield: Management Information Systems
Domain: Social Sciences
Open Access status: bronze
OpenAlex ID: W2147097061