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
8561
Venue
VLDB
Year
1996
Pagerank
0.00025088003
Overall Rank
207 | 98.59%
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.00077458002
213 Approximate Computation of Multidimensional Aggregates of Sparse Data Using Wavelets 1999 SIGMOD 0.00024723025
324 An Array-Based Algorithm for Simultaneous Multidimensional Aggregates 1997 SIGMOD 0.00021200835
393 Bottom-Up Computation of Sparse and Iceberg CUBEs 1999 SIGMOD 0.0001934104
410 SeeDB: Efficient Data-Driven Visualization Recommendations to Support Visual Analytics 2015 VLDB 0.0001890421
638 Materialized View Selection in a Multidimensional Database 1997 VLDB 0.000154719
654 Storage Estimation for Multidimensional Aggregates in the Presence of Hierarchies 1996 VLDB 0.0001527187
905 Maintenance of Data Cubes and Summary Tables in a Warehouse 1997 SIGMOD 0.0001331508
942 Materialized View Selection for Multidimensional Datasets 1998 VLDB 0.00013076262
943 DynaMat: A Dynamic View Management System for Data Warehouses 1999 SIGMOD 0.00013068595
1,083 Fast Computation of Sparse Datacubes 1997 VLDB 0.00012256953
1,100 Range Queries in OLAP Data Cubes 1997 SIGMOD 0.00012169143
1,360 Efficient Computation of the Skyline Cube 2005 VLDB 0.00011040203
1,732 Caching Multidimensional Queries Using Chunks 1998 SIGMOD 9.9065981e-05
2,171 Multi-Dimensional Regression Analysis of Time-Series Data Streams 2002 VLDB 9.0406168e-05
2,318 Dwarf: Shrinking the PetaCube 2002 SIGMOD 8.7588859e-05
2,496 Star-Cubing: Computing Iceberg Cubes by Top-Down and Bottom-Up Integration 2003 VLDB 8.5025699e-05
2,664 Adaptive and Big Data Scale Parallel Execution in Oracle 2013 VLDB 8.2816537e-05
2,730 DADA: A Data Cube for Dominant Relationship Analysis 2006 SIGMOD 8.1977425e-05
3,273 Refreshing the Sky: The Compressed Skycube with Efficient Support for Frequent Updates 2006 SIGMOD 7.5768045e-05
3,379 Cubetree: Organization of and Bulk Incremental Updates on the Data Cube 1997 SIGMOD 7.4582502e-05
3,706 Supporting Ad-hoc Ranking Aggregates 2006 SIGMOD 7.1819534e-05
3,753 High-Dimensional OLAP: A Minimal Cubing Approach 2004 VLDB 7.1505817e-05
3,774 QC-Trees: An Efficient Summary Structure for Semantic OLAP 2003 SIGMOD 7.1381444e-05
4,020 Optimization of Analytic Window Functions 2012 VLDB 6.9513881e-05
4,155 On the Content of Materialized Aggregate Views 2000 PODS 6.866935e-05
4,166 A Foundation for Multi-Dimensional Databases 1997 VLDB 6.8583043e-05
4,638 Going Beyond Provenance: Explaining Query Answers with Pattern-based Counterbalances 2019 SIGMOD 6.5919801e-05
4,723 Aggregation Algorithms for Very Large Compressed Data Warehouses 1999 VLDB 6.5389699e-05
5,470 Efficient Computation of Multiple Group By Queries 2005 SIGMOD 6.2070458e-05
5,500 Combi-Operator – Database Support for Data Mining Applications 2003 VLDB 6.1968585e-05
5,565 Efficient Allocation Algorithms for OLAP over Imprecise Data 2006 VLDB 6.171506e-05
5,638 An Alternative Storage Organization for ROLAP Aggregate Views Based on Cubetrees 1998 SIGMOD 6.138684e-05
5,955 Mining Multi-Dimensional Constrained Gradients in Data Cubes 2001 VLDB 6.0290092e-05
6,658 CURE for Cubes: Cubing Using a ROLAP Engine 2006 VLDB 5.8104851e-05
6,800 FlowCube: Constructing RFID FlowCubes for Multi-Dimensional Analysis of Commodity Flows 2006 VLDB 5.7700096e-05
6,902 The Polynomial Complexity of Fully Materialized Coalesced Cubes 2004 VLDB 5.7426524e-05
8,176 Cohort Query Processing 2017 VLDB 5.4736785e-05
9,339 Efficient Exploration of Interesting Aggregates in RDF Graphs 2021 SIGMOD 5.2869213e-05
9,773 Fair and Actionable Causal Prescription Ruleset 2025 SIGMOD 5.2209769e-05
9,824 Iceberg-cube Computation with PC Clusters 2001 SIGMOD 5.214913e-05
10,002 COMPARE: Accelerating Groupwise Comparison in Relational Databases for Data Analytics 2021 VLDB 5.1814573e-05
10,441 Data-Semantics-Aware Recommendation of Diverse Pivot Tables 2026 SIGMOD 5.093636e-05
10,979 Finding Convincing Views to Endorse a Claim 2025 VLDB 5.093636e-05
11,609 High-dimensional Data Cubes 2022 VLDB 5.093636e-05
11,617 On Detecting Cherry-picked Generalizations 2022 VLDB 5.093636e-05
11,914 Robust, Scalable, Real-Time Event Time Series Aggregation at Twitter 2018 SIGMOD 5.093636e-05
12,036 An Efficient MapReduce Cube Algorithm for Varied Data Distributions 2016 SIGMOD 5.093636e-05
12,295 Permuting Data on Random-Access Block Storage 2013 VLDB 5.093636e-05
12,642 BIwTL: A Business Information Warehouse Toolkit and Language for Warehousing Simplification and Automation 2007 SIGMOD 5.093636e-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.00071822821
75 Sampling-Based Estimation of the Number of Distinct Values of an Attribute 1995 VLDB 0.00037277061
249 Statistical Databases: Characteristics, Problems, and Some Solutions 1982 VLDB 0.00023275528
654 Storage Estimation for Multidimensional Aggregates in the Presence of Hierarchies 1996 VLDB 0.0001527187
1,596 Adaptive Parallel Aggregation Algorithms 1995 SIGMOD 0.00010247091
Previous Page 1 / 1 Next

Semantically Similar Papers

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