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: 8771
Venue: VLDB
Year: 1999
Pagerank: 6.5158709e-05
Overall Rank: 4,771 | 67.27%
DOI: -

Incoming Non-self Citations Over Time

Authors

1. Laura M. Haas (IBM)
2. Donald Kossmann (University of Passau)
3. Ioana Ursu (IBM)

BibTeX Citation

@article{haas_vldb99,
        title = {{Loading a Cache with Query Results}},
        author = {Haas, Laura M. and Kossmann, Donald and Ursu, Ioana},
        journal = {PVLDB},
        series = {{VLDB} '99},
        pages = {351},
        year = {1999}
}

Incoming Citations (Sorted by Pagerank)

Showing 4 of 4 citing papers.

Rank	Citing Paper	Year	Venue	Pagerank
1,675	Garlic: A New Flavor of Federated Query Processing for DB2	2002	SIGMOD	0.00010035333
3,305	Cache Tables: Paving the Way for an Adaptive Database Cache	2003	VLDB	7.5402501e-05
5,759	Holistic Optimization by Prefetching Query Results	2012	SIGMOD	6.0962298e-05
7,244	Stop-and-Restart Style Execution for Long Running Decision Support Queries	2007	VLDB	5.6638746e-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.0024089429
171	Optimizing Queries across Diverse Data Sources	1997	VLDB	0.00027363924
192	Grammar-like Functional Rules for Representing Query Optimization Alternatives	1988	SIGMOD	0.00026028406
380	On Saying "Enough Already!" in SQL	1997	SIGMOD	0.00019563191
409	Semantic Data Caching and Replacement	1996	VLDB	0.00018985783
457	Don’t Scrap It, Wrap It! A Wrapper Architecture for Legacy Data Sources	1997	VLDB	0.00018120468
1,346	Fido: A Cache That Learns to Fetch	1991	VLDB	0.00011078024
2,336	Performance Tradeoffs for Client-Server Query Processing	1996	SIGMOD	8.7302865e-05
4,469	The BUCKY Object-Relational Benchmark	1997	SIGMOD	6.6818543e-05
4,479	Persistence Software: Bridging Object-Oriented Programming and Relational Databases	1993	SIGMOD	6.6765395e-05
4,700	Cost Models DO Matter: Providing Cost Information for Diverse Data Sources in a Federated System	1999	VLDB	6.5557492e-05
5,481	Practical Prefetching via Data Compression (extended abstract)	1993	SIGMOD	6.203823e-05
14,159	SAP R/3: A Database Application System	1998	SIGMOD	-

Semantically Similar Papers

#	Overall Rank	Paper	Year	Venue
1	74	Cache Conscious Algorithms for Relational Query Processing	1994	VLDB
2	5,237	Query Caching and View Selection for XML Databases	2005	VLDB
3	4,146	Efficiently Supporting Procedures In Relational Database Systems	1987	SIGMOD
4	5,716	Graph-Aware, Workload-Adaptive SPARQL Query Caching	2015	SIGMOD
5	7,792	Cache-Oblivious Query Processing	2007	CIDR
6	409	Semantic Data Caching and Replacement	1996	VLDB
7	2,376	Data Caching Tradeoffs in Client-Server DBMS Architectures	1991	SIGMOD
8	801	Query Execution Techniques for Caching Expensive Methods	1996	SIGMOD
9	171	Optimizing Queries across Diverse Data Sources	1997	VLDB
10	381	Query Caching and Optimization in Distributed Mediator Systems	1996	SIGMOD