Title :
A predicate-based caching scheme for client-server database architectures
Author :
Keller, Arthur M. ; Basu, Julie
Author_Institution :
Dept. of Comput. Sci., Stanford Univ., Palo Alto, CA, USA
Abstract :
We propose a new client-side data caching scheme for relational databases with a central server and multiple clients. Data is loaded into a client cache based on queries, which are used to form predicates describing 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´. On the other hand, `cache currency deals with the effect of updates at the central database on the client caches. We examine various performance and optimization issues involved in addressing the questions of cache currency and completeness using predicate descriptions. Expected benefits of our approach over commonly used object 1D-based caching include lower query response times, reduced message traffic, higher server throughput, and better scalability
Keywords :
buffer storage; distributed databases; network operating systems; relational databases; cache completeness; client-server database architectures; message traffic; predicate-based caching scheme; query response times; relational databases; scalability; server throughput; Computer architecture; Computer science; Delay; File servers; Network servers; Object oriented databases; Relational databases; Scalability; Transaction databases; Workstations;
Conference_Titel :
Parallel and Distributed Information Systems, 1994., Proceedings of the Third International Conference on
Conference_Location :
Austin, TX
Print_ISBN :
0-8186-6400-2
DOI :
10.1109/PDIS.1994.331711