Consider the following transaction schedules For each one de

Consider the following transaction schedules. For each one, determine if the schedule is conflict serializable and determine the equivalent serial schedules. Please note that there may be several equivalent serializable schedules and you should determine all of them.
a) T1: R(X); T3: R(X); T1: W(X); T2: R(X); T3: W(X)
b) T3: R(X); T2: R(X); T3: W(X); T1: R(X); T1: W(X)

Solution

total schedule = 6!/2!*2!*2! = 90
and every schedule is conflict equal schedule because no cycle in any precedence graph ..
by symmetry each serial schedule must have equal no of conflict schedule..
der are 90 schedule and 3! serial schedule..
T1 ----> T2 ----> T3 is one out of 6 serial schedule.
so no ofconflict equal schedule which is equal to T1 ----> T2 ----> T3
= 90/6 = 15

Consider the following transaction schedules. For each one, determine if the schedule is conflict serializable and determine the equivalent serial schedules. Pl

Get Help Now

Submit a Take Down Notice

Tutor
Tutor: Dr Jack
Most rated tutor on our site