Authors : Ashwini A. Rangari and A.R. Raipurkar
Abstract: Traditional data warehouse systems are only periodically updated. It cannot satisfy the need of real-time analysis. To diminish this problem, the Real-Time Data Warehouse (RTDW) technology has emerged. The real-time data warehouses are very suitable for the real-time enterprises. In spite of the high complexity of the queries used, quick response time is the basic requirement of successful business applications. Materialized views are found to be very useful for fast query processing. In this study, the purpose is to better manage materialized views. In our approach, we are performing data view maintenance not only on the basis of data staleness but also on query time and query size. This will ensure better view maintenance as well as a better way to update the data in the views. We use an update policy that dynamically decides the method to maintain materialized views based on their access frequency.
Ashwini A. Rangari and A.R. Raipurkar, 2017. Materialized View Based Data Warehouse Optimization. Journal of Engineering and Applied Sciences, 12: 9436-9439.