Beta
ManageSearchChatDiscover
63267

Improvement of Concurrent Transactions Performance via Database Locking Level Reduction

Article

Last updated: 25 Dec 2024

OverviewSimilar Items

Subjects

-

Tags

-

Abstract

A concurrency in database designed to implement multiple
transactions on the same database simultaneously that may
produce on a problem called transactions conflict. The
performance improvement of web-based database transactions
is through applying concurrency. Previous proposals to apply
concurrency lead to huge problems such transactions conflict.
Transactions Conflict leads to rollback some transactions from
multiple concurrent transactions to complete the others. This
paper proposes an algorithm to solve this obstacle by
implementing locking on the cell level. This algorithm improves
the throughput and committing transactions by about 42% and
36% respectively.

DOI

10.21608/mjeer.2018.63267

Keywords

Concurrency control, Concurrency Control Algorithms, Locking level, Cell locking

Authors

First Name

Marwa

Last Name

Mohamed

MiddleName

-

Affiliation

Computer Science & Eng. Dept., Faculty of Electronic Eng., Menoufia University, Menouf 32952, Egypt

Email

-

City

-

Orcid

-

First Name

Mohammed

Last Name

Badawy

MiddleName

-

Affiliation

Computer Science & Eng. Dept., Faculty of Electronic Eng., Menoufia University, Menouf 32952, Egypt

Email

-

City

-

Orcid

-

First Name

Ayman

Last Name

El-Sayed

MiddleName

-

Affiliation

Computer Science & Eng. Dept., Faculty of Electronic Eng., Menoufia University, Menouf 32952, Egypt

Email

-

City

-

Orcid

0000-0002-4437-259X

Volume

27

Article Issue

2

Related Issue

9505

Issue Date

2018-07-01

Receive Date

2017-12-26

Publish Date

2018-07-01

Page Start

373

Page End

388

Print ISSN

1687-1189

Online ISSN

2682-3535

Link

https://mjeer.journals.ekb.eg/article_63267.html

Detail API

https://mjeer.journals.ekb.eg/service?article_code=63267

Order

17

Type

Original Article

Type Code

1,088

Publication Type

Journal

Publication Title

Menoufia Journal of Electronic Engineering Research

Publication Link

https://mjeer.journals.ekb.eg/

MainTitle

Improvement of Concurrent Transactions Performance via Database Locking Level Reduction

Details

Type

Article

Created At

22 Jan 2023