Deadlock in DBMS

A deadlock occurs when there is a setoff process waiting for a resource held by the other processes in the same set. This paper describes the deadlock detection and prevention using wait for graph and some deadlock resolution algorithms which resolves the deadlock by selecting victims using different criteria. In a multi process system, deadlock is a situation, which arises in a shared resource environment where a process indefinitely waits for a resource, which is held by some other process, which in turn waiting for a resource held by some other process. To prevent any deadlock situation in the system, the DBMS aggressively inspects all the operations which transactions are about to execute. DBMS inspects operations and analyzes if they can create a deadlock situation. If it finds that a deadlock situation might occur, then that transaction is never allowed to be executed. Durgesh Raghuvanshi "Deadlock in DBMS" Published in International Journal of Trend in Scientific Research and Development (ijtsrd), ISSN: 2456-6470, Volume-4 | Issue-3 , April 2020, URL: https://www.ijtsrd.com/papers/ijtsrd24064.pdf