Dynamic materialized view management based on predicates

Abstract

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 TPCH benchmark data on IBM DB2 and encouraging results are obtained which indicate that our approach is highly feasible. © Springer-Verlag Berlin Heidelberg 2003.