Real-Time Data Warehousing: A State-of-the-Art Survey

The aim of this research based book is to highlight the importance of real-time data warehousing (RTDW) to increase operational business intelligence in large organizations. We present state-of-the art survey and a comprehensive comparative analysis in three areas: (1) RTDW frameworks, (2) real-time data acquisition technologies, and (3) data warehouse multidimensional conceptual modeling (MCM) techniques. We also discuss some future research directions and open problems related to RTDW. In our point of view, semi-structured databases (i.e., XML) have greater capability to incorporate real-time data from operational sources than relational databases. Based on recent research articles, this book can greatly help the data warehouse practitioners and researchers to have a deep understanding of the issues related to RTDW and propose new solutions for the highlighted problems. In future, we aim to provide an RTDW framework based on the virtualization concept and a novel semi-structured MCM, which is suitable for OLTP and OLAP applications. This research is being conducted at Punjab University College of Information Technology (PUCIT), University of the Punjab, Lahore, Pakistan.