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: 8581
Venue: VLDB
Year: 1999
Pagerank: 6.2520069e-05
Overall Rank: 4,355 | 69.74%
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,632	Garlic: A New Flavor of Federated Query Processing for DB2	2002	SIGMOD	0.00011070537
3,602	Cache Tables: Paving the Way for an Adaptive Database Cache	2003	VLDB	6.9282932e-05
5,829	Holistic Optimization by Prefetching Query Results	2012	SIGMOD	5.310328e-05
7,084	Stop-and-Restart Style Execution for Long Running Decision Support Queries	2007	VLDB	4.8330538e-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.0040465394
152	Optimizing Queries across Diverse Data Sources	1997	VLDB	0.00040979242
220	Grammar-like Functional Rules for Representing Query Optimization Alternatives	1988	SIGMOD	0.00033312045
345	Don't Scrap It, Wrap It! A Wrapper Architecture for Legacy Data Sources	1997	VLDB	0.00026634783
444	Semantic Data Caching and Replacement	1996	VLDB	0.0002303513
469	On Saying "Enough Already!" in SQL	1997	SIGMOD	0.00022397468
1,182	Fido: A Cache That Learns to Fetch	1991	VLDB	0.00013447214
2,349	Performance Tradeoffs for Client-Server Query Processing	1996	SIGMOD	8.9903567e-05
3,980	The BUCKY Object-Relational Benchmark	1997	SIGMOD	6.5617607e-05
4,203	Cost Models DO Matter: Providing Cost Information for Diverse Data Sources in a Federated System	1999	VLDB	6.3561618e-05
4,497	Persistence Software: Bridging Object-Oriented Programming and Relational Databases	1993	SIGMOD	6.1352917e-05
5,597	Practical Prefetching via Data Compression (extended abstract)	1993	SIGMOD	5.4167486e-05
13,972	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.00055253195
5,621	Query Caching and View Selection for XML Databases	2005	VLDB	5.4061733e-05
3,350	Efficiently Supporting Procedures In Relational Database Systems	1987	SIGMOD	7.1867845e-05
5,778	Graph-Aware, Workload-Adaptive SPARQL Query Caching	2015	SIGMOD	5.3274776e-05
444	Semantic Data Caching and Replacement	1996	VLDB	0.0002303513
7,373	Cache-Oblivious Query Processing	2007	CIDR	4.744464e-05
2,315	Data Caching Tradeoffs in Client-Server DBMS Architectures	1991	SIGMOD	9.0516482e-05
699	Query Execution Techniques for Caching Expensive Methods	1996	SIGMOD	0.0001794078
152	Optimizing Queries across Diverse Data Sources	1997	VLDB	0.00040979242
253	Query Caching and Optimization in Distributed Mediator Systems	1996	SIGMOD	0.00030517335