Article · International Journal of Computer Applications · November 15, 2013
From Data Warehouses to Streaming Warehouses: A Survey on the Challenges for Real-Time Data Warehousing and Available Solutions
S Revathy., Saravana Balaji B, N. Karthikeyan
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.
More by Saravana Balaji Balasubramanian
- Enhancing text-to-structured query language translation for seamless electronic medical record accessPeerJ Computer Science · 2026
- Moth-flame optimized UNet++ with self-attention for early-stage Alzheimer’s disease prediction using multimodal inputPeerJ Computer Science · 2026 · Citations: 1
- MSCHF algorithm for minimizing signaling costs and enhancing vertical handover efficiency in wireless communications networksPeerJ Computer Science · 2025 · Citations: 1
- Enhanced Lung Cancer Prediction Using Ensemble Machine Learning AlgorithmsInternational Conference on Emerging Research in Computational Science · 2024