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
2946
Venue
SIGMOD
Year
1996
Pagerank
0.00071822821
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 125 citing papers.

Rank Citing Paper Year Venue Pagerank
3,214 Searchlight: Enabling Integrated Search and Exploration over Large Multidimensional Data 2015 VLDB 7.6325181e-05
3,366 AQP++: Connecting Approximate Query Processing With Aggregate Precomputation for Interactive Analytics 2018 SIGMOD 7.4748604e-05
3,379 Cubetree: Organization of and Bulk Incremental Updates on the Data Cube 1997 SIGMOD 7.4582502e-05
3,555 Apache Hive: From MapReduce to Enterprise-grade Big Data Warehousing 2019 SIGMOD 7.3115321e-05
3,605 Computation Reuse in Analytics Job Service at Microsoft 2018 SIGMOD 7.2640711e-05
3,673 Efficient Processing of Window Functions in Analytical SQL Queries 2015 VLDB 7.2113383e-05
3,706 Supporting Ad-hoc Ranking Aggregates 2006 SIGMOD 7.1819534e-05
3,732 Entity Resolution with Evolving Rules 2010 VLDB 7.1655038e-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,834 Effective Caching of Shortest Paths for Location-Based Services 2012 SIGMOD 7.0841464e-05
3,889 On Efficiently Implementing SchemaSQL on a SQL Database System 1999 VLDB 7.0440224e-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,204 MDL Summarization with Holes 2005 VLDB 6.834169e-05
4,221 Efficient Algorithms for Exact Ranked Twig-Pattern Matching over Graphs 2008 SIGMOD 6.8233111e-05
4,252 An Adaptive Peer-to-Peer Network for Distributed Caching of OLAP Results 2002 SIGMOD 6.8029543e-05
4,392 Multi-Structural Databases 2005 PODS 6.7288249e-05
4,623 Multiple Aggregations Over Data Streams 2005 SIGMOD 6.6012764e-05
4,638 Going Beyond Provenance: Explaining Query Answers with Pattern-based Counterbalances 2019 SIGMOD 6.5919801e-05
4,699 Fast Data Anonymization with Low Information Loss 2007 VLDB 6.5560796e-05
4,723 Aggregation Algorithms for Very Large Compressed Data Warehouses 1999 VLDB 6.5389699e-05
4,896 User-Defined Aggregate Functions: Bridging Theory and Practice 2006 SIGMOD 6.4548696e-05
5,006 iTrails: Pay-as-you-go Information Integration in Dataspaces 2007 VLDB 6.4034229e-05
5,136 Extending Practical Pre-Aggregation in On-Line Analytical Processing 1999 VLDB 6.3519278e-05
5,470 Efficient Computation of Multiple Group By Queries 2005 SIGMOD 6.2070458e-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,651 Sampling Cube: A Framework for Statistical OLAP Over Sampling Data 2008 SIGMOD 6.1336568e-05
5,728 Shrinking the Warehouse Update Window 1999 SIGMOD 6.1073148e-05
6,136 Eliminating Costly Redundant Computations from SQL Trigger Executions 1997 SIGMOD 5.9644839e-05
6,414 Prediction Cubes 2005 VLDB 5.883228e-05
6,452 Efficient Implementation of Large-Scale Multi-Structural Databases 2005 VLDB 5.8751532e-05
6,584 E-Cube: Multi-Dimensional Event Sequence Analysis Using Hierarchical Pattern Query Sharing 2011 SIGMOD 5.8354359e-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,671 Stacked Indexed Views in Microsoft SQL Server 2005 SIGMOD 5.807209e-05
6,753 Optimal Indexing Using Near-Minimal Space [Extended Abstract] 2003 PODS 5.7836523e-05
6,796 Using Latency-Recency Profiles for Data Delivery on the Web 2002 VLDB 5.7707686e-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
7,551 Enabling Efficient and General Subpopulation Analytics in Multidimensional Data Streams 2022 VLDB 5.6006414e-05
7,612 Snakes and Sandwiches: Optimal Clustering Strategies for a Data Warehouse 1999 SIGMOD 5.5834218e-05
7,979 Information Retrieval from an Incomplete Data Cube 1996 VLDB 5.5148266e-05
8,121 NetCube: A Scalable Tool for Fast Data Mining and Compression 2001 VLDB 5.4834308e-05
8,218 Sofos: Demonstrating the Challenges of Materialized View Selection on Knowledge Graphs 2021 SIGMOD 5.4644639e-05
8,416 Materialized View Selection for XQuery Workloads 2012 SIGMOD 5.429311e-05
8,460 Maintenance of Cube Automatic Summary Tables 2000 SIGMOD 5.4216109e-05
8,527 View Selection over Knowledge Graphs in Triple Stores 2021 VLDB 5.4119882e-05
8,590 Bellwether Analysis: Predicting Global Aggregates from Local Regions 2006 VLDB 5.4062174e-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
71 Including Group-By in Query Optimization 1994 VLDB 0.00038021159
75 Sampling-Based Estimation of the Number of Distinct Values of an Attribute 1995 VLDB 0.00037277061
198 Aggregate-Query Processing in Data Warehousing Environments 1995 VLDB 0.00025618616
Previous Page 1 / 1 Next

Semantically Similar Papers