Question: Give an example of three transactions that obey basic 2 PL and have the following property: when being executed, a deadlock involving all three transactions
Give an example of three transactions that obey basic PL and have the following property: when being executed, a deadlock involving all three transactions may occur.
What is a possible solution for the deadlock using transaction timestamps? Explain using the same schedule you have provided.
Notes:
Transactions must access at least three shared data items.
Schedules exhibit readwrite andor writewrite conflicts when executed concurrently.
Notes on grading: This question will be graded based on the correct choice and explanation of the schedule the correct answer for deadlock and the quality of the answer
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
