Small Materialized Aggregates: A Light Weight Index Structure for Data Warehousing
Summary: Small Materialized Aggregates (SMAs) are a light-weight, flexible index for data warehousing, precomputing many aggregates over small to medium buckets. Applied to TPC-D, SMAs deliver about 100x speedups on Query 1 and offer tunable strategies for efficient query processing. (summarized by gpt-5-nano on Feb 09 2026)
Incoming Non-self Citations Over Time
Authors
Incoming Citations (Sorted by Pagerank)
Showing 50 of 64 citing papers.
Outgoing Citations (Sorted by Pagerank)
Showing 5 of 5 cited papers.
Citations counted here include only citations to other VLDB/SIGMOD/CIDR/PODS papers in this database.
| Rank | Cited Paper | Year | Venue | Pagerank |
|---|---|---|---|---|
| 2 | R-Trees: A Dynamic Index Structure For Spatial Searching | 1984 | SIGMOD | 0.0032169493 |
| 11 | Implementing Data Cubes Efficiently | 1996 | SIGMOD | 0.0011708144 |
| 100 | Of Nests and Trees: A Unified Approach to Processing Queries That Contain Nested Subqueries, Aggregates, and Quantifiers | 1987 | VLDB | 0.00049624696 |
| 121 | Improved Query Performance with Variant Indexes | 1997 | SIGMOD | 0.00045447517 |
| 593 | Storage Estimation for Multidimensional Aggregates in the Presence of Hierarchies | 1996 | VLDB | 0.00019536993 |
Previous
Page 1 / 1
Next
Semantically Similar Papers
| Overall Rank | Paper | Year | Venue | Pagerank |
|---|---|---|---|---|
| 962 | Maintenance of Data Cubes and Summary Tables in a Warehouse | 1997 | SIGMOD | 0.00014986226 |
| 11,885 | The Case for Small Data Management | 2015 | CIDR | 4.1945683e-05 |
| 4,954 | Aggregation Algorithms for Very Large Compressed Data Warehouses | 1999 | VLDB | 5.8053789e-05 |
| 247 | On the Computation of Multidimensional Aggregates | 1996 | VLDB | 0.00030927763 |
| 4,455 | Generalized Scale Independence Through Incremental Precomputation | 2013 | SIGMOD | 6.171182e-05 |
| 5,837 | An Alternative Storage Organization for ROLAP Aggregate Views Based on Cubetrees | 1998 | SIGMOD | 5.3061106e-05 |
| 3,991 | Beyond Simple Aggregates: Indexing for Summary Queries | 2011 | PODS | 6.5553055e-05 |
| 12,674 | A Data Warehousing Architecture for Enabling Service Provisioning Process | 2001 | VLDB | 4.1945683e-05 |
| 5,848 | MaSM: Efficient Online Updates in Data Warehouses | 2011 | SIGMOD | 5.3021155e-05 |
| 218 | Aggregate-Query Processing in Data Warehousing Environments | 1995 | VLDB | 0.00033503922 |