scholarly journals Comparing two-phase locking and optimistic concurrency control protocols in multiprocessor real-time databases

2002 ◽  
Author(s):  
A. Chiu ◽  
Ben Kao ◽  
Kam-yiu Lam
Keyword(s):  
Real Time ◽  
Concurrency Control ◽  
Phase Locking ◽  
Two Phase ◽  
Optimistic Concurrency Control ◽  
Control Protocols

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.

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.

Sign in / Sign up

Export Citation Format

Share Document