Question: 2 . ( 4 0 ' ) Consider a database with objects ( X ) and ( Y ) and assume
Consider a database with objects X and Y and assume that there are two transactions T and T Transaction T reads objects X and Y and then writes object X Transaction T reads objects X and Y then reads X once more, and finally writes objects X and Y ie T: RX RY WX;T: RX RY RX WX WY
Give an example schedule with actions of transactions T and T on objects X and Y that results in a writeread conflict.
Give an example schedule with actions of transactions T and T on objects X and Y that results in a readwrite conflict.
Give an example schedule with actions of transactions T and T on objects X and Y that results in a writewrite conflict.
For each of the three schedules, show that Strict PL disallows the schedule.
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
