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.0032118946 |
| 11 | Implementing Data Cubes Efficiently | 1996 | SIGMOD | 0.0011695087 |
| 102 | Of Nests and Trees: A Unified Approach to Processing Queries That Contain Nested Subqueries, Aggregates, and Quantifiers | 1987 | VLDB | 0.00049592627 |
| 121 | Improved Query Performance with Variant Indexes | 1997 | SIGMOD | 0.00045429472 |
| 600 | Storage Estimation for Multidimensional Aggregates in the Presence of Hierarchies | 1996 | VLDB | 0.00019400653 |
Previous
Page 1 / 1
Next
Semantically Similar Papers
| Overall Rank | Paper | Year | Venue | Pagerank |
|---|---|---|---|---|
| 963 | Maintenance of Data Cubes and Summary Tables in a Warehouse | 1997 | SIGMOD | 0.00014975448 |
| 11,893 | The Case for Small Data Management | 2015 | CIDR | 4.1905499e-05 |
| 4,958 | Aggregation Algorithms for Very Large Compressed Data Warehouses | 1999 | VLDB | 5.8004036e-05 |
| 247 | On the Computation of Multidimensional Aggregates | 1996 | VLDB | 0.00030923842 |
| 4,457 | Generalized Scale Independence Through Incremental Precomputation | 2013 | SIGMOD | 6.1636855e-05 |
| 5,849 | An Alternative Storage Organization for ROLAP Aggregate Views Based on Cubetrees | 1998 | SIGMOD | 5.3017343e-05 |
| 3,989 | Beyond Simple Aggregates: Indexing for Summary Queries | 2011 | PODS | 6.5545373e-05 |
| 12,683 | A Data Warehousing Architecture for Enabling Service Provisioning Process | 2001 | VLDB | 4.1905499e-05 |
| 5,848 | MaSM: Efficient Online Updates in Data Warehouses | 2011 | SIGMOD | 5.3023051e-05 |
| 218 | Aggregate-Query Processing in Data Warehousing Environments | 1995 | VLDB | 0.00033489004 |