Question: 2 . ( 4 0 ' ) Consider a database with objects ( X ) and ( Y ) and assume

2.(40') Consider a database with objects \( X \) and \( Y \) and assume that there are two transactions T1 and T2. Transaction \( T 1\) reads objects \( X \) and \( Y \) and then writes object \( X \). Transaction \( T 2\) reads objects \( X \) and \( Y \), then reads \( X \) once more, and finally writes objects \( X \) and \( Y \)(i.e. T1: R(X), R(Y), W(X);T2: R(X), R(Y),\( R(X), W(X), W(Y))\)
1. Give an example schedule with actions of transactions T 1 and T 2 on objects X and Y that results in a write-read conflict.
2. Give an example schedule with actions of transactions T 1 and T 2 on objects X and Y that results in a read-write conflict.
3. Give an example schedule with actions of transactions T 1 and T 2 on objects X and Y that results in a write-write conflict.
4. For each of the three schedules, show that Strict 2PL disallows the schedule.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!