in Databases
7,390 views
8 votes
8 votes

Consider the following schedule:

S : w1(A) w1(B) r2(A) w2(B) r3(A) w3(B)

The number of schedules conflict equivalent are __________ .

in Databases
by
7.4k views

12 Comments

8?..
5
5
edited by
plz explain
1
1
$8$ different schedules possible?
0
0
Yup, that's the answer given. How?
0
0

I used topological ordering and got 8 as answer .
other approach is given in this question :

https://gateoverflow.in/195950/conflict-serializability :

2
2

How did topological ordering give you 8??

This would be the graph, right? This gives only one way T1---> T2---> T3.

1
1
@sumaiya  
this will give conflict equvalent serial schedule
0
0
instructions are numbered 1-6  in according to the order mentioned in the question.

123456

123546

125346

132456

132546

135246

152346

153246
0
0
how??
0
0

@

its asking for conflict equivalent and not conflict serializable.

0
0

see the first comment under this qsn - https://gateoverflow.in/10299/conflict-equivalent

0
0

5 Answers

14 votes
14 votes
Best answer

............................

edited by

4 Comments

oh k maybe I am wrong...
0
0

I think this is the correct approach 

https://gateoverflow.in/10299/conflict-equivalent

2
2
thanks
0
0
6 votes
6 votes

I think this should do it . 

 

2 Comments

@   If you see conflict equivalent schedule for this it will be T1 -> T2 -> T3, So how can we take operation 5 before T2 .

0
0

@sags.sharma position of 5 will not affect the conflict serializability. please check..

0
0
1 vote
1 vote
you can arrange R3 at 4 places and R2 at 2 places   

 so total 8 way possible   as there is no dependency between R2 and R4
1 vote
1 vote

let me know if there is any mistake-

 

Answer:

Related questions