A study of Concurrency control techniques in Distributed database
Keywords:
Distributed Database, DeadlockAbstract
This paper surveys the basic concurrency control techniques in Distributed database system. Distributed database is the collection of the databases stored at different sites in the interrelated manner over the network. Concurrency control techniques are required because parallel transactions are to be executed at the same time. In this paper i have discussed various concurrency control techniques, their advantages and disadvantages and make comparative study between them.
Replication of data states, that the same copy of data has been maintained in different sites so that if one data sites fails, the same data can be recovered by other sites and execution of the query can be done by taking the data from other sites. But to use the replica we need to maintain the concurrency control techniques, otherwise inconsistency can occur in the execution of the transactions and incorrect value can occur.
References
Manoj Kumar Sah 1, Vinod Kumar 2, Ashish Tiwari 3,Security and Concurrency Control in Distributed Database System, International Journal of scientific research and management(IJSRM), Volume 2,Issue 11 Pages 1839-1845 ,2014
D. G. Shin, and K. B. Irani, “Fragmenting relations horizontally using knowledge based
approach,” IEEE Transactions on Software Engineering (TSE), Vol. 17, No. 9, pp. 872–883, 1991.
E. S. Abuelyaman, “An optimized scheme for vertical partitioning of a distributed database,” Int. Journal of Computer Science & Network Security,Vol. 8, No.1, 2008.
Gupta Dhiraj and Gupta V.K., Approaches for Deadlock Detection and Deadlock Prevention for Distributed, Res. J. Recent Sci., 1(ISC-2011), 422-425 (2012).
Michael J. Carey Miron Livny ,Distributed Concurrency Control Performance: A Study of Algorithms, Distribution, and Replication, Computer Sciences Department University of Wisconsin Madison, WI 53706.
Md. Tabrez Quasim, (2013). An Efficient Approach For Concurrency Control In Distributed Database System. Indian Streams Research Journal, Vol. III, Issue. IX
Bernstein P and Goodman N "Timestamp-Based Algorithms for Concurrency Control in Distributed Database Systems,” Proc. 6th VLDB Cot& Mexico City, Mexico, Oct.1980.
M. AlFares et al, “Vertical Partitioning for Database Design: A Grouping Algorithm”, in Proc. International Conference on Software Engineering and Data Engineering (SEDE), 2007, pp. 218-223.
Applications", ACM Computing Surveys, Vol 23, No 3, September 1991.
