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.00020934349
Overall Rank
324 | 97.83%
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.00068985264
222 Approximate Computation of Multidimensional Aggregates of Sparse Data Using Wavelets 1999 SIGMOD 0.00024136952
404 Bottom-Up Computation of Sparse and Iceberg CUBEs 1999 SIGMOD 0.00019034819
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,401 Efficient Computation of the Skyline Cube 2005 VLDB 0.0001075604
1,713 Online Dynamic Reordering for Interactive Data Processing 1999 VLDB 9.7948649e-05
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,550 Star-Cubing: Computing Iceberg Cubes by Top-Down and Bottom-Up Integration 2003 VLDB 8.2869953e-05
2,946 OLAP and Statistical Databases: Similarities and Differences 1997 PODS 7.81162e-05
3,526 GridDB: A Data-Centric Overlay for Scientific Grids 2004 VLDB 7.2154696e-05
3,793 Supporting Ad-hoc Ranking Aggregates 2006 SIGMOD 6.9967739e-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
3,993 Data Canopy: Accelerating Exploratory Statistical Analysis 2017 SIGMOD 6.8565106e-05
4,298 MDL Summarization with Holes 2005 VLDB 6.6640493e-05
4,364 An Adaptive Peer-to-Peer Network for Distributed Caching of OLAP Results 2002 SIGMOD 6.6263565e-05
4,820 Aggregation Algorithms for Very Large Compressed Data Warehouses 1999 VLDB 6.3880163e-05
4,862 A Lower Bound Theorem for Indexing Schemes and its Application to Multidimensional Range Queries 1998 PODS 6.3646378e-05
5,647 Combi-Operator – Database Support for Data Mining Applications 2003 VLDB 6.0352838e-05
5,729 An Alternative Storage Organization for ROLAP Aggregate Views Based on Cubetrees 1998 SIGMOD 5.9975458e-05
6,730 Replicated Layout for In-Memory Database Systems 2022 VLDB 5.6801409e-05
6,772 Spade: A Modular Framework for Analytical Exploration of RDF Graphs 2019 VLDB 5.669182e-05
6,818 CURE for Cubes: Cubing Using a ROLAP Engine 2006 VLDB 5.6589988e-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
8,841 ARCube: Supporting Ranking Aggregate Queries in Partially Materialized Data Cubes 2008 SIGMOD 5.2511874e-05
9,170 MetaInsight: Automatic Discovery of Structured Knowledge for Exploratory Data Analysis 2021 SIGMOD 5.2018029e-05
9,555 Efficient Exploration of Interesting Aggregates in RDF Graphs 2021 SIGMOD 5.1487688e-05
10,053 Iceberg-cube Computation with PC Clusters 2001 SIGMOD 5.0786422e-05
10,870 Finding Non-Redundant Simpson's Paradox in Multidimensional Data 2026 VLDB 4.9605343e-05
11,967 High-dimensional Data Cubes 2022 VLDB 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
13,181 A One-Pass Aggregation Algorithm with the Optimal Buffer Size in Multidimensional OLAP 2002 VLDB 4.9605343e-05
13,196 Proxy-Server Architectures for OLAP 2001 SIGMOD 4.9605343e-05
13,222 Decision Tables: Scalable Classification Exploring RDBMS Capabilities 2000 VLDB 4.9605343e-05
13,258 Dynamic Assembly of Views in Data Cubes 1998 PODS 4.9605343e-05
13,272 nD-SQL: A Multi-dimensional Language for Interoperability and OLAP 1998 VLDB 4.9605343e-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.00081781676
214 On the Computation of Multidimensional Aggregates 1996 VLDB 0.00024576033
Previous Page 1 / 1 Next

Semantically Similar Papers

# Overall Rank Paper Year Venue
1 4,256 A Foundation for Multi-Dimensional Databases 1997 VLDB
2 1,725 Spreadsheets in RDBMS for OLAP 2003 SIGMOD
3 13,181 A One-Pass Aggregation Algorithm with the Optimal Buffer Size in Multidimensional OLAP 2002 VLDB
4 1,131 Simultaneous Optimization and Evaluation of Multiple Dimensional Queries 1998 SIGMOD
5 700 Explaining differences in multidimensional aggregates 1999 VLDB
6 5,729 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,850 High-Dimensional OLAP: A Minimal Cubing Approach 2004 VLDB
9 4,820 Aggregation Algorithms for Very Large Compressed Data Warehouses 1999 VLDB
10 214 On the Computation of Multidimensional Aggregates 1996 VLDB