Approaches for Deadlock Detection and Prevention in Distributed Database System

Abstract: A distributed database system consists of different number of sites that are inter connected by a communication network. A deadlock may occur when a transaction enters into wait state which request resource from other blocked transactions. The deadlocks are handled in three phases namely deadlock detection, deadlock avoidance and deadlock detection. The efficiently resolving of a deadlock in a system is important because the persistence of deadlock has two major disadvantages: First, all the resources held by deadlocked processes are not available to any other process. Second, the deadlock persistence time gets added to the response time of each process involved in the deadlock. In this paper, we discuss deadlock detection techniques and present approaches for detecting deadlocks in Distributed Systems