2001 Digital Symposium Collection

Maintenance of Automatic Summary Tables

Wolfgang Lehner, Richard Sidle, Hamid Pirahesh, and Roberta Cochrane
View Paper (PDF)

Return to Industrial Sessions

Abstract

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.

References

Note: References link to DBLP on the Web.

[1]: Venky Harinarayan , Anand Rajaraman , Jeffrey D. Ullman : Implementing Data Cubes Efficiently. SIGMOD Conf. 1996 : 205-216
[2]: Inderpal Singh Mumick , Dallan Quass , Barinderpal Singh Mumick : Maintenance of Data Cubes and Summary Tables in a Warehouse. SIGMOD Conference 1997 : 100-111
[3]: Kenneth Salem , Kevin S. Beyer , Roberta Cochrane , Bruce G. Lindsay : How To Roll a Join: Asynchronous Incremental View Maintenance. SIGMOD Conference 2000 : 129-140
[4]: Markos Zaharioudakis , Roberta Cochrane , George Lapis , Hamid Pirahesh , Monica Urata : Answering Complex SQL Queries Using Automatic Summary Tables. SIGMOD Conference 2000 : 105-116

BIBTEX

@inproceedings{DBLP:conf/sigmod/LehnerSPC00,
  author    = {Wolfgang Lehner and
                Richard Sidle and
                Hamid Pirahesh and
                Roberta Cochrane},
   editor    = {Weidong Chen and
                Jeffrey F. Naughton and
                Philip A. Bernstein},
   title     = {Maintenance of Automatic Summary Tables},
   booktitle = {Proceedings of the 2000 ACM SIGMOD International Conference on
                Management of Data, May 16-18, 2000, Dallas, Texas, USA},
   journal   = {SIGMOD Record},
   publisher = {ACM},
   volume    = {29},
   number    = {2},
   year      = {2000},
   isbn      = {1-58113-218-2},
   pages     = {512-513},
   crossref  = {DBLP:conf/sigmod/2000},
   bibsource = {DBLP, http://dblp.uni-trier.de} } },