Predicate Caching: Query-Driven Secondary Indexing for Cloud Data Warehouses
Summary: Predicate caching is a query-driven secondary index for cloud data warehouses, speeding repetitive scans and joins. Lightweight, on-the-fly index built online; implemented in Redshift, delivering up to 10x query speed with minimal build cost. (summarized by gpt-5-nano on Feb 09 2026)
Incoming Non-self Citations Over Time
Authors
- 1. Tobias Schmidt (Technical University of Munich)
- 2. Andreas Kipf (University of Technology Nuremberg)
- 3. Dominik Horn (Amazon)
- 4. Gaurav Saxena (Amazon)
- 5. Tim Kraska (Amazon)
BibTeX Citation
@inproceedings{schmidt_sigmod24,
title = {{Predicate Caching: Query-Driven Secondary Indexing for Cloud Data Warehouses}},
author = {Schmidt, Tobias and Kipf, Andreas and Horn, Dominik and Saxena, Gaurav and Kraska, Tim},
series = {{SIGMOD} '24},
booktitle = {Proceedings of the {ACM} {SIGMOD} International Conference on Management of Data},
publisher = {Association for Computing Machinery},
doi = {10.1145/3626246.3653395},
url = {https://dl.acm.org/doi/10.1145/3626246.3653395},
year = {2024}
}Incoming Citations (Sorted by Pagerank)
Showing 11 of 11 citing papers.
Previous
Page 1 / 1
Next
Outgoing Citations (Sorted by Pagerank)
Showing 17 of 17 cited papers.
Citations counted here include only citations to other VLDB/SIGMOD/CIDR/PODS papers in this database.
Previous
Page 1 / 1
Next
Semantically Similar Papers
| # | Overall Rank | Paper | Year | Venue |
|---|---|---|---|---|
| 1 | 2,408 | Why TPC Is Not Enough: An Analysis of the Amazon Redshift Fleet | 2024 | VLDB |
| 2 | 3,585 | The evolution of Amazon Redshift (extended abstract) | 2021 | VLDB |
| 3 | 295 | Accelerating Machine Learning Inference with Probabilistic Predicates | 2018 | SIGMOD |
| 4 | 4,250 | Generalized Scale Independence Through Incremental Precomputation | 2013 | SIGMOD |
| 5 | 4,764 | ReCache: Reactive Caching for Fast Analytics over Heterogeneous Data | 2018 | VLDB |
| 6 | 11,071 | Sampling-based Predictive Database Buffer Management | 2025 | VLDB |
| 7 | 1,507 | Column Imprints: A Secondary Index Structure | 2013 | SIGMOD |
| 8 | 7,842 | Processing and Optimizing Main Memory Spatial-Keyword Queries | 2016 | VLDB |
| 9 | 8,721 | Accelerate Distributed Joins with Predicate Transfer | 2025 | SIGMOD |
| 10 | 5,107 | Stage: Query Execution Time Prediction in Amazon Redshift | 2024 | SIGMOD |