Abstract:
We present a new client cache consistency algorithm for client caching database management systems. The algorithm, called Asynchronous Avoidance-based Cache Consistency (AACC), provides both good performance as well as a low abort rate. We present simulation results that compare AACC with two leading cache consistency algorithms: Adaptive Callback Locking (ACBL) and Adaptive Optimistic Concurrency Control (AOCC). Callback cache consistency (e.g. ACBL) is the most widely implemented algorithm due to its low abort rate and good performance. AOCC is an optimistic algorithm that has been shown to outperform ACBL under certain workload and system configurations. Until now one could either have high performance and high abort rate as in AOCC, or relatively lower performance but the low abort rate of ACBL. Our performance study shows that AACC outperforms both ACBL and AOCC for important workloads and system configurations. AACC has the high performance of AOCC, as well as the robustness and ...
Citations
|
132
|
Concurrency control performance modeling: alternatives and implications
– Agrawal, Carey, et al.
- 1987
|
|
85
|
Cache Consistency and Concurrency Control in Client/Server DBMS Architecture
– Wang, Rowe
|
|
84
|
Efficient optimistic concurrency control using loosely synchronized clocks
– Adya, Gruber, et al.
- 1995
|
|
76
|
Fine-grained sharing in a page server OODBMS
– Carey, Franklin, et al.
- 1994
|
|
56
|
Transactional client-server cache consistency: alternatives and performance
– Franklin, Carey, et al.
- 1997
|
|
44
|
Client-server caching revisited
– Franklin, Carey
- 1992
|
|
41
|
ªData Caching Tradeoffs
– Carey, Franklin, et al.
- 1991
|
|
27
|
Dynamic query operator scheduling for wide-area remote access
– Amsaleg, Franklin, et al.
- 1998
|
|
24
|
Optimism vs. Locking: A Study of Concurrency Control for Client-Server ObjectOriented Databases
– Gruber
- 1996
|
|
7
|
A Study of Query Execution Strategies for Client-Server Database Systems
– Kossmann, Franklin
- 1995
|
|
5
|
personal communication
– Carey, DeWitt, et al.
- 1985
|
|
3
|
A Contention Based Dynamic Consistency Maintenance Scheme For Client Cache
– Chung, Lee, et al.
- 1997
|
|
2
|
A Study of Three Alternative ServerWorkstation Architectures for OODBMS
– DeWitt, Futtersack, et al.
- 1990
|
|
2
|
A Status Report on the OO7 Benchmarking Effort
– Carey, DeWitt, et al.
- 1994
|