Learn More
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(More)
Recent work on client-server data-shipping OODBs has demonstrated the usefulness of local data caching at client sites. In addition to data caching, index caching can provide substantial benets through associative access to cached objects. Indexes usually have high contention, and database performance is quite sensitive to the indexmanagement scheme. This(More)
A*Cache is an associative client-side caching scheme proposed in [6]. The cache at a client site dynamically loads query results and uses predicates based on the queries to describe its current contents. These predicate descriptions are used to determine query containment for local query evaluation at the client and also for cache maintenance. In this(More)
A caching scheme that uses query predicates to cache data on the client-side in a client-server relational database system was presented in [15]. The client-side cache (henceforth referred to as a SQL*Cache), loads query results dynamically in the course of transaction execution, and formulates a cache description based on the query predicates. SQL*Cache is(More)
This paper presents a detailed performance study of the associative caching scheme proposed in [11]. A client cache dynamically loads query results in the course of transaction execution, and formulates a description of its current contents. Predicate-based reasoning is used on the cache description to examine and maintain the cache. The bene ts of the(More)
Permission to copy without fee all or part of this material is granted provided that the copies are not made or distributed for direct commercial advantage, the VLDB copyright notice and the title of the publication and its date appear, and notice is given that copying is by permission of the Very Large Data Base Endowment. To copy otherwise, or to(More)
This paper presents a detailed performance study of three associative caching schemes for client-server databases. In all the three schemes, the client cache loads query results dynamically in the course of transaction execution, and supports evaluation of associative queries on the cache, at the cost of refreshing the cached data and maintaining(More)