A Review on Concurrency Control Techniques in Database Management Systems

Shams, Mahmoud Y.; Abohany, Amr

doi:10.21608/kjis.2022.246104

A Review on Concurrency Control Techniques in Database Management Systems

Document Type : Original Article

Authors

Mahmoud Y. Shams ¹
Amr Abohany ²

¹ Faculty of Artificial Intelligence, Kafrelsheikh University, Kafrelsheikh, 33516, Egypt.

² Faculty of Computers and Information, Kafrelsheikh University, Kafrelsheikh, Egypt, 33516, Egypt.

10.21608/kjis.2022.246104

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.

Keywords