Distributed concurrency control based on limited wait-depth

Franaszek, P. A. ; Haritsa, J. R. ; Robinson, J. T. ; Thomasian, A. (1993) Distributed concurrency control based on limited wait-depth IEEE Transactions on Parallel and Distributed Systems, 4 (11). pp. 1246-1264. ISSN 1045-9219

Full text not available from this repository.

Official URL: http://www.computer.org/portal/web/csdl/doi/10.110...

Related URL: http://dx.doi.org/10.1109/71.250103


The performance of high-volume transaction processing systems for business applications is determined by the degree of contention for hardware resources as well as for data. Hardware resource requirements may be met cost-effectively with a data-partitioned or shared-nothing architecture. However, the two-phase locking (2PL) concurrency control method may restrict the performance of a shared-nothing system more severely than that of a centralized system due to increased lock holding times. Deadlock detection and resolution are an added complicating factor in shared-nothing systems. The authors describe distributed Wait-Depth Limited (WDL) concurrency control (CC), a locking-based distributed CC method that limits the wait-depth of blocked transactions to one, thus preventing the occurrence of deadlocks. Several implementations of distributed WDL which vary in the number of messages and the amount of information available for decision making are discussed. The performance of a generic implementation of distributed WDL is compared with distributed 2PL (with general-waiting policy) and the Wound-Wait CC method through a detailed simulation. It is shown that distributed WDL behaves similarly to 2PL for low lock contention levels, but for substantial lock contention levels (caused by higher degrees of transaction concurrency), distributed WDL outperforms the other methods to a significant degree.

Item Type:Article
Source:Copyright of this article belongs to IEEE.
ID Code:62449
Deposited On:22 Sep 2011 03:19
Last Modified:22 Sep 2011 03:19

Repository Staff Only: item control page