Cache Tables: Paving the Way for an Adaptive Database Cache (2003)
| Venue: | In Proc. VLDB |
| Citations: | 37 - 1 self |
BibTeX
@INPROCEEDINGS{Altınel03cachetables:,
author = {Mehmet Altınel and Christof Bornhoevd and Sailesh Krishnamurthy and C. Mohan and Hamid Pirahesh and Berthold Reinwald},
title = {Cache Tables: Paving the Way for an Adaptive Database Cache},
booktitle = {In Proc. VLDB},
year = {2003},
pages = {718--729}
}
Years of Citing Articles
Bookmark
 |
 |
 |
 |
 |
 |
OpenURL
Abstract
We introduce a new database object called Cache Table that enables persistent caching of the full or partial content of a remote database table. The content of a cache table is either defined declaratively and populated in advance at setup time, or determined dynamically and populated on demand at query execution time. Dynamic cache tables exploit the characteristics of typical transactional web applications with a high volume of short transactions, simple equality predicates, and 3-4 way joins. Based on federated query processing capabilities, we developed a set of new technologies for database caching: cache tables, "Janus" (two-headed) query execution plans, cache constraints, and asynchronous cache population methods. Our solution supports transparent caching both at the edge of contentdelivery networks and in the middle-tier of an enterprise application infrastructure, improving the response time, throughput and scalability of transactional web applications.
