Dynamic materialized view management based on predicates

Authors:
Chi-Hon Choi;Jeffrey Xu Yu;Hongjun Lu
Affiliations:
The Chinese University of Hong Kong, Hong Kong, China;The Chinese University of Hong Kong, Hong Kong, China;The Hong Kong University of Science and Technology, Hong Kong, China
Venue:
APWeb'03 Proceedings of the 5th Asia-Pacific web conference on Web technologies and applications
Year:
2003

Citing 13
Cited 4

Implementing data cubes efficiently

SIGMOD '96 Proceedings of the 1996 ACM SIGMOD international conference on Management of data
Caching multidimensional queries using chunks

SIGMOD '98 Proceedings of the 1998 ACM SIGMOD international conference on Management of data
Principles of distributed database systems (2nd ed.)

Principles of distributed database systems (2nd ed.)
DynaMat: a dynamic view management system for data warehouses

SIGMOD '99 Proceedings of the 1999 ACM SIGMOD international conference on Management of data
Materialized views: techniques, implementations, and applications

Materialized views: techniques, implementations, and applications
Selecting and materializing horizontally partitioned warehouse views

Data & Knowledge Engineering
Proxy-server architectures for OLAP

SIGMOD '01 Proceedings of the 2001 ACM SIGMOD international conference on Management of data
Materialized view selection under the maintenance time constraint

Data & Knowledge Engineering
Index Selection for OLAP

ICDE '97 Proceedings of the Thirteenth International Conference on Data Engineering
Materialized Views Selection in a Multidimensional Database

VLDB '97 Proceedings of the 23rd International Conference on Very Large Data Bases
Materialized View Selection for Multidimensional Datasets

VLDB '98 Proceedings of the 24rd International Conference on Very Large Data Bases
Semantic Data Caching and Replacement

VLDB '96 Proceedings of the 22th International Conference on Very Large Data Bases
WATCHMAN: A Data Warehouse Intelligent Cache Manager

VLDB '96 Proceedings of the 22th International Conference on Very Large Data Bases

Enabling policy-based access control in BI applications

Data & Knowledge Engineering
An architecture for recycling intermediates in a column-store

Proceedings of the 2009 ACM SIGMOD International Conference on Management of data
An architecture for recycling intermediates in a column-store

ACM Transactions on Database Systems (TODS)
Dynamic View Management System for Query Prediction to View Materialization

International Journal of Data Warehousing and Mining

Quantified Score

Hi-index	0.00

Visualization

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.