Database Paper Browser

Back to papers

On the Computation of Multidimensional Aggregates

Summary: Fast algorithms for CUBE operator, framing CUBE as a hierarchy of group-bys and extending sort- and hash-based aggregation. Optimizations: merge work across group-bys, caching, and precomputed group-bys; empirical results show speedups vs naive methods. (summarized by gpt-5-nano on Feb 09 2026)

Paper ID
8370
Venue
VLDB
Year
1996
Pagerank
0.00030927763
Overall Rank
247 | 98.29%
DOI
-

Incoming Non-self Citations Over Time

Authors

Incoming Citations (Sorted by Pagerank)

Showing 50 of 60 citing papers.

Rank Citing Paper Year Venue Pagerank
14 Online Aggregation 1997 SIGMOD 0.0010801504
273 Approximate Computation of Multidimensional Aggregates of Sparse Data Using Wavelets 1999 SIGMOD 0.00029390945
366 An Array-Based Algorithm for Simultaneous Multidimensional Aggregates 1997 SIGMOD 0.0002552977
460 SeeDB: Efficient Data-Driven Visualization Recommendations to Support Visual Analytics 2015 VLDB 0.00022516069
472 Bottom-Up Computation of Sparse and Iceberg CUBEs 1999 SIGMOD 0.00022346384
593 Storage Estimation for Multidimensional Aggregates in the Presence of Hierarchies 1996 VLDB 0.00019536993
681 Materialized View Selection in a Multidimensional Database 1997 VLDB 0.00018203591
962 Maintenance of Data Cubes and Summary Tables in a Warehouse 1997 SIGMOD 0.00014986226
981 DynaMat: A Dynamic View Management System for Data Warehouses 1999 SIGMOD 0.00014879532
1,021 Materialized View Selection for Multidimensional Datasets* 1998 VLDB 0.00014619259
1,191 Fast Computation of Sparse Datacubes 1997 VLDB 0.00013434201
1,359 Range Queries in OLAP Data Cubes 1997 SIGMOD 0.0001238588
1,575 Efficient Computation of the Skyline Cube 2005 VLDB 0.00011286884
1,887 Caching Multidimensional Queries Using Chunks 1998 SIGMOD 0.00010204659
2,190 Star-Cubing: Computing Iceberg Cubes by Top-Down and Bottom-Up Integration 2003 VLDB 9.3317645e-05
2,448 Multi-Dimensional Regression Analysis of Time-Series Data Streams 2002 VLDB 8.8032353e-05
2,662 Dwarf: Shrinking the PetaCube 2002 SIGMOD 8.3532302e-05
3,021 Adaptive and Big Data Scale Parallel Execution in Oracle 2013 VLDB 7.6991391e-05
3,030 DADA: A Data Cube for Dominant Relationship Analysis 2006 SIGMOD 7.6794959e-05
3,157 High-Dimensional OLAP: A Minimal Cubing Approach 2004 VLDB 7.4656511e-05
3,452 Refreshing the Sky: The Compressed Skycube with Efficient Support for Frequent Updates 2006 SIGMOD 7.0821774e-05
3,498 Cubetree: Organization of and Bulk Incremental Updates on the Data Cube 1997 SIGMOD 7.0389539e-05
3,807 Supporting Ad-hoc Ranking Aggregates 2006 SIGMOD 6.747576e-05
4,005 QC-Trees: An Efficient Summary Structure for Semantic OLAP 2003 SIGMOD 6.5414308e-05
4,082 On the Content of Materialized Aggregate Views 2000 PODS 6.4639136e-05
4,335 Optimization of Analytic Window Functions 2012 VLDB 6.2790346e-05
4,356 A Foundation for Multi-Dimensional Databases 1997 VLDB 6.2578525e-05
4,954 Aggregation Algorithms for Very Large Compressed Data Warehouses 1999 VLDB 5.8053789e-05
5,079 Combi-Operator – Database Support for Data Mining Applications 2003 VLDB 5.7140516e-05
5,191 Going Beyond Provenance: Explaining Query Answers with Pattern-based Counterbalances 2019 SIGMOD 5.6378768e-05
5,202 Mining Multi-Dimensional Constrained Gradients in Data Cubes 2001 VLDB 5.633298e-05
5,674 Efficient Allocation Algorithms for OLAP over Imprecise Data 2006 VLDB 5.377195e-05
5,736 Efficient Computation of Multiple Group By Queries 2005 SIGMOD 5.3482537e-05
5,837 An Alternative Storage Organization for ROLAP Aggregate Views Based on Cubetrees 1998 SIGMOD 5.3061106e-05
6,736 CURE for Cubes: Cubing Using a ROLAP Engine 2006 VLDB 4.9459588e-05
6,967 FlowCube: Constructing RFID FlowCubes for Multi-Dimensional Analysis of Commodity Flows 2006 VLDB 4.8803582e-05
7,081 The Polynomial Complexity of Fully Materialized Coalesced Cubes 2004 VLDB 4.8413336e-05
8,189 Cohort Query Processing 2017 VLDB 4.5642142e-05
9,175 Efficient Exploration of Interesting Aggregates in RDF Graphs 2021 SIGMOD 4.383548e-05
9,644 Fair and Actionable Causal Prescription Ruleset 2025 SIGMOD 4.3109001e-05
9,688 Iceberg-cube Computation with PC Clusters 2001 SIGMOD 4.3047774e-05
9,850 COMPARE: Accelerating Groupwise Comparison in Relational Databases for Data Analytics 2021 VLDB 4.2721228e-05
10,152 Data-Semantics-Aware Recommendation of Diverse Pivot Tables 2026 SIGMOD 4.1945683e-05
10,740 Finding Convincing Views to Endorse a Claim 2025 VLDB 4.1945683e-05
11,411 High-dimensional Data Cubes 2022 VLDB 4.1945683e-05
11,419 On Detecting Cherry-picked Generalizations 2022 VLDB 4.1945683e-05
11,709 Robust, Scalable, Real-Time Event Time Series Aggregation at Twitter 2018 SIGMOD 4.1945683e-05
11,835 An Efficient MapReduce Cube Algorithm for Varied Data Distributions 2016 SIGMOD 4.1945683e-05
12,098 Permuting Data on Random-Access Block Storage 2013 VLDB 4.1945683e-05
12,448 BIwTL: A Business Information Warehouse Toolkit and Language for Warehousing Simplification and Automation 2007 SIGMOD 4.1945683e-05
Previous Page 1 / 2 Next

