Question: Consider a database with objects X and Y and assume that there are two transactions T1 and T2. Transaction T1 reads objects X and Y

Consider a database with objects X and Y and assume that there are two transactions T1 and T2. Transaction T1 reads objects X and Y and then writes object X. Transaction T 2 reads objects X and Y and then writes objects X and Y.
1. Give an example schedule with actions of transactions T1 and T 2 on objects X and Y that results in a write-read conflict.
2. Give an example schedule with actions of transactions T1 and T 2 on objects X and Y that results in a read-write conflict.
3. Give an example schedule with actions of transactions T1 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

3.21 Rating (173 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

1 The following schedule results in a writeread conflict T2RX T2RY T2W... View full answer

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

Document Format (1 attachment)

Word file Icon

960-C-S-D (2484).docx

120 KBs Word File

Students Have Also Explored These Related Databases Questions!