A review of concurrency control technique in distributed database

Concurrency is a process where multiple simultaneous transactions of data in database system perform. Due to this condition, the concurrency control method can help and avoid the data inconsistencies when the system is accessed by the user. This paper elaborately discusses the distributed database i...

Full description

Saved in:
Bibliographic Details
Main Authors: Kasim, Shahreen, Sinnasamy, Surain R., Wui, Xiang Chiam, Cha, Pei Fong, Eng, Kong Yeoh, Wahid, Norfaradilla, Hafit, Hanayanti
Format: Article
Language:English
Published: Penerbit UTM Press 2018
Subjects:
Online Access:http://eprints.uthm.edu.my/6059/1/AJ%202018%20%281011%29%20A%20review%20of%20concurrency%20control%20technique%20in%20distributed%20database.pdf
http://eprints.uthm.edu.my/6059/
Tags: Add Tag
No Tags, Be the first to tag this record!
id my.uthm.eprints.6059
record_format eprints
spelling my.uthm.eprints.60592022-01-26T04:20:04Z http://eprints.uthm.edu.my/6059/ A review of concurrency control technique in distributed database Kasim, Shahreen Sinnasamy, Surain R. Wui, Xiang Chiam Cha, Pei Fong Eng, Kong Yeoh Wahid, Norfaradilla Hafit, Hanayanti TA168 Systems engineering Concurrency is a process where multiple simultaneous transactions of data in database system perform. Due to this condition, the concurrency control method can help and avoid the data inconsistencies when the system is accessed by the user. This paper elaborately discusses the distributed database in the aspect of concurrency control techniques. This research reviews three algorithms; DSL, VGA, and SBA in terms of the waiting time, validation, performance, delay and also the number of message exchange. SBA shows the best performance among others. Meanwhile, a comparison between FBS and S2PL be done in order to measure the time of response in high and low-security level. In Addition, the fairness level of the system also been measured. It is shown that FBS shows an improving of time and positive result when dealing with a high-security level performance of the transaction. FBS also improved in terms of fairness at the different level of security. Penerbit UTM Press 2018 Article PeerReviewed text en http://eprints.uthm.edu.my/6059/1/AJ%202018%20%281011%29%20A%20review%20of%20concurrency%20control%20technique%20in%20distributed%20database.pdf Kasim, Shahreen and Sinnasamy, Surain R. and Wui, Xiang Chiam and Cha, Pei Fong and Eng, Kong Yeoh and Wahid, Norfaradilla and Hafit, Hanayanti (2018) A review of concurrency control technique in distributed database. International Journal of Software Engineering and Technology, 2 (1). pp. 28-33. ISSN 2289-284X
institution Universiti Tun Hussein Onn Malaysia
building UTHM Library
collection Institutional Repository
continent Asia
country Malaysia
content_provider Universiti Tun Hussein Onn Malaysia
content_source UTHM Institutional Repository
url_provider http://eprints.uthm.edu.my/
language English
topic TA168 Systems engineering
spellingShingle TA168 Systems engineering
Kasim, Shahreen
Sinnasamy, Surain R.
Wui, Xiang Chiam
Cha, Pei Fong
Eng, Kong Yeoh
Wahid, Norfaradilla
Hafit, Hanayanti
A review of concurrency control technique in distributed database
description Concurrency is a process where multiple simultaneous transactions of data in database system perform. Due to this condition, the concurrency control method can help and avoid the data inconsistencies when the system is accessed by the user. This paper elaborately discusses the distributed database in the aspect of concurrency control techniques. This research reviews three algorithms; DSL, VGA, and SBA in terms of the waiting time, validation, performance, delay and also the number of message exchange. SBA shows the best performance among others. Meanwhile, a comparison between FBS and S2PL be done in order to measure the time of response in high and low-security level. In Addition, the fairness level of the system also been measured. It is shown that FBS shows an improving of time and positive result when dealing with a high-security level performance of the transaction. FBS also improved in terms of fairness at the different level of security.
format Article
author Kasim, Shahreen
Sinnasamy, Surain R.
Wui, Xiang Chiam
Cha, Pei Fong
Eng, Kong Yeoh
Wahid, Norfaradilla
Hafit, Hanayanti
author_facet Kasim, Shahreen
Sinnasamy, Surain R.
Wui, Xiang Chiam
Cha, Pei Fong
Eng, Kong Yeoh
Wahid, Norfaradilla
Hafit, Hanayanti
author_sort Kasim, Shahreen
title A review of concurrency control technique in distributed database
title_short A review of concurrency control technique in distributed database
title_full A review of concurrency control technique in distributed database
title_fullStr A review of concurrency control technique in distributed database
title_full_unstemmed A review of concurrency control technique in distributed database
title_sort review of concurrency control technique in distributed database
publisher Penerbit UTM Press
publishDate 2018
url http://eprints.uthm.edu.my/6059/1/AJ%202018%20%281011%29%20A%20review%20of%20concurrency%20control%20technique%20in%20distributed%20database.pdf
http://eprints.uthm.edu.my/6059/
_version_ 1738581445055610880
score 13.211869