Deadlock detection is very difficult in a distributed database system because no controller has complete and current information about the system and data dependencies. The deadlock problem is intrinsic to a distributed database system which employs locking as its concurrency control algorithm. This paper attempts a comprehensive study of deadlock detection in distributed database systems. Afterwards, a deadlock detection algorithm is presented. The algorithm is based on creating linear transaction structure (LTS), distributed transaction structure (DTS), finding local and global cycle, deciding priority Id of the transaction and local-global abortion. The proposed algorithm does not detect any false deadlock or exclude any really existing deadlocks. In this technique global deadlock is not dependent on the local deadlock.
History
Source title
Proceedings of the 6th International Conference on Information Technology: New Generations
Name of conference
6th International Conference on Information Technology: New Generations, 2009 (ITNG '09)
Location
Las Vegas, NV
Start date
2009-04-27
End date
2009-04-29
Pagination
730-737
Publisher
Institute of Electrical and Electronics Engineers (IEEE)
Place published
Piscataway, NJ
Language
en, English
College/Research Centre
Faculty of Engineering and Built Environment
School
School of Electrical Engineering and Computer Science