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
ha92231e7c0882f39
Venue
SIGMOD
Year
1997
Pagerank
0.00020991685
Overall Rank
323 | 97.84%
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 42 of 42 citing papers.

Rank Citing Paper Year Venue Pagerank
12 C-Store: A Column-oriented DBMS 2005 VLDB 0.0006897844
222 Approximate Computation of Multidimensional Aggregates of Sparse Data Using Wavelets 1999 SIGMOD 0.00024210103
403 Bottom-Up Computation of Sparse and Iceberg CUBEs 1999 SIGMOD 0.00019094951
949 DynaMat: A Dynamic View Management System for Data Warehouses 1999 SIGMOD 0.00012897003
957 Materialized View Selection for Multidimensional Datasets 1998 VLDB 0.00012855863
1,069 Fast Computation of Sparse Datacubes 1997 VLDB 0.00012179752
1,395 Efficient Computation of the Skyline Cube 2005 VLDB 0.00010791312
1,703 Online Dynamic Reordering for Interactive Data Processing 1999 VLDB 9.8269486e-05
1,766 Caching Multidimensional Queries Using Chunks 1998 SIGMOD 9.6923431e-05
2,210 Multi-Dimensional Regression Analysis of Time-Series Data Streams 2002 VLDB 8.8340718e-05
2,257 Dwarf: Shrinking the PetaCube 2002 SIGMOD 8.7397925e-05
2,544 Star-Cubing: Computing Iceberg Cubes by Top-Down and Bottom-Up Integration 2003 VLDB 8.3140577e-05
2,933 OLAP and Statistical Databases: Similarities and Differences 1997 PODS 7.8366447e-05
3,516 GridDB: A Data-Centric Overlay for Scientific Grids 2004 VLDB 7.2392707e-05
3,784 Supporting Ad-hoc Ranking Aggregates 2006 SIGMOD 7.0197908e-05
3,842 High-Dimensional OLAP: A Minimal Cubing Approach 2004 VLDB 6.9871413e-05
3,851 QC-Trees: An Efficient Summary Structure for Semantic OLAP 2003 SIGMOD 6.9768367e-05
3,985 Data Canopy: Accelerating Exploratory Statistical Analysis 2017 SIGMOD 6.8708857e-05
4,284 MDL Summarization with Holes 2005 VLDB 6.6859406e-05
4,341 An Adaptive Peer-to-Peer Network for Distributed Caching of OLAP Results 2002 SIGMOD 6.6482379e-05
4,801 Aggregation Algorithms for Very Large Compressed Data Warehouses 1999 VLDB 6.4084577e-05
4,837 A Lower Bound Theorem for Indexing Schemes and its Application to Multidimensional Range Queries 1998 PODS 6.3852778e-05
5,634 Combi-Operator – Database Support for Data Mining Applications 2003 VLDB 6.0552789e-05
5,716 An Alternative Storage Organization for ROLAP Aggregate Views Based on Cubetrees 1998 SIGMOD 6.0173987e-05
6,715 Replicated Layout for In-Memory Database Systems 2022 VLDB 5.6989853e-05
6,752 Spade: A Modular Framework for Analytical Exploration of RDF Graphs 2019 VLDB 5.68799e-05
6,800 CURE for Cubes: Cubing Using a ROLAP Engine 2006 VLDB 5.677773e-05
7,046 The Polynomial Complexity of Fully Materialized Coalesced Cubes 2004 VLDB 5.6111702e-05
8,331 Cohort Query Processing 2017 VLDB 5.3516823e-05
8,824 ARCube: Supporting Ranking Aggregate Queries in Partially Materialized Data Cubes 2008 SIGMOD 5.2685089e-05
9,148 MetaInsight: Automatic Discovery of Structured Knowledge for Exploratory Data Analysis 2021 SIGMOD 5.2190604e-05
9,528 Efficient Exploration of Interesting Aggregates in RDF Graphs 2021 SIGMOD 5.1658503e-05
10,017 Iceberg-cube Computation with PC Clusters 2001 SIGMOD 5.0954911e-05
10,809 Finding Non-Redundant Simpson's Paradox in Multidimensional Data 2026 VLDB 4.9769913e-05
11,923 High-dimensional Data Cubes 2022 VLDB 4.9769913e-05
12,337 An Efficient MapReduce Cube Algorithm for Varied Data Distributions 2016 SIGMOD 4.9769913e-05
12,592 Permuting Data on Random-Access Block Storage 2013 VLDB 4.9769913e-05
13,140 A One-Pass Aggregation Algorithm with the Optimal Buffer Size in Multidimensional OLAP 2002 VLDB 4.9769913e-05
13,155 Proxy-Server Architectures for OLAP 2001 SIGMOD 4.9769913e-05
13,181 Decision Tables: Scalable Classification Exploring RDBMS Capabilities 2000 VLDB 4.9769913e-05
13,217 Dynamic Assembly of Views in Data Cubes 1998 PODS 4.9769913e-05
13,231 nD-SQL: A Multi-dimensional Language for Interoperability and OLAP 1998 VLDB 4.9769913e-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.00081971778
214 On the Computation of Multidimensional Aggregates 1996 VLDB 0.00024650285
Previous Page 1 / 1 Next

Semantically Similar Papers

# Overall Rank Paper Year Venue
1 4,238 A Foundation for Multi-Dimensional Databases 1997 VLDB
2 1,715 Spreadsheets in RDBMS for OLAP 2003 SIGMOD
3 13,140 A One-Pass Aggregation Algorithm with the Optimal Buffer Size in Multidimensional OLAP 2002 VLDB
4 1,127 Simultaneous Optimization and Evaluation of Multiple Dimensional Queries 1998 SIGMOD
5 701 Explaining differences in multidimensional aggregates 1999 VLDB
6 5,716 An Alternative Storage Organization for ROLAP Aggregate Views Based on Cubetrees 1998 SIGMOD
7 222 Approximate Computation of Multidimensional Aggregates of Sparse Data Using Wavelets 1999 SIGMOD
8 3,842 High-Dimensional OLAP: A Minimal Cubing Approach 2004 VLDB
9 4,801 Aggregation Algorithms for Very Large Compressed Data Warehouses 1999 VLDB
10 214 On the Computation of Multidimensional Aggregates 1996 VLDB