Beta
246104

A Review on Concurrency Control Techniques in Database Management Systems

Article

Last updated: 22 Jan 2023

Subjects

-

Tags

Database 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.

DOI

10.21608/kjis.2022.246104

Keywords

Distributed database, Concurrency control, 2PC, 3PC, Deadlock, 2phase locking

Authors

First Name

Mahmoud

Last Name

Shams

MiddleName

Y.

Affiliation

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

Email

mahmoud.yasin@ai.kfs.edu.eg

City

-

Orcid

-

First Name

Amr

Last Name

Abohany

MiddleName

-

Affiliation

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

Email

amrabohany8@gmil.com

City

-

Orcid

-

Volume

3

Article Issue

1

Related Issue

35240

Issue Date

2022-06-01

Receive Date

2022-06-01

Publish Date

2022-06-01

Page Start

1

Page End

10

Print ISSN

2537-0677

Online ISSN

2535-1478

Link

https://kjis.journals.ekb.eg/article_246104.html

Detail API

https://kjis.journals.ekb.eg/service?article_code=246104

Order

2

Type

Original Article

Type Code

462

Publication Type

Journal

Publication Title

Kafrelsheikh Journal of Information Sciences

Publication Link

https://kjis.journals.ekb.eg/

MainTitle

-

Details

Type

Article

Created At

22 Jan 2023