A Review on Concurrency Control Techniques in Database Management Systems

Abstract

Conflicts, deadlock and rolled-back transactions are being considered as the most recent challenges related to executing the transaction concurrently on different environments of Database Management Systems (DBMS). More precisely, in distributed database systems, to handle and avoid these challenges, there are different techniques and protocols are utilized. In this paper, we highlight some of these techniques which includes Two-Phase Commit (2PC) protocol and Three-Phase Commit (3PC) protocol) as well as and Deadlock-Free Cell lock (DFCL) algorithm. Moreover, the paper surveys all these protocols and demonstrate the pros and cons of each techniques. Afterwards, we proposed the solution of some important problems related to concurrency control techniques in DBMS

Evaluation of CPU Scheduling and Synchronization Algorithms in Distributed Systems

“…As a result, it can guide the protocol toward commit. Likewise, if a participant reports that they did not get prepared to commit, the new coordinator may conclude that the previous coordinator was ineffective even before initiating the prepare to commit phase [17].…”