Loading a Cache with Query Results

Summary: Proposes loading the cache with objects touched by queries during processing, aligning cache warm-up with execution. Evaluates heuristic vs. cost-based caching; integrates cache loading into the optimizer, and shows Garlic middleware tradeoffs. (summarized by gpt-5-nano on Feb 09 2026)

Paper ID: 8580
Venue: VLDB
Year: 1999
Pagerank: 6.2574559e-05
Overall Rank: 4,357 | 69.70%
DOI: -

Incoming Non-self Citations Over Time

Authors

Incoming Citations (Sorted by Pagerank)

Showing 4 of 4 citing papers.

Rank	Citing Paper	Year	Venue	Pagerank
1,630	Garlic: A New Flavor of Federated Query Processing for DB2	2002	SIGMOD	0.0001108111
3,607	Cache Tables: Paving the Way for an Adaptive Database Cache	2003	VLDB	6.9253431e-05
5,818	Holistic Optimization by Prefetching Query Results	2012	SIGMOD	5.3154373e-05
7,088	Stop-and-Restart Style Execution for Long Running Decision Support Queries	2007	VLDB	4.8376651e-05

Outgoing Citations (Sorted by Pagerank)

Showing 13 of 13 cited papers.

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

Rank	Cited Paper	Year	Venue	Pagerank
1	Access Path Selection in a Relational Database Management System	1979	SIGMOD	0.0040449103
151	Optimizing Queries across Diverse Data Sources	1997	VLDB	0.00041016476
219	Grammar-like Functional Rules for Representing Query Optimization Alternatives	1988	SIGMOD	0.00033244259
346	Don't Scrap It, Wrap It! A Wrapper Architecture for Legacy Data Sources	1997	VLDB	0.00026656272
442	Semantic Data Caching and Replacement	1996	VLDB	0.000230437
470	On Saying "Enough Already!" in SQL	1997	SIGMOD	0.00022393068
1,181	Fido: A Cache That Learns to Fetch	1991	VLDB	0.00013456107
2,344	Performance Tradeoffs for Client-Server Query Processing	1996	SIGMOD	8.9992357e-05
3,979	The BUCKY Object-Relational Benchmark	1997	SIGMOD	6.5681058e-05
4,202	Cost Models DO Matter: Providing Cost Information for Diverse Data Sources in a Federated System	1999	VLDB	6.36184e-05
4,496	Persistence Software: Bridging Object-Oriented Programming and Relational Databases	1993	SIGMOD	6.1390107e-05
5,587	Practical Prefetching via Data Compression (extended abstract)	1993	SIGMOD	5.4218484e-05
13,958	SAP R/3: A Database Application System	1998	SIGMOD	-

Semantically Similar Papers

Overall Rank	Paper	Year	Venue	Pagerank
81	Cache Conscious Algorithms for Relational Query Processing	1994	VLDB	0.00055548574
5,611	Query Caching and View Selection for XML Databases	2005	VLDB	5.4113701e-05
3,346	Efficiently Supporting Procedures In Relational Database Systems	1987	SIGMOD	7.1924206e-05
5,771	Graph-Aware, Workload-Adaptive SPARQL Query Caching	2015	SIGMOD	5.3325981e-05
442	Semantic Data Caching and Replacement	1996	VLDB	0.000230437
7,378	Cache-Oblivious Query Processing	2007	CIDR	4.7480163e-05
2,309	Data Caching Tradeoffs in Client-Server DBMS Architectures	1991	SIGMOD	9.0589737e-05
703	Query Execution Techniques for Caching Expensive Methods	1996	SIGMOD	0.00017916705
151	Optimizing Queries across Diverse Data Sources	1997	VLDB	0.00041016476
253	Query Caching and Optimization in Distributed Mediator Systems	1996	SIGMOD	0.00030569863