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
- 1. Guido Moerkotte (University of Mannheim)
BibTeX Citation
@article{moerkotte_vldb98,
title = {{Small Materialized Aggregates: A Light Weight Index Structure for Data Warehousing}},
author = {Moerkotte, Guido},
journal = {PVLDB},
series = {{VLDB} '98},
pages = {476--487},
year = {1998}
}Incoming Citations (Sorted by Pagerank)
Showing 50 of 66 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.001992968 |
| 11 | Implementing Data Cubes Efficiently | 1996 | SIGMOD | 0.00071084324 |
| 97 | Of Nests and Trees: A Unified Approach to Processing Queries That Contain Nested Subqueries, Aggregates, and Quantifiers | 1987 | VLDB | 0.00034124569 |
| 107 | Improved Query Performance with Variant Indexes | 1997 | SIGMOD | 0.00033460288 |
| 655 | Storage Estimation for Multidimensional Aggregates in the Presence of Hierarchies | 1996 | VLDB | 0.00015070228 |
Previous
Page 1 / 1
Next
Semantically Similar Papers
| # | Overall Rank | Paper | Year | Venue |
|---|---|---|---|---|
| 1 | 901 | Maintenance of Data Cubes and Summary Tables in a Warehouse | 1997 | SIGMOD |
| 2 | 12,378 | The Case for Small Data Management | 2015 | CIDR |
| 3 | 4,798 | Aggregation Algorithms for Very Large Compressed Data Warehouses | 1999 | VLDB |
| 4 | 214 | On the Computation of Multidimensional Aggregates | 1996 | VLDB |
| 5 | 4,321 | Generalized Scale Independence Through Incremental Precomputation | 2013 | SIGMOD |
| 6 | 5,714 | An Alternative Storage Organization for ROLAP Aggregate Views Based on Cubetrees | 1998 | SIGMOD |
| 7 | 4,374 | Beyond Simple Aggregates: Indexing for Summary Queries | 2011 | PODS |
| 8 | 13,157 | A Data Warehousing Architecture for Enabling Service Provisioning Process | 2001 | VLDB |
| 9 | 5,637 | MaSM: Efficient Online Updates in Data Warehouses | 2011 | SIGMOD |
| 10 | 202 | Aggregate-Query Processing in Data Warehousing Environments | 1995 | VLDB |