
144
■
Distributed Database Systems
deadlock prevention, distributed deadlock avoidance and distributed deadlock detection and
recovery from deadlock. These are described in the following.
Example 9.1
Let us assume that in a database environment there are two transactions T
1
and T
2
respectively.
Further assume that currently the transaction T
1
is holding an exclusive lock on data item P, and
the transaction T
2
is holding an exclusive lock on data item Q. Now, if the transaction T
1
requires a
write operation on data item Q, the transaction T
1
has to wait until the transaction T
2
releases the
lock on the data item Q. However, in the meantime if the ...