论文信息 - Maintenance of cube automatic summary tables

Maintenance of cube automatic summary tables

Materialized views (or Automatic Summary Tables—ASTs) are commonly used to improve the performance of aggregation queries by orders of magnitude. In contrast to regular tables, ASTs are synchronized by the database system. In this paper, we present techniques for maintaining cube ASTs. Our implementation is based on IBM DB2 UDB.

Hamid Pirahesh | Wolfgang Lehner | Roberta Cochrane | Richard S. Sidle

[1] Jeffrey D. Ullman,et al. Implementing data cubes efficiently , 1996, SIGMOD '96.

[2] Roberta Cochrane,et al. How to roll a join: asynchronous incremental view maintenance , 2000, SIGMOD 2000.

[3] Hamid Pirahesh,et al. Answering complex SQL queries using automatic summary tables , 2000, SIGMOD 2000.

[4] Inderpal Singh Mumick,et al. Maintenance of data cubes and summary tables in a warehouse , 1997, SIGMOD '97.