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: 3274
Venue: SIGMOD
Year: 2000
Pagerank: 5.4216109e-05
Overall Rank: 8,460 | 41.96%
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,750	Lazy Maintenance of Materialized Views	2007	VLDB	9.8392477e-05
3,528	Practical Applications of Triggers and Constraints: Successes and Lingering Issues	2000	VLDB	7.3411417e-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.00071822821
905	Maintenance of Data Cubes and Summary Tables in a Warehouse	1997	SIGMOD	0.0001331508
1,034	Answering Complex SQL Queries Using Automatic Summary Tables	2000	SIGMOD	0.00012516197

Semantically Similar Papers

#	Overall Rank	Paper	Year	Venue
1	1,034	Answering Complex SQL Queries Using Automatic Summary Tables	2000	SIGMOD
2	6,401	Analytical Modeling of Materialized View Maintenance	1988	PODS
3	707	A Performance Analysis of View Materialization Strategies	1987	SIGMOD
4	929	Materialized View Selection and Maintenance Using Multi-Query Optimization	2001	SIGMOD
5	373	Maintenance Of Views	1984	SIGMOD
6	13,857	Automated Statistics Collection in Action	2005	SIGMOD
7	12,921	Dynamic Assembly of Views in Data Cubes	1998	PODS
8	4,591	Automated Statistics Collection in DB2 UDB	2004	VLDB
9	905	Maintenance of Data Cubes and Summary Tables in a Warehouse	1997	SIGMOD
10	2,064	Incremental Maintenance for Non-Distributive Aggregate Functions	2002	VLDB