Main Article Content
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.
This work is licensed under a Creative Commons Attribution-NonCommercial-NoDerivatives 4.0 International License.
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)
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