in Databases
1,366 views
0 votes
0 votes

Is the following schedule conflict serializable

T1 T2 T3
W(X)    
commit    
  R(X)  
  W(X)  
    R(X)
    W(X)
    commit
  W(X)  
  commit  

 

in Databases
1.4k views

4 Comments

Because no cycle 

2
2

Correct me if I am wrong. 

@Shaik Masthan

@Mk Utkarsh

the schedule is not C.S as  we have a cycle in it(T2 , T3).. Commits dont' matter.

only aborts do as we don't count them while makeing dependency graph. 

0
0

@Shaik Masthan

For that gate 2014 questions ..the schedule is serializable because no cycle in graph ..its so happened coincidently that if we consider commit or not ..in both cases no cycle for that question ...diagram given by @Mk Utkarsh

is correct i think ..

 

0
0

1 Answer

0 votes
0 votes
Serializable but not recoverable..

Related questions