DBScholar

Back to papers

Implementing Data Cubes Efficiently

Summary: Uses a view-dependency lattice to decide which data-cube cells to materialize when full materialization is infeasible; greedy algorithms yield constant-factor near-optimality. Hypercube-lattice focus, detailing space–time tradeoffs and practical materialization strategies for fast aggregates. (summarized by gpt-5-nano on Feb 09 2026)

Paper ID
h4a0ff95cf478c628
Venue
SIGMOD
Year
1996
Pagerank
0.00070860346
Overall Rank
11 | 99.93%
DOI
10.1145/233269.233333

Incoming Non-self Citations Over Time

Authors

BibTeX Citation

@inproceedings{harinarayan_sigmod96,
        title = {{Implementing Data Cubes Efficiently}},
        author = {Harinarayan, Venky and Rajaraman, Anand and Ullman, Jeffrey D.},
        series = {{SIGMOD} '96},
        booktitle = {Proceedings of the {ACM} {SIGMOD} International Conference on Management of Data},
        publisher = {Association for Computing Machinery},
        doi = {10.1145/233269.233333},
        url = {https://dl.acm.org/doi/10.1145/233269.233333},
        year = {1996}
}

Incoming Citations (Sorted by Pagerank)

Showing 50 of 127 citing papers.

Rank Citing Paper Year Venue Pagerank
3,292 Searchlight: Enabling Integrated Search and Exploration over Large Multidimensional Data 2015 VLDB 7.4344621e-05
3,435 AQP++: Connecting Approximate Query Processing With Aggregate Precomputation for Interactive Analytics 2018 SIGMOD 7.2845431e-05
3,438 Efficient Processing of Window Functions in Analytical SQL Queries 2015 VLDB 7.2807703e-05
3,454 Cubetree: Organization of and Bulk Incremental Updates on the Data Cube 1997 SIGMOD 7.270801e-05
3,457 Apache Hive: From MapReduce to Enterprise-grade Big Data Warehousing 2019 SIGMOD 7.2667942e-05
3,550 Computation Reuse in Analytics Job Service at Microsoft 2018 SIGMOD 7.1895215e-05
3,793 Supporting Ad-hoc Ranking Aggregates 2006 SIGMOD 6.9967739e-05
3,795 Entity Resolution with Evolving Rules 2010 VLDB 6.9962459e-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,935 Effective Caching of Shortest Paths for Location-Based Services 2012 SIGMOD 6.8990945e-05
3,979 On Efficiently Implementing SchemaSQL on a SQL Database System 1999 VLDB 6.8700205e-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,298 MDL Summarization with Holes 2005 VLDB 6.6640493e-05
4,307 Efficient Algorithms for Exact Ranked Twig-Pattern Matching over Graphs 2008 SIGMOD 6.6581902e-05
4,364 An Adaptive Peer-to-Peer Network for Distributed Caching of OLAP Results 2002 SIGMOD 6.6263565e-05
4,386 Multi-Structural Databases 2005 PODS 6.6137721e-05
4,737 Multiple Aggregations Over Data Streams 2005 SIGMOD 6.4301074e-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
4,826 Fast Data Anonymization with Low Information Loss 2007 VLDB 6.3853698e-05
5,028 User-Defined Aggregate Functions: Bridging Theory and Practice 2006 SIGMOD 6.2956973e-05
5,152 iTrails: Pay-as-you-go Information Integration in Dataspaces 2007 VLDB 6.2375943e-05
5,198 Extending Practical Pre-Aggregation in On-Line Analytical Processing 1999 VLDB 6.218781e-05
5,598 Efficient Computation of Multiple Group By Queries 2005 SIGMOD 6.053914e-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
5,798 Sampling Cube: A Framework for Statistical OLAP Over Sampling Data 2008 SIGMOD 5.9738467e-05
5,853 Shrinking the Warehouse Update Window 1999 SIGMOD 5.9520872e-05
6,268 Eliminating Costly Redundant Computations from SQL Trigger Executions 1997 SIGMOD 5.8123548e-05
6,554 Prediction Cubes 2005 VLDB 5.7302748e-05
6,589 Efficient Implementation of Large-Scale Multi-Structural Databases 2005 VLDB 5.7233473e-05
6,678 Optimal Indexing Using Near-Minimal Space [Extended Abstract] 2003 PODS 5.6957209e-05
6,723 E-Cube: Multi-Dimensional Event Sequence Analysis Using Hierarchical Pattern Query Sharing 2011 SIGMOD 5.6835603e-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
6,824 Stacked Indexed Views in Microsoft SQL Server 2005 SIGMOD 5.6568082e-05
6,951 Using Latency-Recency Profiles for Data Delivery on the Web 2002 VLDB 5.6201733e-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
7,720 Enabling Efficient and General Subpopulation Analytics in Multidimensional Data Streams 2022 VLDB 5.4542911e-05
7,774 Snakes and Sandwiches: Optimal Clustering Strategies for a Data Warehouse 1999 SIGMOD 5.4386896e-05
8,165 Information Retrieval from an Incomplete Data Cube 1996 VLDB 5.3711255e-05
8,315 NetCube: A Scalable Tool for Fast Data Mining and Compression 2001 VLDB 5.341013e-05
8,374 Sofos: Demonstrating the Challenges of Materialized View Selection on Knowledge Graphs 2021 SIGMOD 5.3282336e-05
8,586 Materialized View Selection for XQuery Workloads 2012 SIGMOD 5.2939333e-05
8,648 Maintenance of Cube Automatic Summary Tables 2000 SIGMOD 5.2812957e-05
8,724 View Selection over Knowledge Graphs in Triple Stores 2021 VLDB 5.2705676e-05
8,779 Bellwether Analysis: Predicting Global Aggregates from Local Regions 2006 VLDB 5.2652239e-05
Previous Page 2 / 3 Next

Outgoing Citations (Sorted by Pagerank)

Showing 3 of 3 cited papers.

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

Rank Cited Paper Year Venue Pagerank
73 Including Group-By in Query Optimization 1994 VLDB 0.00037420958
78 Sampling-Based Estimation of the Number of Distinct Values of an Attribute 1995 VLDB 0.00036725074
204 Aggregate-Query Processing in Data Warehousing Environments 1995 VLDB 0.0002516936
Previous Page 1 / 1 Next

Semantically Similar Papers