DBScholar

Back to papers

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
h9736f8edb54aa3a2
Venue
SIGMOD
Year
1997
Pagerank
0.00013185553
Overall Rank
901 | 93.95%
DOI
10.1145/253260.253277

Incoming Non-self Citations Over Time

Authors

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 27 of 27 citing papers.

Rank Citing Paper Year Venue Pagerank
648 Materialized Views In Oracle 1998 VLDB 0.00015151422
812 The Dynamic Yannakakis Algorithm: Compact and Efficient Query Processing Under Updates 2017 SIGMOD 0.00013729015
949 DynaMat: A Dynamic View Management System for Data Warehouses 1999 SIGMOD 0.00012902181
1,054 Answering Complex SQL Queries Using Automatic Summary Tables 2000 SIGMOD 0.00012269068
1,779 Lazy Maintenance of Materialized Views 2007 VLDB 9.6583009e-05
1,853 Hypothetical Queries in an OLAP Environment 2000 VLDB 9.5001964e-05
1,945 Incremental Clustering for Mining in a Data Warehousing Environment 1998 VLDB 9.3257256e-05
2,663 A Layered Aggregate Engine for Analytics Workloads 2019 SIGMOD 8.1581558e-05
3,424 AQP++: Connecting Approximate Query Processing With Aggregate Precomputation for Interactive Analytics 2018 SIGMOD 7.3117029e-05
3,850 QC-Trees: An Efficient Summary Structure for Semantic OLAP 2003 SIGMOD 6.9801117e-05
3,984 Data Canopy: Accelerating Exploratory Statistical Analysis 2017 SIGMOD 6.8741188e-05
4,232 On the Content of Materialized Aggregate Views 2000 PODS 6.7145949e-05
4,268 Mapping Adaptation under Evolving Schemas 2003 VLDB 6.6964627e-05
4,552 Consistency in a Stream Warehouse 2011 CIDR 6.5395788e-05
5,200 Extending Practical Pre-Aggregation in On-Line Analytical Processing 1999 VLDB 6.2326019e-05
5,714 An Alternative Storage Organization for ROLAP Aggregate Views Based on Cubetrees 1998 SIGMOD 6.0202342e-05
5,839 Shrinking the Warehouse Update Window 1999 SIGMOD 5.9746195e-05
6,759 Performance Issues in Incremental Warehouse Maintenance 2000 VLDB 5.6888845e-05
6,804 Stacked Indexed Views in Microsoft SQL Server 2005 SIGMOD 5.6782614e-05
7,360 Kodiak: Leveraging Materialized Views For Very Low-Latency Analytics Over High-Dimensional Web-Scale Data 2016 VLDB 5.5427171e-05
7,446 DEX: Query Execution in a Delta-based Storage System 2017 SIGMOD 5.5242729e-05
7,542 Foreign Keys Open the Door for Faster Incremental View Maintenance 2023 SIGMOD 5.4986181e-05
8,386 Ajax-based Report Pages as Incrementally Rendered Views 2010 SIGMOD 5.3417391e-05
8,621 Maintenance of Cube Automatic Summary Tables 2000 SIGMOD 5.3012918e-05
10,885 Storing and Indexing Multiple Tables by Interesting Orderings: For Efficient Joins, Groupings, and Updates in Relational Databases 2026 VLDB 4.9793485e-05
13,149 Proxy-Server Architectures for OLAP 2001 SIGMOD 4.9793485e-05
13,173 Hierarchical Compact Cube for Range-Max Queries 2000 VLDB 4.9793485e-05
Previous Page 1 / 1 Next

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.00071084324
39 Efficiently Updating Materialized Views 1986 SIGMOD 0.00046602544
62 Maintaining Views Incrementally 1993 SIGMOD 0.00039045511
73 Including Group-By in Query Optimization 1994 VLDB 0.00037522101
213 Eager Aggregation and Lazy Aggregation 1995 VLDB 0.00024759805
214 On the Computation of Multidimensional Aggregates 1996 VLDB 0.00024656893
246 Deriving Production Rules for Incremental View Maintenance 1991 VLDB 0.00023212582
380 Maintenance Of Views 1984 SIGMOD 0.00019511838
388 Incremental Maintenance of Views with Duplicates 1995 SIGMOD 0.00019350381
398 View Maintenance in a Warehousing Environment 1995 SIGMOD 0.00019152162
723 A Performance Analysis of View Materialization Strategies 1987 SIGMOD 0.00014487177
1,150 Algorithms for Deferred View Maintenance 1996 SIGMOD 0.00011809311
2,115 View Maintenance Issues for the Chronicle Data Model (Extended Abstract) 1995 PODS 9.0155433e-05
2,962 A Framework for Supporting Data Integration Using the Materialized and Virtual Approaches 1996 SIGMOD 7.8061777e-05
3,631 Efficient Maintenance of Materialized Mediated Views (Extended Abstract) 1995 SIGMOD 7.1495656e-05
Previous Page 1 / 1 Next

Semantically Similar Papers

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