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...
| Main Authors: | , , , , , , |
|---|---|
| Format: | Article |
| Language: | English |
| Published: |
Penerbit UTM Press
2018
|
| Subjects: | |
| Online Access: | http://eprints.uthm.edu.my/6059/ http://eprints.uthm.edu.my/6059/1/AJ%202018%20%281011%29%20A%20review%20of%20concurrency%20control%20technique%20in%20distributed%20database.pdf |
| _version_ | 1848888702050238464 |
|---|---|
| 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 |
| building | UTHM Institutional Repository |
| collection | Online Access |
| 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. |
| first_indexed | 2025-11-15T20:14:28Z |
| format | Article |
| id | uthm-6059 |
| institution | Universiti Tun Hussein Onn Malaysia |
| institution_category | Local University |
| language | English |
| last_indexed | 2025-11-15T20:14:28Z |
| publishDate | 2018 |
| publisher | Penerbit UTM Press |
| recordtype | eprints |
| repository_type | Digital Repository |
| spelling | uthm-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 |
| 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 |
| title | 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_short | A review of concurrency control technique in distributed database |
| title_sort | review of concurrency control technique in distributed database |
| topic | TA168 Systems engineering |
| url | http://eprints.uthm.edu.my/6059/ http://eprints.uthm.edu.my/6059/1/AJ%202018%20%281011%29%20A%20review%20of%20concurrency%20control%20technique%20in%20distributed%20database.pdf |