Study of Concurrency Control Techniques in Distributed DBMS

Authors

Keywords:

DDBMS, Concurrency Control, Two Phase Locking

Abstract

Concurrency control focuses on maintaining consistency and integrity of database through synchronized access. The complexity relating to concurrency control in a distributed context is very high as compared to centralized framework due to maintaining consistency within the multiple fragments / copies of the database. This paper consolidates and discusses various lock based concurrency control techniques for Distributed DBMS. The paper also presents a comparative study of various two phase locking based concurrency control techniques.

Author Biographies

Manoj Kumar Gupta, Rukmini Devi Institute of Advanced Studies, Delhi, India

Dr. Manoj Kr. Gupta is presently working as Professor at Rukmini Devi Institute of Advanced Studies (Aff. to Guru Gobind Singh Indraprastha University), Delhi, India. He is also Dean Examination, Admission and Administration in the Institute. He has more than 20 years of experience in teaching and administration. His interest areas are Database Systems, Data Warehousing and Data Mining. He has 4 books and 18 international / national research papers to his credit.

Rakesh Kumar Arora, Krishna Engineering College, Ghaziabad, UP, India

Dr. Rakesh Kr. Arora is currently working as Associate Professor at Krishna Engineering College, Mohan Nagar, Ghaziabad, Uttar Pradesh, India. He has more than 16 years of teaching experience in reputed institutes. He has number papers in International Journals and Conferences to his credit.

Bhoopesh Singh Bhati, Ambedkar Institute of Advanced Communication Technologies and Research, Delhi, India

Bhoopesh Singh Bhati is Pursuing P.hD degree from the Guru Gobind Singh Indraprastha University, Delhi. He has obtained his M.Tech. Degree in Information Security and B. Tech. (Computer Science and Engineering) from the Guru Gobind Singh Indraprastha University, Delhi. He is presently working as an Assistant Professor in the Department of Computer Science and Engineering at Ambedkar Institute of Advanced Communication Technologies & Research, Govt. of NCT, Delhi, India. He has a number of Research Papers in International Journals and Conferences. His current research area is Information Security.

References

Bernstein, P. A. and Goodman N., “Concurrency Control in Distributed Database Systems”. ACM Computing Surveys, 13(2), June 1981 (DOI: 10.1145/356842.356846).

Bernstein, P. A. and Newcomer, E., “Principles of Transaction Processing for the Systems Professional”, Morgan Kaufmann, 1997.

Ceri, S. and Pelagatti, G., “Distributed Databases: Principles & Systems”, McGraw-Hill.

Desai, B. C., “An Introduction to Database Systems”, Galgotia, 2000.

G. Schlageter, “Problems of Optimistic Concurrency Control in Distributed Database Systems”, ACM SIGMOD Record, 13(3):62–66, April 1982 (doi>10.1145/984505.984510)

http://www.cs.helsinki.fi/u/jplindst/

http://www.vldb.org

Kumar, V., “Performance of Concurrency Control Mechanisms in Centralized Database Systems”, Prentice-Hall, 1996.

Özsu, M.T. and Valduriez P., “Principles of Distributed Database Systems”, Prentice-Hall, 3rd Edition, 2011

Ramakrishnan, R., and Gehrke, J., “Database Management Systems”, McGraw Hill International Edition, 2nd Edition

Silberschatz, A., Korth, H.F., and Sudarshan, S., “Database System Concepts”, McGraw Hill International Edition, 5th Edition

Joshi, H. and Bamnote, G.R., “Distributed Database: A Survey”, International Journal Of Computer Science And Applications Vol. 6, No.2, Apr 2013

Rawashdeh, Obaidah A., Hiba A. Muhareb, and Nedhal A. Al-Sayid. "An optimistic approach in distributed database concurrency control", 2013 5th International Conference on Computer Science and Information Technology, 2013.

Gupta, S., Saroha, K. and Bhawna, “Fundamental Research of Distributed Database”, Intl. Journal of Computer Science and Management Studies, Vol. 11, Issue 02, Aug 2011

"Distributed Databases", Encyclopedia of Information Systems, 2004

Zubi, Z.S., “On Distributed Database Security Aspects”, IEEE Explore, 2009

Tomar, P. and Megha, “An Overview of Distributed Databases”, International Journal of Information and Computation Technology, Volume 4, Number 2 (2014), pp. 207-214

Yadav, A.K. and Agarwal, A., “A Distributed Architecture for Transactions Synchronization in Distributed Database Systems”, International Journal on Computer Science and Engineering, Vol. 02, No. 06, 2010, pp. 1984-1991

Harding, R. and Aken, D.V., “An Evaluation of Distributed Concurrency Control”, Proceedings of the VLDB Endowment, Vol. 10, No. 5, 2017

Batra, N. and Kapil, A.K., “Concurrency Control Algorithms and its Variants: A Survey”, AIP Conference Proceedings, 2010

Sinde, V. and Aware, P.A., “Concurrency Control in Distributed Database Systems”, International Journal for Research in Engineering Application & Management (IJREAM), Vol-01, Issue 10, JAN 2016

Kahoro, P., Wanjiru, C. and Karumba, N., “Concurrency Control In Distributed Databases”, United States International University Africa, July 22, 2014

Abuya, T.K. and Cheruiyot W.K., “Guaranteeing Global Conflict Serializability in Concurrent Distributed Database Systems using Commitment Ordering”, International Journal of Computer Science and Mobile Computing, Vol.3 Issue.6, June 2014, pg. 700-707

Sah, M.K., Kumar, V. and Tiwari, A., (2014) “Security and Concurrency Control in Distributed Database System”, International Journal of scientific research and management (IJSRM), Volume 2, Issue 12, Pages 1839-1845, 2014

Gupta M.K. and Arora, R.K. (2009), Concurrency Control Techniques in Distributed DBMSs: A Comparative Study, IIMT Business Review 1 (1), 27-31

Vasileva S. And Milev A. (2016), “Simulation Studies of Distributed Two-phase Locking in Distributed Database Management Systems” , Information Technologies and Control, 13(1-2), DOI: 10.1515/itc-2016-0010

Downloads

Published

2018-12-28

How to Cite

Gupta, M. K., Arora, R. K., & Bhati, B. S. (2018). Study of Concurrency Control Techniques in Distributed DBMS. International Journal of Machine Learning and Networked Collaborative Engineering, 2(04), 180–187. Retrieved from https://mlnce.net/index.php/Home/article/view/58

Issue

Vol. 2 No. 04 (2018): Volume No 02 Issue No 04

Section

Articles

License

https://creativecommons.org/licenses/by/4.0/legalcode