The Gateway to Computer Science Excellence
+1 vote
check whether it is view serializable or not?

schedule S:R1(X),W2(X),W1(X)
in Databases by Active (2.3k points) | 2.9k views
Not view serializable as it violates the first point which says if transaction ti reads the initial value of x then transaction tj must read the initial value of x.  But instead of that transaction t2 has started writing x without reading it  

Can it be concluded like this

7 Answers

+11 votes
Best answer
no it is not view serializable..
reason is there may b 2 schedule possible :
1. T1--->T2
2. T2----->T1z
 in case 1 final write of x is done by T2, but in given question final write of x is done by T1. so it violates condition of view serializability.
in case 2 initial read of T1 is updated value by T2 but in original question it is directly reads database.. again condition of view serialization failed..

so not serializable schedule..
by Veteran (60.4k points)
edited by
can we say like this there is no serial schedule available so it is not view searializable..
a particular schedule may not be serial but it may be serialisable. but reverse is not always true..
see following implications :

1. serial -----> serialisable
2. view serialisable <-------> serialisable
3. conflict serialisable ------> view serialisable
4. not serialisable ---------> not serial

A schedule which is not serial but it may be View serialisable .. Serialisable too..
+3 votes

The ans can be viewed here

by Active (3.6k points)
+1 vote
This is definitely not CS as the precedence graph bears cycle.

This schedule is VS,as when we try to draw the view serializable graph ,we find no loops.
by Active (3.6k points)
how u draw view serializable graph ?

Even  we don't have to draw the graph,we can see that there is a blind write,having a blind write suffices the schedule to be VS and not CS.... 

  @arjun Sir @ laser0

its poly graph . we can draw for checking of vs. you can see here how to draw it. .
A schedule is view serial iff :
A. schedule is serial.
B. schedule is not serial but it is view equal to any one serial schedule..
Obviously given schedule is not serial.
If it is View Serial,  Can anyone gives serial schedule which is view equal to given schedule ???
according to me it is view serializable . i have already given explanation .. now you should ask from arjun sir..

sonam vyas in the link provided , after drawing polygraph in 2nd example we see there is a cycle b/w T1-T4 but still it says it is view-serializable and also gives a serial schedule .

can u please explain it?

+1 vote
schedule will be view serializable if 1. it is conflict  serializable then surly its vs.

                                                    2. if is not cs than we have to check blind write . if there is blind write then it may be or may not be vs. for that we have to draw poly graph . if there is cycle in the poly graph we can say its not vs other wise it is vs.or not serializable schedule also.

so this schedule is vs bcoz there is no cycle in poly graph.
by Boss (17k points)

 if BLIND write is there than surely that schedule is view serializable but not CONFLICT SERIALIZABLE.!!


IN given question there is blind write ..pls check question again ..
consider this schedule Sg: r1 (X); w2(X); W1(X); W3(X); CI; C2; C3; T1 T2 T3 r1(X) w2(X) W1(X) W3(X) C1 C2 C3 in the above schedule W2(x) and W3(X) are BLIND WRITE .!! but in the given question there is no blind write as LAST wirte{W1(X)} is done in T1 in which there is presence of R1(X). so in this question there is no BLIND WRITE therefore not VIEW SERIALIZABLE!!
you missed out something .. i said if there is blind write then we check it is vs or not but if there is not blind write then we does not check it... and in this question blind write is present in t2 transaction .and if there is blind write ,then we have to draw poly graph ,if in poly graph cycle is present then it will not vs otherwise it will be... so we cant say surly ,if there is blind write it must be vs.. we have to check by poly graph..

in this question firstly blind write is present and when we draw poly graph for it there is no cycle thats why it is vs...
0 votes
its not a view serilizable..because if read t1 the t2 can also read the transaction..
by (11 points)
0 votes
by Junior (593 points)
–2 votes
1.NO since there is a cycle in dependency graph
by (463 points)
cycle in dependency graph just giving information that schedule us NOT CONFLICT SERIALIZABLE..

 but der is a possibility that  schedule is VIEW SERIALIZABLE..

so checking cycle in dependency graph doesn't guaranty non serialization..

additionally Checking  schedule is Serializable or not is NPC and Cycle detection in dependency graph is P problem..
Quick search syntax
tags tag:apple
author user:martin
title title:apple
content content:apple
exclude -tag:apple
force match +apple
views views:100
score score:10
answers answers:2
is accepted isaccepted:true
is closed isclosed:true
50,650 questions
56,236 answers
95,856 users