DBScholar

Back to papers

On the Computation of Multidimensional Aggregates

Summary: Introduces a hierarchy-based view of CUBE computation, enabling shared work across all attribute-subset group-bys. Extends sort- and hash-based aggregation with caching and reuse of precomputed results, substantially outperforming naive independent group-by evaluation. (summarized by gpt-5.6-luna on Jul 24 2026)

Paper ID
h5435db687a127ece
Venue
VLDB
Year
1996
Pagerank
0.00024576033
Overall Rank
214 | 98.57%
DOI
-

Incoming Non-self Citations Over Time

Authors

BibTeX Citation

@article{agarwal_vldb96,
        title = {{On the Computation of Multidimensional Aggregates}},
        author = {Agarwal, Sameer and Naughton, Jeffrey F. and Agrawal, Rakesh and Ramakrishnan, Raghu and Deshpande, Prasad M. and Sarawagi, Sunita and Gupta, Ashish},
        journal = {PVLDB},
        series = {{VLDB} '96},
        pages = {506--521},
        year = {1996}
}

Incoming Citations (Sorted by Pagerank)

Showing 50 of 60 citing papers.

Rank Citing Paper Year Venue Pagerank
9 Online Aggregation 1997 SIGMOD 0.00076079812
222 Approximate Computation of Multidimensional Aggregates of Sparse Data Using Wavelets 1999 SIGMOD 0.00024136952
324 An Array-Based Algorithm for Simultaneous Multidimensional Aggregates 1997 SIGMOD 0.00020934349
395 SeeDB: Efficient Data-Driven Visualization Recommendations to Support Visual Analytics 2015 VLDB 0.00019125046
404 Bottom-Up Computation of Sparse and Iceberg CUBEs 1999 SIGMOD 0.00019034819
648 Materialized View Selection in a Multidimensional Database 1997 VLDB 0.00015161755
660 Storage Estimation for Multidimensional Aggregates in the Presence of Hierarchies 1996 VLDB 0.00015022694
904 Maintenance of Data Cubes and Summary Tables in a Warehouse 1997 SIGMOD 0.00013138723
953 DynaMat: A Dynamic View Management System for Data Warehouses 1999 SIGMOD 0.0001287248
961 Materialized View Selection for Multidimensional Datasets 1998 VLDB 0.0001281898
1,073 Fast Computation of Sparse Datacubes 1997 VLDB 0.00012140291
1,110 Range Queries in OLAP Data Cubes 1997 SIGMOD 0.00011949109
1,401 Efficient Computation of the Skyline Cube 2005 VLDB 0.0001075604
1,779 Caching Multidimensional Queries Using Chunks 1998 SIGMOD 9.6641413e-05
2,222 Multi-Dimensional Regression Analysis of Time-Series Data Streams 2002 VLDB 8.8048988e-05
2,270 Dwarf: Shrinking the PetaCube 2002 SIGMOD 8.7112055e-05
2,527 Adaptive and Big Data Scale Parallel Execution in Oracle 2013 VLDB 8.3243069e-05
2,550 Star-Cubing: Computing Iceberg Cubes by Top-Down and Bottom-Up Integration 2003 VLDB 8.2869953e-05
2,795 DADA: A Data Cube for Dominant Relationship Analysis 2006 SIGMOD 7.9865595e-05
3,346 Refreshing the Sky: The Compressed Skycube with Efficient Support for Frequent Updates 2006 SIGMOD 7.3804433e-05
3,454 Cubetree: Organization of and Bulk Incremental Updates on the Data Cube 1997 SIGMOD 7.270801e-05
3,793 Supporting Ad-hoc Ranking Aggregates 2006 SIGMOD 6.9967739e-05
3,842 Optimization of Analytic Window Functions 2012 VLDB 6.968919e-05
3,850 High-Dimensional OLAP: A Minimal Cubing Approach 2004 VLDB 6.9646837e-05
3,859 QC-Trees: An Efficient Summary Structure for Semantic OLAP 2003 SIGMOD 6.9540456e-05
4,246 On the Content of Materialized Aggregate Views 2000 PODS 6.694623e-05
4,256 A Foundation for Multi-Dimensional Databases 1997 VLDB 6.6847353e-05
4,742 Going Beyond Provenance: Explaining Query Answers with Pattern-based Counterbalances 2019 SIGMOD 6.4285195e-05
4,820 Aggregation Algorithms for Very Large Compressed Data Warehouses 1999 VLDB 6.3880163e-05
5,598 Efficient Computation of Multiple Group By Queries 2005 SIGMOD 6.053914e-05
5,647 Combi-Operator – Database Support for Data Mining Applications 2003 VLDB 6.0352838e-05
5,708 Efficient Allocation Algorithms for OLAP over Imprecise Data 2006 VLDB 6.0107692e-05
5,729 An Alternative Storage Organization for ROLAP Aggregate Views Based on Cubetrees 1998 SIGMOD 5.9975458e-05
6,093 Mining Multi-Dimensional Constrained Gradients in Data Cubes 2001 VLDB 5.8718468e-05
6,818 CURE for Cubes: Cubing Using a ROLAP Engine 2006 VLDB 5.6589988e-05
6,956 FlowCube: Constructing RFID FlowCubes for Multi-Dimensional Analysis of Commodity Flows 2006 VLDB 5.6192994e-05
7,067 The Polynomial Complexity of Fully Materialized Coalesced Cubes 2004 VLDB 5.5926201e-05
8,345 Cohort Query Processing 2017 VLDB 5.3339863e-05
9,555 Efficient Exploration of Interesting Aggregates in RDF Graphs 2021 SIGMOD 5.1487688e-05
9,612 On Detecting Cherry-picked Generalizations 2022 VLDB 5.1376962e-05
9,990 Fair and Actionable Causal Prescription Ruleset 2025 SIGMOD 5.0845476e-05
10,053 Iceberg-cube Computation with PC Clusters 2001 SIGMOD 5.0786422e-05
10,225 COMPARE: Accelerating Groupwise Comparison in Relational Databases for Data Analytics 2021 VLDB 5.0460607e-05
10,702 Data-Semantics-Aware Recommendation of Diverse Pivot Tables 2026 SIGMOD 4.9605343e-05
11,422 Finding Convincing Views to Endorse a Claim 2025 VLDB 4.9605343e-05
11,967 High-dimensional Data Cubes 2022 VLDB 4.9605343e-05
12,262 Robust, Scalable, Real-Time Event Time Series Aggregation at Twitter 2018 SIGMOD 4.9605343e-05
12,380 An Efficient MapReduce Cube Algorithm for Varied Data Distributions 2016 SIGMOD 4.9605343e-05
12,635 Permuting Data on Random-Access Block Storage 2013 VLDB 4.9605343e-05
12,980 BIwTL: A Business Information Warehouse Toolkit and Language for Warehousing Simplification and Automation 2007 SIGMOD 4.9605343e-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.00070860346
78 Sampling-Based Estimation of the Number of Distinct Values of an Attribute 1995 VLDB 0.00036725074
263 Statistical Databases: Characteristics, Problems, and Some Solutions 1982 VLDB 0.00022797298
660 Storage Estimation for Multidimensional Aggregates in the Presence of Hierarchies 1996 VLDB 0.00015022694
1,633 Adaptive Parallel Aggregation Algorithms 1995 SIGMOD 0.00010002415
Previous Page 1 / 1 Next

Semantically Similar Papers

# Overall Rank Paper Year Venue
1 11,967 High-dimensional Data Cubes 2022 VLDB
2 13,258 Dynamic Assembly of Views in Data Cubes 1998 PODS
3 700 Explaining differences in multidimensional aggregates 1999 VLDB
4 3,454 Cubetree: Organization of and Bulk Incremental Updates on the Data Cube 1997 SIGMOD
5 7,067 The Polynomial Complexity of Fully Materialized Coalesced Cubes 2004 VLDB
6 1,073 Fast Computation of Sparse Datacubes 1997 VLDB
7 1,883 Efficient Computation of Iceberg Cubes with Complex Measures 2001 SIGMOD
8 4,820 Aggregation Algorithms for Very Large Compressed Data Warehouses 1999 VLDB
9 3,850 High-Dimensional OLAP: A Minimal Cubing Approach 2004 VLDB
10 324 An Array-Based Algorithm for Simultaneous Multidimensional Aggregates 1997 SIGMOD