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
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 The following schedule results in a writeread conflict T2RX T2RY T2W... View full answer
Get step-by-step solutions from verified subject matter experts
Document Format (1 attachment)
960-C-S-D (2484).docx
120 KBs Word File
