Abstract
In database management system, there always comes a time where we need to execute various transactions simultaneously, and thus the database consistency must be maintained. The way to make sure that this consistency between the shared databases is maintained is to use concurrency control techniques. Most of the concurrency control techniques are developed using the serializability property in mind. The serializability property makes sure that the accessed data is in the manner of mutual exclusion, meaning that whenever one transaction is accessing a data, other transaction will not be able to access the same data. This paper deals with another viewpoint of various concurrency control techniques, there comparison based on the data obtained practically. Furthermore, a comparison of pessimistic, optimistic, multiversion, and two-phase locking techniques is done. We have set up an environment to analyze the performance and compare these techniques analytically.
This is a preview of subscription content, log in via an institution to check access.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
References
JongBeom Lim, Young Sik Jeong, Doo-Soon Park, HwaMin Lee, “An efficient distributed mutual exclusion algorithm for intersection traffic control”.
Philip A. Bernstein, Nathan Goodman, “Timestamp-based algorithms for concurrency control in distributed database systems” in Proceeding of the sixth international conference on Very Large Data Bases - Volume 6.
C. Mohan, Don Haderle, Yun Wang, Josephine Cheng, “Single table access using multiple indexes: Optimization, execution, and concurrency control techniques” in Volume 416 of the book series Lecture Notes in Computer Science (LNCS).
Michael Wei, Amy Tai, Chris Rossbach Ittai Abraham, “Silver: Ascalable, distributed, multi-versioning, Alwaysgrowing(Ag)FileSystem”.
C. MOHAN, “ARIESIKVL: A Key-Value Locking Method for Concurrency Control of Multiaction.Transactions Operating on B-Tree Indexes” in Proceedings of the 16th VLDB Conference Brisbane, Australia, August 1990.
Sonal Kanungo1, Morena Rustom. D2, “Analysis and Comparison of Concurrency Control Techniques” in International Journal of Advanced Research in Computer and Communication Engineering Vol. 4, Issue 3, March 2015.
Praveen Kumar, Dr. Vijay S. Rathore “Improvising and Optimizing resource utilization in Big Data Processing” in the proceeding of 5th International Conference on Soft Computing for Problem Solving (SocProS 2015) organised by IIT Roorkee, INDIA (Published in Springer), Dec 18–20, 2015. PP 586–589.
H. T. Kung, “On optimistic methods for concurrency control” in ACM Transactions on Database Systems (TODS) Volume 6 Issue 2, June 1981.
Sheril Yadav “Analysis and Implementation of Business Intelligence Software for Report Bursting” International Conference in Smart Computing & Informatics (SCI-2017) held in ANITS, Visakhapatnam March 2017.
Rashmi Priyadarshi, Seema Rawat, Praveen Kumar An implementation of opinion mining using fuzzy inference system in Computational Intelligence on Power, Energy and Controls with their impact on Humanity (CIPECH), 2014 Innovative Applications in 2014.
Author information
Authors and Affiliations
Corresponding author
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2018 Springer Nature Singapore Pte Ltd.
About this paper
Cite this paper
Zaidi, N., Kaushik, H., Jain, D., Bansal, R., Kumar, P. (2018). Analytical Comparison of Concurrency Control Techniques. In: Bhateja, V., Nguyen, B., Nguyen, N., Satapathy, S., Le, DN. (eds) Information Systems Design and Intelligent Applications. Advances in Intelligent Systems and Computing, vol 672. Springer, Singapore. https://doi.org/10.1007/978-981-10-7512-4_102
Download citation
DOI: https://doi.org/10.1007/978-981-10-7512-4_102
Published:
Publisher Name: Springer, Singapore
Print ISBN: 978-981-10-7511-7
Online ISBN: 978-981-10-7512-4
eBook Packages: EngineeringEngineering (R0)