in Databases
376 views
2 votes
2 votes
If some schedule is not conflict serializable then it can never be view serializable is it true?

Or vice versa.
in Databases
376 views

3 Comments

if a schedule is not a conflict equivalent then it may be VIEW equivalent ...

for that you need to look out for it ..like there must be a blind write ...

also..you can draw a polygraph and see is ..it creating cycle or not ..if it create cycle ..its not view too...

so

IF SCHEDULE IS CONFLICT EQ. then 100% view equivalent ..if not then check the conditions ...it may or may not view eq.
0
0
not true

C.S. determines V.S.

but vice versa not true
0
0

False : Here is one such example : https://gateoverflow.in/199851/ace-db

0
0

2 Answers

0 votes
0 votes

if a schedule is not conflict then it may or may not be view serilizable.

so it is false.

0 votes
0 votes
  1. If a schedule is Conflict Serializable, then it is also View Serializable and hence Serializable.   TRUE
  2. If a schedule is not Conflict Serializable, then it may or may not be View Serializable.  TRUE

           We check the View Serializability through Blind Writes and Poly Graph.

      3. If a schedule is View Serializable, then it may or may not  be Conflict Serializable.  TRUE

      4. If a schedule is not View Serializable then it is also not Conflict Serializable.    TRUE