Maintenance of Cube Automatic Summary Tables

Summary: Cube Automatic Summary Tables (ASTs) as DBMS-managed, synchronized materialized views for multi-dimensional aggregations; introduces incremental cube-aware maintenance techniques. Implemented in IBM DB2 UDB, demonstrating efficient upkeep of cube ASTs to accelerate aggregate queries. (summarized by gpt-5-nano on Feb 09 2026)

Paper ID: hae7a03a75830f066
Venue: SIGMOD
Year: 2000
Pagerank: 5.3012918e-05
Overall Rank: 8,621 | 42.04%
DOI: 10.1145/342009.335454

Incoming Non-self Citations Over Time

Authors

1. Wolfgang Lehner (Friedrich-Alexander University Erlangen-Nuremberg)
2. Richard Sidle (IBM)
3. Hamid Pirahesh (IBM)
4. Roberta Cochrane (IBM)

BibTeX Citation

@inproceedings{lehner_sigmod00,
        title = {{Maintenance of Cube Automatic Summary Tables}},
        author = {Lehner, Wolfgang and Sidle, Richard and Pirahesh, Hamid and Cochrane, Roberta},
        series = {{SIGMOD} '00},
        booktitle = {Proceedings of the {ACM} {SIGMOD} International Conference on Management of Data},
        publisher = {Association for Computing Machinery},
        doi = {10.1145/342009.335454},
        url = {https://dl.acm.org/doi/10.1145/342009.335454},
        year = {2000}
}

Incoming Citations (Sorted by Pagerank)

Showing 2 of 2 citing papers.

Rank	Citing Paper	Year	Venue	Pagerank
1,779	Lazy Maintenance of Materialized Views	2007	VLDB	9.6583009e-05
3,600	Practical Applications of Triggers and Constraints: Successes and Lingering Issues	2000	VLDB	7.1765044e-05

Outgoing Citations (Sorted by Pagerank)

Showing 3 of 3 cited papers.

Citations counted here include only citations to other VLDB/SIGMOD/CIDR/PODS papers in this database.

Rank	Cited Paper	Year	Venue	Pagerank
11	Implementing Data Cubes Efficiently	1996	SIGMOD	0.00071084324
901	Maintenance of Data Cubes and Summary Tables in a Warehouse	1997	SIGMOD	0.00013185553
1,054	Answering Complex SQL Queries Using Automatic Summary Tables	2000	SIGMOD	0.00012269068

Semantically Similar Papers

#	Overall Rank	Paper	Year	Venue
1	1,054	Answering Complex SQL Queries Using Automatic Summary Tables	2000	SIGMOD
2	6,524	Analytical Modeling of Materialized View Maintenance	1988	PODS
3	723	A Performance Analysis of View Materialization Strategies	1987	SIGMOD
4	923	Materialized View Selection and Maintenance Using Multi-Query Optimization	2001	SIGMOD
5	380	Maintenance Of Views	1984	SIGMOD
6	14,168	Automated Statistics Collection in Action	2005	SIGMOD
7	13,211	Dynamic Assembly of Views in Data Cubes	1998	PODS
8	4,659	Automated Statistics Collection in DB2 UDB	2004	VLDB
9	901	Maintenance of Data Cubes and Summary Tables in a Warehouse	1997	SIGMOD
10	2,081	Incremental Maintenance for Non-Distributive Aggregate Functions	2002	VLDB