Maintenance of Data Cubes and Summary Tables in a Warehouse

Summary: Introduces the summary-delta table method for maintaining aggregate views (data cubes) in warehouses amid ongoing data changes. Addresses efficient maintenance of large sets of summary tables over the same base data, minimizing batch windows and enabling scalable OLAP updates. (summarized by gpt-5-nano on Feb 09 2026)

Paper ID: 3000
Venue: SIGMOD
Year: 1997
Pagerank: 0.0001331508
Overall Rank: 905 | 93.80%
DOI: 10.1145/253260.253277

Incoming Non-self Citations Over Time

Authors

1. Inderpal Singh Mumick (AT&T)
2. Dallan Quass (Stanford University)
3. Barinderpal Singh Mumick (AT&T)

BibTeX Citation

@inproceedings{mumick_sigmod97,
        title = {{Maintenance of Data Cubes and Summary Tables in a Warehouse}},
        author = {Mumick, Inderpal Singh and Quass, Dallan and Mumick, Barinderpal Singh},
        series = {{SIGMOD} '97},
        booktitle = {Proceedings of the {ACM} {SIGMOD} International Conference on Management of Data},
        publisher = {Association for Computing Machinery},
        doi = {10.1145/253260.253277},
        url = {https://dl.acm.org/doi/10.1145/253260.253277},
        year = {1997}
}

Incoming Citations (Sorted by Pagerank)

Showing 26 of 26 citing papers.

Rank	Citing Paper	Year	Venue	Pagerank
643	Materialized Views In Oracle	1998	VLDB	0.00015372449
816	The Dynamic Yannakakis Algorithm: Compact and Efficient Query Processing Under Updates	2017	SIGMOD	0.00013827772
943	DynaMat: A Dynamic View Management System for Data Warehouses	1999	SIGMOD	0.00013068595
1,034	Answering Complex SQL Queries Using Automatic Summary Tables	2000	SIGMOD	0.00012516197
1,750	Lazy Maintenance of Materialized Views	2007	VLDB	9.8392477e-05
1,845	Hypothetical Queries in an OLAP Environment	2000	VLDB	9.629006e-05
1,907	Incremental Clustering for Mining in a Data Warehousing Environment	1998	VLDB	9.501636e-05
2,769	A Layered Aggregate Engine for Analytics Workloads	2019	SIGMOD	8.1465406e-05
3,366	AQP++: Connecting Approximate Query Processing With Aggregate Precomputation for Interactive Analytics	2018	SIGMOD	7.4748604e-05
3,774	QC-Trees: An Efficient Summary Structure for Semantic OLAP	2003	SIGMOD	7.1381444e-05
3,930	Data Canopy: Accelerating Exploratory Statistical Analysis	2017	SIGMOD	7.0102082e-05
4,155	On the Content of Materialized Aggregate Views	2000	PODS	6.866935e-05
4,181	Mapping Adaptation under Evolving Schemas	2003	VLDB	6.848299e-05
4,463	Consistency in a Stream Warehouse	2011	CIDR	6.6860367e-05
5,136	Extending Practical Pre-Aggregation in On-Line Analytical Processing	1999	VLDB	6.3519278e-05
5,638	An Alternative Storage Organization for ROLAP Aggregate Views Based on Cubetrees	1998	SIGMOD	6.138684e-05
5,728	Shrinking the Warehouse Update Window	1999	SIGMOD	6.1073148e-05
6,648	Performance Issues in Incremental Warehouse Maintenance	2000	VLDB	5.8147041e-05
6,671	Stacked Indexed Views in Microsoft SQL Server	2005	SIGMOD	5.807209e-05
7,238	Kodiak: Leveraging Materialized Views For Very Low-Latency Analytics Over High-Dimensional Web-Scale Data	2016	VLDB	5.664642e-05
7,300	DEX: Query Execution in a Delta-based Storage System	2017	SIGMOD	5.6509215e-05
8,181	Foreign Keys Open the Door for Faster Incremental View Maintenance	2023	SIGMOD	5.4721346e-05
8,219	Ajax-based Report Pages as Incrementally Rendered Views	2010	SIGMOD	5.4642154e-05
8,460	Maintenance of Cube Automatic Summary Tables	2000	SIGMOD	5.4216109e-05
12,859	Proxy-Server Architectures for OLAP	2001	SIGMOD	5.093636e-05
12,883	Hierarchical Compact Cube for Range-Max Queries	2000	VLDB	5.093636e-05

Outgoing Citations (Sorted by Pagerank)

Showing 15 of 15 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
39	Efficiently Updating Materialized Views	1986	SIGMOD	0.00047309646
61	Maintaining Views Incrementally	1993	SIGMOD	0.00039026867
71	Including Group-By in Query Optimization	1994	VLDB	0.00038021159
206	Eager Aggregation and Lazy Aggregation	1995	VLDB	0.00025092273
207	On the Computation of Multidimensional Aggregates	1996	VLDB	0.00025088003
258	Deriving Production Rules for Incremental View Maintenance	1991	VLDB	0.00023131981
373	Maintenance Of Views	1984	SIGMOD	0.00019797816
375	Incremental Maintenance of Views with Duplicates	1995	SIGMOD	0.00019681204
391	View Maintenance in a Warehousing Environment	1995	SIGMOD	0.00019370653
707	A Performance Analysis of View Materialization Strategies	1987	SIGMOD	0.00014771849
1,133	Algorithms for Deferred View Maintenance	1996	SIGMOD	0.00012039326
2,080	View Maintenance Issues for the Chronicle Data Model (Extended Abstract)	1995	PODS	9.2052704e-05
2,901	A Framework for Supporting Data Integration Using the Materialized and Virtual Approaches	1996	SIGMOD	7.9774387e-05
3,607	Efficient Maintenance of Materialized Mediated Views (Extended Abstract)	1995	SIGMOD	7.262291e-05

Semantically Similar Papers

#	Overall Rank	Paper	Year	Venue
1	14,056	Aggregate Maintenance for Data Warehousing in Informix Red Brick Vista	2001	VLDB
2	12,597	When is it Time to Rethink the Aggregate Configuration of Your OLAP Server?	2008	VLDB
3	10,063	Keep Your Distributed Data Warehouse Consistent at a Minimal Cost	2023	SIGMOD
4	4,723	Aggregation Algorithms for Very Large Compressed Data Warehouses	1999	VLDB
5	6,648	Performance Issues in Incremental Warehouse Maintenance	2000	VLDB
6	5,728	Shrinking the Warehouse Update Window	1999	SIGMOD
7	5,779	Multiple-View Self-Maintenance in Data Warehousing Environments	1997	VLDB
8	3,379	Cubetree: Organization of and Bulk Incremental Updates on the Data Cube	1997	SIGMOD
9	12,837	Efficient Integration and Aggregation of Historical Information	2002	SIGMOD
10	8,957	What is the data warehousing problem? (Are materialized views the answer?)	1996	VLDB