Speculative Concurrency Control for Real-Time Databases
ثبت نشده
چکیده
In this paper, we propose a new class of Concurrency Control Algorithms that is especially suited for real-time database applications. Our approach relies on the use of (potentially) redundant computations to ensure that serializable schedules are found and executed as early as possible, thus, increasing the chances of a timely commitment of transactions with strict timing constraints. Due to its nature, we term our concurrency control algorithms Speculative. The aforementioned description encompasses many algorithms that we call collectively Speculative Concurrency Control (SCC) algorithms. SCC algorithms combine the advantages of both Pessimistic and Optimistic Concurrency Control (PCC and OCC) algorithms, while avoiding their disadvantages. On the one hand, SCC resembles PCC in that con icts are detected as early as possible, thus making alternative schedules available in a timely fashion in case they are needed. On the other hand, SCC resembles OCC in that it allows con icting transactions to proceed concurrently, thus avoiding unecessary delays that may jeopardize their timely commitment.
منابع مشابه
Implementation of a Speculative Concurrency Controller
Many scheduling algorithms for databases have been developed in order to improve transaction responsiveness. Some developed algorithms meet special needs of real-time databases. These algorithms however, deal with temporal execution aspects , often disregarding semantics of data usage which could further improve performance. One such algorithm is Speculative Concurrency Control , which uses exe...
متن کاملTimeliness via Speculation for Real-Time Databases
Various concurrency control algorithms di er in the time when con icts are detected, and in the way they are resolved. In that respect, the Pessimistic and Optimistic Concurrency Control (PCC and OCC) alternatives represent two extremes. PCC locking protocols detect con icts as soon as they occur and resolve them using blocking. OCC protocols detect con icts at transaction commit time and resol...
متن کاملSpeculative Concurrency Control for Real-Time Databases
In this paper, we propose a new class of Concurrency Control Algorithms that is especially suited for real-time database applications. Our approach relies on the use of (potentially) redundant computations to ensure that serializable schedules are found and executed as early as possible, thus, increasing the chances of a timely commitment of transactions with strict timing constraints. Due to i...
متن کاملA Family of Speculative Concurrency Control Algorithms for Real-Time Databases
Speculative Concurrency Control (SCC) was proposed in [Best92b] as a new concurrency control approach especially suited for real-time database applications. SCC relies on the use of redundancy to ensure that serializable schedules are discovered and adopted as early as possible, thus increasing the likelihood of the timely commitment of transactions with strict timing constraints. Using SCC, se...
متن کاملIn Proceedings of VLDB ’ 95 : The International Conference on Very Large Databases , Zurich , Switzerland , September 1995 . Value � cognizant Speculative Concurrency Control
We describe SCC kS a Speculative Concurrency Control SCC algorithm that allows a DBMS to use e ciently the extra computing resources avail able in the system to increase the likelihood of timely commitment of transactions Using SCC kS up to k shadow transactions execute speculatively on behalf of a given uncommitted transaction so as to protect against the hazards of blockages and restarts SCC ...
متن کامل