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: 5868
Venue: SIGMOD
Year: 2020
Pagerank: 5.5586232e-05
Overall Rank: 7,722 | 47.03%
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,867	Caerus: Low-Latency Distributed Transactions for Geo-Replicated Systems	2024	VLDB	5.7506468e-05
7,717	Asynchronous Prefix Recoverability for Fast Distributed Stores	2021	SIGMOD	5.5605526e-05
8,783	Tiresias: Enabling Predictive Autonomous Storage and Indexing	2022	VLDB	5.3740362e-05
11,562	MinMax Sampling: A Near-optimal Global Summary for Aggregation in the Wide Area	2022	SIGMOD	5.093636e-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
87	Automated Selection of Materialized Views and Indexes for SQL Databases	2000	VLDB	0.00035281619
226	OLTP-Bench: An Extensible Testbed for Benchmarking Relational Databases	2014	VLDB	0.00024027277
461	Query-based Workload Forecasting for Self-Driving Database Management Systems	2018	SIGMOD	0.00018068441
754	Lazy Database Replication with Snapshot Isolation	2006	VLDB	0.00014327706
785	Middle-Tier Database Caching for e-Business	2002	SIGMOD	0.00014068999
943	DynaMat: A Dynamic View Management System for Data Warehouses	1999	SIGMOD	0.00013068595
976	The End of Slow Networks: It's Time for a Redesign	2016	VLDB	0.00012864533
1,346	Fido: A Cache That Learns to Fetch	1991	VLDB	0.00011078024
1,732	Caching Multidimensional Queries Using Chunks	1998	SIGMOD	9.9065981e-05
1,831	On Predictive Modeling for Optimizing Transaction Execution in Parallel OLTP Systems	2012	VLDB	9.6635729e-05
2,231	Transparent Mid-Tier Database Caching in SQL Server	2003	SIGMOD	8.8980681e-05
2,368	What Are We Doing With Our Lives? Nobody Cares About Our Concurrency Control Research	2017	SIGMOD	8.6827828e-05
2,456	WATCHMAN: A Data Warehouse Intelligent Cache Manager	1996	VLDB	8.5526697e-05
3,053	Lazy Evaluation of Transactions in Database Systems	2014	SIGMOD	7.8098188e-05
3,330	A Formal Perspective on the View Selection Problem	2001	VLDB	7.5139396e-05
5,759	Holistic Optimization by Prefetching Query Results	2012	SIGMOD	6.0962298e-05
6,273	Optimization of Query Streams Using Semantic Prefetching	2004	SIGMOD	5.9317551e-05
7,673	ROBUS: Fair Cache Allocation for Data-parallel Workloads	2017	SIGMOD	5.5705944e-05

Semantically Similar Papers

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