scholarly journals Concurrency Control in Database Systems

2019 ◽  
Vol 1 (2) ◽  
pp. 26-40
Author(s):  
Dardina Tasmere ◽  
Md. Nazmus Salehin
Keyword(s):  
Concurrency Control ◽  
Phase Locking ◽  
Wait Time ◽  
Arrival Rate ◽  
Database Systems ◽  
Control Algorithms ◽  
Control Mechanisms ◽  
Time Stamp ◽  
System Behavior ◽  
Two Phase

Concurrency control mechanisms including the wait, time-stamp and rollback mechanisms have been briefly discussed. The concepts of validation in optimistic approach are summarized in a detailed view. Various algorithms have been discussed regarding the degree of concurrency and classes of serializability. Practical questions relating arrival rate of transactions have been presented. Performance evaluation of concurrency control algorithms including degree of concurrency and system behavior have been briefly conceptualized. At last, ideas like multidimensional timestamps, relaxation of two-phase locking, system defined prewrites, flexible transactions and adaptability for increasing concurrency have been summarized.

scholarly journals Study of Concurrency Control Techniques in Distributed DBMS

2018 ◽  
Vol 2 (4) ◽  
Author(s):  
Manoj Kumar Gupta . ◽  
Rakesh Kumar Arora . ◽  
Bhoopesh Singh Bhati .
Keyword(s):  
Comparative Study ◽  
Concurrency Control ◽  
Phase Locking ◽  
Two Phase ◽  
Control Techniques ◽  
Very High

Concurrency control focuses on maintaining consistency and integrity of database through synchronized access. The complexity relating to concurrency control in a distributed context is very high as compared to centralized framework due to maintaining consistency within the multiple fragments / copies of the database. This paper consolidates and discusses various lock based concurrency control techniques for Distributed DBMS. The paper also presents a comparative study of various two phase locking based concurrency control techniques.

On the efficiency of cautious schedulers for database concurrency control?Why insist on two-phase locking?

1989 ◽  
Vol 1 (2) ◽  
pp. 177-195 ◽  
Author(s):  
Shojiro Nishio ◽  
Shinichi Taniguchi ◽  
Toshihide Ibaraki
Keyword(s):  
Concurrency Control ◽  
Phase Locking ◽  
Two Phase

Implementation and modeling of two-phase locking concurrency control—a performance study

2000 ◽  
Vol 42 (4) ◽  
pp. 257-273 ◽  
Author(s):  
N.B Al-Jumah ◽  
H.S Hassanein ◽  
M El-Sharkawi
Keyword(s):  
Concurrency Control ◽  
Phase Locking ◽  
Performance Study ◽  
Two Phase ◽  
A Performance
Sign in / Sign up

Export Citation Format

Share Document