Cache Tables: Paving the Way for an Adaptive Database Cache

Summary: Introduces cache tables as persistent, declarative or on-demand caches for full/partial remote tables, enabling transparent edge and middle-tier caching. Janus plans, cache constraints, and asynchronous population adapt federated execution to short, join-heavy transactional workloads. (summarized by gpt-5.6-luna on Jul 24 2026)

Paper ID: h3ff2891126011111
Venue: VLDB
Year: 2003
Pagerank: 7.3949085e-05
Overall Rank: 3,345 | 77.52%
DOI: 10.1016/B978-012722442-8/50069-0

Incoming Non-self Citations Over Time

Authors

1. Mehmet Altınel (IBM)
2. Christof Bornhövd (IBM)
3. Sailesh Krishnamurthy (University of California Berkeley)
4. C. Mohan (IBM)
5. Hamid Pirahesh (IBM)
6. Berthold Reinwald (IBM)

BibTeX Citation

@article{altnel_vldb03,
        title = {{Cache Tables: Paving the Way for an Adaptive Database Cache}},
        author = {Altınel, Mehmet and Bornhövd, Christof and Krishnamurthy, Sailesh and Mohan, C. and Pirahesh, Hamid and Reinwald, Berthold},
        journal = {PVLDB},
        series = {{VLDB} '03},
        doi = {10.1016/B978-012722442-8/50069-0},
        url = {https://doi.org/10.1016/B978-012722442-8/50069-0},
        year = {2003}
}

Incoming Citations (Sorted by Pagerank)

Showing 9 of 9 citing papers.

Rank	Citing Paper	Year	Venue	Pagerank
1,313	X-Engine: An Optimized Storage Engine for Large-scale E-commerce Transaction Processing	2019	SIGMOD	0.00011060108
2,826	Relaxed Currency and Consistency: How to Say "Good Enough" in SQL	2004	SIGMOD	7.9678605e-05
3,616	Caching with "Good Enough" Currency, Consistency, and Completeness	2005	VLDB	7.1585227e-05
4,832	ReCache: Reactive Caching for Fast Analytics over Heterogeneous Data	2018	VLDB	6.3895407e-05
5,446	Crystal: A Unified Cache Storage System for Analytical Databases	2021	VLDB	6.1266228e-05
5,923	Scalable Query Result Caching for Web Applications	2008	VLDB	5.9468112e-05
6,561	MotherDuck: DuckDB in the cloud and in the client	2024	CIDR	5.7481696e-05
12,976	Simultaneous Scalability and Security for Data-Intensive Web Applications	2006	SIGMOD	4.9793485e-05
13,012	A Scalability Service for Dynamic Web Applications	2005	CIDR	4.9793485e-05

Outgoing Citations (Sorted by Pagerank)

Showing 14 of 14 cited papers.

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

Rank	Cited Paper	Year	Venue	Pagerank
399	Query Caching and Optimization in Distributed Mediator Systems	1996	SIGMOD	0.00019143706
416	Semantic Data Caching and Replacement	1996	VLDB	0.00018658244
553	Optimizing Queries Using Materialized Views: A Practical, Scalable Solution	2001	SIGMOD	0.0001652591
808	Middle-Tier Database Caching for e-Business	2002	SIGMOD	0.00013778705
1,054	Answering Complex SQL Queries Using Automatic Summary Tables	2000	SIGMOD	0.00012269068
2,330	A Comparative Study of Alternative Middle Tier Caching Solutions to Support Dynamic Web Content Acceleration	2001	VLDB	8.6291203e-05
2,593	Web Caching for Database Applications with Oracle Web Cache	2002	SIGMOD	8.243812e-05
2,652	Enabling Dynamic Content Caching for Database-Driven Web Sites	2001	SIGMOD	8.1734335e-05
3,156	Form-Based Proxy Caching for Database-Backed Web Sites	2001	VLDB	7.5856774e-05
4,689	DBCache: Middle-tier Database Caching for Highly Scalable e-Business Architectures	2003	SIGMOD	6.4690629e-05
4,880	Loading a Cache with Query Results	1999	VLDB	6.3714546e-05
5,183	Caching Technologies for Web Applications	2001	VLDB	6.2397679e-05
7,135	DBCache: Database Caching For Web Application Servers	2002	SIGMOD	5.6016575e-05
14,282	Tutorial: Application Servers and Associated Technologies	2002	SIGMOD	-

Semantically Similar Papers

#	Overall Rank	Paper	Year	Venue
1	5,183	Caching Technologies for Web Applications	2001	VLDB
2	2,271	Transparent Mid-Tier Database Caching in SQL Server	2003	SIGMOD
3	13,141	Issues and Evaluations of Caching Solutions for Web Application Acceleration	2002	VLDB
4	2,593	Web Caching for Database Applications with Oracle Web Cache	2002	SIGMOD
5	14,372	CachePortal: Technology for Accelerating Database-driven E-commerce Web Sites	2001	VLDB
6	5,923	Scalable Query Result Caching for Web Applications	2008	VLDB
7	7,881	ChronoCache: Predictive and Adaptive Mid-Tier Query Result Caching	2020	SIGMOD
8	4,669	CachePortal II: Acceleration of Very Large Scale Data Center-Hosted Database-driven Web Applications	2003	VLDB
9	2,652	Enabling Dynamic Content Caching for Database-Driven Web Sites	2001	SIGMOD
10	4,689	DBCache: Middle-tier Database Caching for Highly Scalable e-Business Architectures	2003	SIGMOD