Outgoing Citations (Sorted by Pagerank)

Showing 5 of 5 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.0011708144
59 Sampling-Based Estimation of the Number of Distinct Values of an Attribute 1995 VLDB 0.00064501896
89 Statistical Databases: Characteristics, Problems, and Some Solutions 1982 VLDB 0.0005230007
593 Storage Estimation for Multidimensional Aggregates in the Presence of Hierarchies 1996 VLDB 0.00019536993
1,674 Adaptive Parallel Aggregation Algorithms 1995 SIGMOD 0.0001094787
Previous Page 1 / 1 Next

Semantically Similar Papers

Overall Rank Paper Year Venue Pagerank
11,411 High-dimensional Data Cubes 2022 VLDB 4.1945683e-05
12,728 Dynamic Assembly of Views in Data Cubes 1998 PODS 4.1945683e-05
767 Explaining differences in multidimensional aggregates 1999 VLDB 0.00016981309
3,498 Cubetree: Organization of and Bulk Incremental Updates on the Data Cube 1997 SIGMOD 7.0389539e-05
7,081 The Polynomial Complexity of Fully Materialized Coalesced Cubes 2004 VLDB 4.8413336e-05
1,191 Fast Computation of Sparse Datacubes 1997 VLDB 0.00013434201
1,955 Efficient Computation of Iceberg Cubes with Complex Measures 2001 SIGMOD 9.9629452e-05
4,954 Aggregation Algorithms for Very Large Compressed Data Warehouses 1999 VLDB 5.8053789e-05
3,157 High-Dimensional OLAP: A Minimal Cubing Approach 2004 VLDB 7.4656511e-05
366 An Array-Based Algorithm for Simultaneous Multidimensional Aggregates 1997 SIGMOD 0.0002552977