DBScholar

Back to papers

An Array-Based Algorithm for Simultaneous Multidimensional Aggregates

Summary: Array-based MOLAP algorithm for computing the Cube on sparse multidimensional arrays. With compression, it outperforms leading ROLAP cube algorithms and suggests converting tables to arrays before cubing to accelerate OLAP workloads. (summarized by gpt-5-nano on Feb 09 2026)

Paper ID
3005
Venue
SIGMOD
Year
1997
Pagerank
0.00021200835
Overall Rank
324 | 97.78%
DOI
10.1145/253260.253288

Incoming Non-self Citations Over Time

Authors

BibTeX Citation

@inproceedings{zhao_sigmod97,
        title = {{An Array-Based Algorithm for Simultaneous Multidimensional Aggregates}},
        author = {Zhao, Yihong and Deshpande, Prasad M. and Naughton, Jeffrey F.},
        series = {{SIGMOD} '97},
        booktitle = {Proceedings of the {ACM} {SIGMOD} International Conference on Management of Data},
        publisher = {Association for Computing Machinery},
        doi = {10.1145/253260.253288},
        url = {https://dl.acm.org/doi/10.1145/253260.253288},
        year = {1997}
}

Incoming Citations (Sorted by Pagerank)

Showing 41 of 41 citing papers.

Rank Citing Paper Year Venue Pagerank
12 C-Store: A Column-oriented DBMS 2005 VLDB 0.00069513174
213 Approximate Computation of Multidimensional Aggregates of Sparse Data Using Wavelets 1999 SIGMOD 0.00024723025
393 Bottom-Up Computation of Sparse and Iceberg CUBEs 1999 SIGMOD 0.0001934104
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,360 Efficient Computation of the Skyline Cube 2005 VLDB 0.00011040203
1,680 Online Dynamic Reordering for Interactive Data Processing 1999 VLDB 0.00010024295
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,882 OLAP and Statistical Databases: Similarities and Differences 1997 PODS 8.0016585e-05
3,451 GridDB: A Data-Centric Overlay for Scientific Grids 2004 VLDB 7.4033802e-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
3,930 Data Canopy: Accelerating Exploratory Statistical Analysis 2017 SIGMOD 7.0102082e-05
4,204 MDL Summarization with Holes 2005 VLDB 6.834169e-05
4,252 An Adaptive Peer-to-Peer Network for Distributed Caching of OLAP Results 2002 SIGMOD 6.8029543e-05
4,723 Aggregation Algorithms for Very Large Compressed Data Warehouses 1999 VLDB 6.5389699e-05
4,730 A Lower Bound Theorem for Indexing Schemes and its Application to Multidimensional Range Queries 1998 PODS 6.5348792e-05
5,500 Combi-Operator – Database Support for Data Mining Applications 2003 VLDB 6.1968585e-05
5,638 An Alternative Storage Organization for ROLAP Aggregate Views Based on Cubetrees 1998 SIGMOD 6.138684e-05
6,618 Spade: A Modular Framework for Analytical Exploration of RDF Graphs 2019 VLDB 5.8212982e-05
6,658 CURE for Cubes: Cubing Using a ROLAP Engine 2006 VLDB 5.8104851e-05
6,670 Replicated Layout for In-Memory Database Systems 2022 VLDB 5.8074043e-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
8,649 ARCube: Supporting Ranking Aggregate Queries in Partially Materialized Data Cubes 2008 SIGMOD 5.3916641e-05
8,974 MetaInsight: Automatic Discovery of Structured Knowledge for Exploratory Data Analysis 2021 SIGMOD 5.3413784e-05
9,339 Efficient Exploration of Interesting Aggregates in RDF Graphs 2021 SIGMOD 5.2869213e-05
9,824 Iceberg-cube Computation with PC Clusters 2001 SIGMOD 5.214913e-05
11,609 High-dimensional Data Cubes 2022 VLDB 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,844 A One-Pass Aggregation Algorithm with the Optimal Buffer Size in Multidimensional OLAP 2002 VLDB 5.093636e-05
12,859 Proxy-Server Architectures for OLAP 2001 SIGMOD 5.093636e-05
12,885 Decision Tables: Scalable Classification Exploring RDBMS Capabilities 2000 VLDB 5.093636e-05
12,921 Dynamic Assembly of Views in Data Cubes 1998 PODS 5.093636e-05
12,935 nD-SQL: A Multi-dimensional Language for Interoperability and OLAP 1998 VLDB 5.093636e-05
Previous Page 1 / 1 Next

Outgoing Citations (Sorted by Pagerank)

Showing 2 of 2 cited papers.

Citations counted here include only citations to other VLDB/SIGMOD/CIDR/PODS papers in this database.

Rank Cited Paper Year Venue Pagerank
7 Implementation Techniques For Main Memory Database Systems 1984 SIGMOD 0.00083340894
207 On the Computation of Multidimensional Aggregates 1996 VLDB 0.00025088003
Previous Page 1 / 1 Next

Semantically Similar Papers

# Overall Rank Paper Year Venue
1 4,166 A Foundation for Multi-Dimensional Databases 1997 VLDB
2 1,687 Spreadsheets in RDBMS for OLAP 2003 SIGMOD
3 12,844 A One-Pass Aggregation Algorithm with the Optimal Buffer Size in Multidimensional OLAP 2002 VLDB
4 1,107 Simultaneous Optimization and Evaluation of Multiple Dimensional Queries 1998 SIGMOD
5 700 Explaining differences in multidimensional aggregates 1999 VLDB
6 5,638 An Alternative Storage Organization for ROLAP Aggregate Views Based on Cubetrees 1998 SIGMOD
7 213 Approximate Computation of Multidimensional Aggregates of Sparse Data Using Wavelets 1999 SIGMOD
8 3,753 High-Dimensional OLAP: A Minimal Cubing Approach 2004 VLDB
9 4,723 Aggregation Algorithms for Very Large Compressed Data Warehouses 1999 VLDB
10 207 On the Computation of Multidimensional Aggregates 1996 VLDB