Dynamic Materialized View Management Based on Predicates

摘要

For the purpose of satisfying different users' profiles and accelerating the subsequence OLAP (Online Analytical Processing) queries in a large data warehouse, dynamic materialized OLAP view management is highly desirable. Previous work caches data as either chunks or multidimensional range fragments. In this paper, we focus on ROLAP (Relational OLAP) in an existing relational database system. We propose a dynamic predicate-based partitioning approach, which can support a wide range of OLAP queries. We conducted extensive performance studies using TPC_H benchmark data on IBM DB2 and encouraging results are obtained which indicate that our approach is highly feasible.