Modern Database Management: Chapter 11 Review Question 19

Question

What is the difference between deadlock prevention and deadlock resolution?

Answer

Deadlock is a process that does not use any resources. It occurs when multiple transactions lock the same resource, and each transaction is waiting for the resource unlock time. There are two ways to deal with deadlocks, as listed below:

Deadlock Prevention

As the name implies, prevention means avoiding all conditions for deadlocks. It is a way to resolve deadlocks by providing all requirements at the beginning of the process. In deadlock prevention, resource locking must be performed. It does not include measures built into the DBMS. In this type, there are no measures or methods for deadlock detection.

Deadlock Resolution

It allows deadlocks to occur but uses mechanisms built into the database management system to detect and break them. In deadlock resolution, no resource lock should be performed. Contains measures built into the DBMS to manage deadlocks. In this regard, there is a measure for deadlock detection and breaking.