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: 9209
Venue: VLDB
Year: 2003
Pagerank: 7.5402501e-05
Overall Rank: 3,305 | 77.33%
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,347	X-Engine: An Optimized Storage Engine for Large-scale E-commerce Transaction Processing	2019	SIGMOD	0.00011073571
2,770	Relaxed Currency and Consistency: How to Say "Good Enough" in SQL	2004	SIGMOD	8.1458395e-05
3,569	Caching with "Good Enough" Currency, Consistency, and Completeness	2005	VLDB	7.3011823e-05
4,764	ReCache: Reactive Caching for Fast Analytics over Heterogeneous Data	2018	VLDB	6.51896e-05
5,348	Crystal: A Unified Cache Storage System for Analytical Databases	2021	VLDB	6.2562688e-05
6,413	Scalable Query Result Caching for Web Applications	2008	VLDB	5.8834269e-05
6,481	MotherDuck: DuckDB in the cloud and in the client	2024	CIDR	5.8669399e-05
12,686	Simultaneous Scalability and Security for Data-Intensive Web Applications	2006	SIGMOD	5.093636e-05
12,722	A Scalability Service for Dynamic Web Applications	2005	CIDR	5.093636e-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
381	Query Caching and Optimization in Distributed Mediator Systems	1996	SIGMOD	0.00019549294
409	Semantic Data Caching and Replacement	1996	VLDB	0.00018985783
559	Optimizing Queries Using Materialized Views: A Practical, Scalable Solution	2001	SIGMOD	0.00016528822
785	Middle-Tier Database Caching for e-Business	2002	SIGMOD	0.00014068999
1,034	Answering Complex SQL Queries Using Automatic Summary Tables	2000	SIGMOD	0.00012516197
2,274	A Comparative Study of Alternative Middle Tier Caching Solutions to Support Dynamic Web Content Acceleration	2001	VLDB	8.8228773e-05
2,549	Web Caching for Database Applications with Oracle Web Cache	2002	SIGMOD	8.4300694e-05
2,598	Enabling Dynamic Content Caching for Database-Driven Web Sites	2001	SIGMOD	8.3586404e-05
3,101	Form-Based Proxy Caching for Database-Backed Web Sites	2001	VLDB	7.7577635e-05
4,586	DBCache: Middle-tier Database Caching for Highly Scalable e-Business Architectures	2003	SIGMOD	6.6173402e-05
4,771	Loading a Cache with Query Results	1999	VLDB	6.5158709e-05
5,057	Caching Technologies for Web Applications	2001	VLDB	6.3822625e-05
6,998	DBCache: Database Caching For Web Application Servers	2002	SIGMOD	5.7292123e-05
13,971	Tutorial: Application Servers and Associated Technologies	2002	SIGMOD	-

Semantically Similar Papers

#	Overall Rank	Paper	Year	Venue
1	5,057	Caching Technologies for Web Applications	2001	VLDB
2	2,231	Transparent Mid-Tier Database Caching in SQL Server	2003	SIGMOD
3	12,851	Issues and Evaluations of Caching Solutions for Web Application Acceleration	2002	VLDB
4	14,061	CachePortal: Technology for Accelerating Database-driven E-commerce Web Sites	2001	VLDB
5	2,549	Web Caching for Database Applications with Oracle Web Cache	2002	SIGMOD
6	6,413	Scalable Query Result Caching for Web Applications	2008	VLDB
7	7,722	ChronoCache: Predictive and Adaptive Mid-Tier Query Result Caching	2020	SIGMOD
8	4,597	CachePortal II: Acceleration of Very Large Scale Data Center-Hosted Database-driven Web Applications	2003	VLDB
9	2,598	Enabling Dynamic Content Caching for Database-Driven Web Sites	2001	SIGMOD
10	4,586	DBCache: Middle-tier Database Caching for Highly Scalable e-Business Architectures	2003	SIGMOD