ChronoCache: Predictive and Adaptive Mid-Tier Query Result Caching

Summary: ChronoCache is a mid-tier cache that uses geo-distributed edge nodes to cache query results near users. It learns access patterns to predictively coalesce and prefetch queries, reducing remote round-trips and cutting response times by up to two-thirds on benchmarks. (summarized by gpt-5-nano on Feb 09 2026)

Paper ID: hde33e38d3d295671
Venue: SIGMOD
Year: 2020
Pagerank: 5.4339026e-05
Overall Rank: 7,881 | 47.02%
DOI: 10.1145/3318464.3380593

Incoming Non-self Citations Over Time

Authors

1. Brad Glasbergen (University of Waterloo)
2. Kyle Langendoen (University of Waterloo)
3. Michael Abebe (University of Waterloo)
4. Khuzaima Daudjee (University of Waterloo)

BibTeX Citation

@inproceedings{glasbergen_sigmod20,
        title = {{ChronoCache: Predictive and Adaptive Mid-Tier Query Result Caching}},
        author = {Glasbergen, Brad and Langendoen, Kyle and Abebe, Michael and Daudjee, Khuzaima},
        series = {{SIGMOD} '20},
        booktitle = {Proceedings of the {ACM} {SIGMOD} International Conference on Management of Data},
        publisher = {Association for Computing Machinery},
        doi = {10.1145/3318464.3380593},
        url = {https://dl.acm.org/doi/10.1145/3318464.3380593},
        year = {2020}
}

Incoming Citations (Sorted by Pagerank)

Showing 4 of 4 citing papers.

Rank	Citing Paper	Year	Venue	Pagerank
6,493	Caerus: Low-Latency Distributed Transactions for Geo-Replicated Systems	2024	VLDB	5.7663621e-05
7,874	Asynchronous Prefix Recoverability for Fast Distributed Stores	2021	SIGMOD	5.4357887e-05
8,872	Tiresias: Enabling Predictive Autonomous Storage and Indexing	2022	VLDB	5.2584643e-05
11,871	MinMax Sampling: A Near-optimal Global Summary for Aggregation in the Wide Area	2022	SIGMOD	4.9793485e-05

Outgoing Citations (Sorted by Pagerank)

Showing 18 of 18 cited papers.

Citations counted here include only citations to other VLDB/SIGMOD/CIDR/PODS papers in this database.

Rank	Cited Paper	Year	Venue	Pagerank
88	Automated Selection of Materialized Views and Indexes for SQL Databases	2000	VLDB	0.00035351639
235	OLTP-Bench: An Extensible Testbed for Benchmarking Relational Databases	2014	VLDB	0.00023697028
460	Query-based Workload Forecasting for Self-Driving Database Management Systems	2018	SIGMOD	0.00017842695
775	Lazy Database Replication with Snapshot Isolation	2006	VLDB	0.00014081697
808	Middle-Tier Database Caching for e-Business	2002	SIGMOD	0.00013778705
945	The End of Slow Networks: It's Time for a Redesign	2016	VLDB	0.00012939225
949	DynaMat: A Dynamic View Management System for Data Warehouses	1999	SIGMOD	0.00012902181
1,357	Fido: A Cache That Learns to Fetch	1991	VLDB	0.00010922832
1,764	Caching Multidimensional Queries Using Chunks	1998	SIGMOD	9.6965217e-05
1,842	On Predictive Modeling for Optimizing Transaction Execution in Parallel OLTP Systems	2012	VLDB	9.526552e-05
2,271	Transparent Mid-Tier Database Caching in SQL Server	2003	SIGMOD	8.7123265e-05
2,394	What Are We Doing With Our Lives? Nobody Cares About Our Concurrency Control Research	2017	SIGMOD	8.5295579e-05
2,511	WATCHMAN: A Data Warehouse Intelligent Cache Manager	1996	VLDB	8.3696476e-05
3,093	Lazy Evaluation of Transactions in Database Systems	2014	SIGMOD	7.6559585e-05
3,392	A Formal Perspective on the View Selection Problem	2001	VLDB	7.3483076e-05
5,088	ROBUS: Fair Cache Allocation for Data-parallel Workloads	2017	SIGMOD	6.2805079e-05
5,876	Holistic Optimization by Prefetching Query Results	2012	SIGMOD	5.9628805e-05
6,389	Optimization of Query Streams Using Semantic Prefetching	2004	SIGMOD	5.8018195e-05

Semantically Similar Papers

#	Overall Rank	Paper	Year	Venue
1	2,271	Transparent Mid-Tier Database Caching in SQL Server	2003	SIGMOD
2	14,372	CachePortal: Technology for Accelerating Database-driven E-commerce Web Sites	2001	VLDB
3	3,920	Effective Caching of Shortest Paths for Location-Based Services	2012	SIGMOD
4	4,832	ReCache: Reactive Caching for Fast Analytics over Heterogeneous Data	2018	VLDB
5	7,890	TSCache: An Efficient Flash-based Caching Scheme for Time-series Data Workloads	2021	VLDB
6	4,669	CachePortal II: Acceleration of Very Large Scale Data Center-Hosted Database-driven Web Applications	2003	VLDB
7	5,923	Scalable Query Result Caching for Web Applications	2008	VLDB
8	13,141	Issues and Evaluations of Caching Solutions for Web Application Acceleration	2002	VLDB
9	4,689	DBCache: Middle-tier Database Caching for Highly Scalable e-Business Architectures	2003	SIGMOD
10	3,345	Cache Tables: Paving the Way for an Adaptive Database Cache	2003	VLDB