A Predicate-based Caching Scheme for Client-Server Database Architectures.
Arthur M. Keller, Julie Basu:
A Predicate-based Caching Scheme for Client-Server Database Architectures.
VLDB J. 5(1): 35-47(1996)@article{DBLP:journals/vldb/KellerB96,
author = {Arthur M. Keller and
Julie Basu},
title = {A Predicate-based Caching Scheme for Client-Server Database Architectures},
journal = {VLDB J.},
volume = {5},
number = {1},
year = {1996},
pages = {35-47},
ee = {db/journals/vldb/KellerB96.html},
bibsource = {DBLP, http://dblp.uni-trier.de}
}
BibTeX
Abstract
We propose a new client-side data-caching scheme for relational
databases with a central server and multiple clients. Data are loaded
into each client cache based on queries executed on the central database
at the server. These queries are used to form predicates that describe
the cache contents. A subsequent query at the client may be satisfied
in its local cache if we can determine that the query result is entirely
contained in the cache. This issue is called cache completeness.
A separate issue, cache currency, deals with the effect on client
caches of updates committed at the central database. We examine the
various performance tradeoffs and optimization issues involved in
addressing the questions of cache currency and completeness using
predicate descriptions and suggest solutions that promote good dynamic
behavior. Lower query-response times, reduced message traffic, higher
server throughput, and better scalability are some of the expected
benefits of our approach over commonly used relational server-side and
object ID-based or page-based client-side caching.
Key Words
Caching,
relational databases,
multiple clients,
cache completeness,
cache currency.
Copyright © 1996 by Springer, Berlin, Heidelberg.
Permission to make digital or hard copies of the abstract is granted provided that copies are not made or distributed for profit or
direct commercial advantage, and that copies show this notice along with the full citation.
Citation Page
Conference Version
Arthur M. Keller, Julie Basu:
A Predicate-based Caching Scheme for Client-Server Database Architectures.
PDIS 1994: 229-238 BibTeX
CDROM Version: Load the CDROM "Volume 4 Issue 1, Books, VLDB-j, TODS, ..." and ...
DVD Version: Load ACM SIGMOD Anthology DVD 2" and ...
BibTeX
References
- [1]
- Atul Adya, Robert Gruber, Barbara Liskov, Umesh Maheshwari:
Efficient Optimistic Concurrency Control Using Loosely Synchronized Clocks.
SIGMOD Conference 1995: 23-34 BibTeX
- [2]
- Thierry Barsalou, Arthur M. Keller, Niki Siambela, Gio Wiederhold:
Updating Relational Databases through Object-Based Views.
SIGMOD Conference 1991: 248-257 BibTeX
- [3]
- Elisa Bertino, Daniela Musto:
Query optimization by using knowledge about data semantics.
Data Knowl. Eng. 9: 121-155(1992) BibTeX
- [4]
- José A. Blakeley, Per-Åke Larson, Frank Wm. Tompa:
Efficiently Updating Materialized Views.
SIGMOD Conference 1986: 61-71 BibTeX
- [5]
- José A. Blakeley, Neil Coburn, Per-Åke Larson:
Updating Derived Relations: Detecting Irrelevant and Autonomously Computable Updates.
ACM Trans. Database Syst. 14(3): 369-400(1989) BibTeX
- [6]
- Haran Boral, Israel Gold:
Towards A Self-Adapting Centralized Concurrency Control Algorithm.
SIGMOD Conference 1984: 18-32 BibTeX
- [7]
- Michael J. Carey, Michael J. Franklin, Miron Livny, Eugene J. Shekita:
Data Caching Tradeoffs in Client-Server DBMS Architectures.
SIGMOD Conference 1991: 357-366 BibTeX
- [8]
- Michael J. Carey, Michael J. Franklin, Markos Zaharioudakis:
Fine-Grained Sharing in a Page Server OODBMS.
SIGMOD Conference 1994: 359-370 BibTeX
- [9]
- Stefano Ceri, Jennifer Widom:
Deriving Production Rules for Incremental View Maintenance.
VLDB 1991: 577-589 BibTeX
- [10]
- ...
- [11]
- Alex Delis, Nick Roussopoulos:
Performance and Scalability of Client-Server Database Architectures.
VLDB 1992: 610-623 BibTeX
- [12]
- Kapali P. Eswaran, Jim Gray, Raymond A. Lorie, Irving L. Traiger:
The Notions of Consistency and Predicate Locks in a Database System.
Commun. ACM 19(11): 624-633(1976) BibTeX
- [13]
- Michael J. Franklin:
Caching and Memory Management in Client-Server Database Systems.
Ph.D. thesis, Univ. of Wisconsin-Madison 1993
BibTeX
- [14]
- Michael J. Franklin, Michael J. Carey, Miron Livny:
Local Disk Caching for Client-Server Database Systems.
VLDB 1993: 641-655 BibTeX
- [15]
- ...
- [16]
- Ashish Gupta, Inderpal Singh Mumick, V. S. Subrahmanian:
Maintaining Views Incrementally.
SIGMOD Conference 1993: 157-166 BibTeX
- [17]
- Eric N. Hanson, Moez Chaabouni, Chang-Ho Kim, Yu-Wang Wang:
A Predicate Matching Algorithm for Database Rule Systems.
SIGMOD Conference 1990: 271-280 BibTeX
- [18]
- ...
- [19]
- J. R. Jordan, J. Banerjee, R. B. Batman:
Precision Locks.
SIGMOD Conference 1981: 143-147 BibTeX
- [20]
- Nabil Kamel, Roger King:
Intelligent Database Caching Through the Use of Page-Answers and Page-Traces.
ACM Trans. Database Syst. 17(4): 601-646(1992) BibTeX
- [21]
- ...
- [22]
- Per-Åke Larson, H. Z. Yang:
Computing Queries from Derived Relations.
VLDB 1985: 259-269 BibTeX
- [23]
- David B. Lomet:
Private Locking and Distributed Cache Management.
PDIS 1994: 151-159 BibTeX
- [24]
- ...
- [25]
- Jorma Rissanen:
Independent Components of Relations.
ACM Trans. Database Syst. 2(4): 317-325(1977) BibTeX
- [26]
- Nick Roussopoulos:
An Incremental Access Method for ViewCache: Concept, Algorithms, and Cost Analysis.
ACM Trans. Database Syst. 16(3): 535-563(1991) BibTeX
- [27]
- Nick Roussopoulos, Hyunchul Kang:
Preliminary Design of ADMS±: A Workstation-Mainframe Integrated Architecture for Database Management Systems.
VLDB 1986: 355-364 BibTeX
- [28]
- Yehoshua Sagiv, Mihalis Yannakakis:
Equivalences Among Relational Expressions with the Union and Difference Operators.
J. ACM 27(4): 633-655(1980) BibTeX
- [29]
- Timos K. Sellis:
Intelligent caching and indexing techniques for relational database systems.
Inf. Syst. 13(2): 175-185(1988) BibTeX
- [30]
- Timos K. Sellis, Chih-Chen Lin:
A Geometric Approach to Indexing Large Rule Bases.
EDBT 1992: 405-420 BibTeX
- [31]
- Amit P. Sheth, Anthony B. O'Hare:
The Architecture of BrAID: A System for Bridging AI/DB Systems.
ICDE 1991: 570-581 BibTeX
- [32]
- Michael Stonebraker, Anant Jhingran, Jeffrey Goh, Spyros Potamianos:
On Rules, Procedures, Caching and Views in Data Base Systems.
SIGMOD Conference 1990: 281-290 BibTeX
- [33]
- Yongdong Wang, Lawrence A. Rowe:
Cache Consistency and Concurrency Control in a Client/Server DBMS Architecture.
SIGMOD Conference 1991: 367-376 BibTeX
- [34]
- W. Kevin Wilkinson, Marie-Anne Neimat:
Maintaining Consistency of Client-Cached Data.
VLDB 1990: 122-133 BibTeX
Referenced by
- Todd D. Millstein, Alon Y. Levy, Marc Friedman:
Query Containment for Data Integration Systems.
PODS 2000: 67-75
- Olga Kapitskaia, Raymond T. Ng, Divesh Srivastava:
Evolution and Revolutions in LDAP Directory Caches.
EDBT 2000: 202-216
- Philip A. Bernstein, Shankar Pal, David Shutt:
Context-Based Prefetch for Implementing Objects on Relations.
VLDB 1999: 327-338
- Yannis Papakonstantinou, Vasilis Vassalos:
Query Rewriting for Semistructured Data.
SIGMOD Conference 1999: 455-466
- Yannis Kotidis, Nick Roussopoulos:
DynaMat: A Dynamic View Management System for Data Warehouses.
SIGMOD Conference 1999: 371-382
- Sophie Cluet, Olga Kapitskaia, Divesh Srivastava:
Using LDAP Directory Caches.
PODS 1999: 273-284
- Stefan Deßloch, Theo Härder, Nelson Mendonça Mattos, Bernhard Mitschang, Joachim Thomas:
Advanced Data Processing in KRISYS: Modeling Concepts, Implementation Techniques, and Client/Server Issues.
VLDB J. 7(2): 79-95(1998)
- Harumi A. Kuno, Elke A. Rundensteiner:
Incremental Maintenance of Materialized Object-Oriented Views in MultiView: Strategies and Performance Evaluation.
IEEE Trans. Knowl. Data Eng. 10(5): 768-792(1998)
- Jarek Gryz:
Query Folding with Inclusion Dependencies.
ICDE 1998: 126-133
- Julie Basu, Arthur M. Keller, Meikel Pöss:
Centralized versus Distributed Index Schemes in OODBMS - A Performance Analysis.
ADBIS 1997: 162-169
- Martin Staudt, Matthias Jarke:
Incremental Maintenance of Externally Materialized Views.
VLDB 1996: 75-86
- Peter Scheuermann, Junho Shim, Radek Vingralek:
WATCHMAN : A Data Warehouse Intelligent Cache Manager.
VLDB 1996: 51-62
- Shaul Dar, Michael J. Franklin, Björn Þór Jónsson, Divesh Srivastava, Michael Tan:
Semantic Data Caching and Replacement.
VLDB 1996: 330-341
- Gio Wiederhold:
Modelling and System Maintenance.
OOER 1995: 1-20
BibTeX
ACM SIGMOD Anthology - DBLP:
[Home | Search: Author, Title | Conferences | Journals]
VLDB Journal: 1992-1995 Copyright © by VLDB Endowment / 1996-... Copyright © by Springer Verlag,
ACM SIGMOD Anthology: Copyright © by ACM (info@acm.org), Corrections: anthology@acm.org
DBLP: Copyright © by Michael Ley (ley@uni-trier.de), last change: Sun May 17 00:31:26 2009