Centralized concurrency control methods for high-end TP

Thomasian, Alexander

doi:10.1145/126482.126495

Cited by 12 publications

(1 citation statement)

References 28 publications

Supporting

Mentioning

Contrasting

Order By: Relevance

“…In 2PL with GW policy, a transaction is blocked if it requests a data granule locked by another transaction, and the restart is initiated only when there is a deadlock. Blocking transactions, however, has great negative effect on system performance (Franaszek et al, 1985) (Tayet al, 1985a (Thomasian, 1991). Especially, as the level of data contention increases (e.g., by increasing the multiprogramming level (M), i.e., the total number of transactions running concurrently in a TP system), the interaction between data contention and 2PL with GW policy causes such a snowball effect that the blocked transactions hold locks that they have acquired and result in further blocking (Franaszek et al, 1985) (Tay et al, 1985b) (Thomasian, 1991).…”

Section: Introductionmentioning

confidence: 99%

Performance Study of Shared-Nothing Parallel Transaction Processing Systems

Wang

Kameda

1998

Performance and Management of Complex Communication Networks

View full text Add to dashboard Cite

Processing transactions in parallel brings us a new challenge: how to study the performance behavior of parallel Transaction Processing (TP) systems with dynamic Two-Phase Locking (2PL) concurrency control method analytically. In this paper, an analytic model is proposed for shared-nothing parallel TP systems with dynamic 2PL with the no-waiting policy. In this model, a flow diagram is used for characterizing the activities of transactions, and the steady-state average values of the variables are used for analyzing this flow diagram. Using this model, the performance behavior of shared-nothing parallel TP systems is studied. Analytic results are reported. Simulation experiments are performed to validate the analysis. The predictions of this model agree well with the simulation results.

show abstract