Register

Recent questions tagged view-serializable

125
views
0 answers
0 votes
View serializable
S2: R1(x);r2(z);r3(x);r1(z);r2(y);r3(y);w1(x);w2(z);w3(y);w2(y)Please help
User Avatar
301
views
1 answers
0 votes
Self Doubt on serializable
If a schedule is not conflict-serializable. Is it serializable?
User Avatar
245
views
0 answers
0 votes
Serializability
What is Proof/Explanation for complexity to test if a schedule is conflict serializable is O(n^2) whereas for view serializable is O(2^n)-Exponential ?
User Avatar
363
views
1 answers
1 votes
Self Doubt
S:- R1(x) R1(y) W1(x) R2(z) R2(y) W3(y) R2(y)Schedule is view Serializable or not ?
User Avatar
424
views
1 answers
0 votes
made easy - advance level full test - serializability
Consider the following schedule:R2(A), R1(A), R3(B), W3(B), W2(A), R1(A)Is the above schedule view serializable?
User Avatar
496
views
2 answers
0 votes
Applied Test Series: Mock
Consider the following schedule S:S: R3(A), W2(A), R1(A), W3(A), W1(A);The possible number of view serializable schedules of the schedule S (other than S) are _____Can someone help me in this.
User Avatar
493
views
1 answers
0 votes
Self doubt - Serializability - DBMS
Can a schedule be serializable if it is not view serializable? Are conflict equivalence and view equivalence the only two ways to decide if a schedule is serializable?
User Avatar
324
views
1 answers
0 votes
conflict serializable
Find Total no of conflict serializable and view serializableT1: R1(A) W1(A) R1(B) W1(B)T2: R2(A) W2(A) R2(B) W2(B)
User Avatar
323
views
1 answers
1 votes
view serializable
Find View SerializableT1 : R1(A) , R1(B) , W1(B)T2 : R2(A) , R2(B) , W2(B)
User Avatar
8.4k
views
1 answers
2 votes
Geeksforgeeks: GATE CS Mock 2018
Consider the given schedule and choose the suitable option S = T1:R(x), T1:R(y), T1:W(x), T2:R(y), T3:W( ... not view serializableSchedule is view serializable but not conflict serializableNeither view serializable nor conflict serializable
User Avatar
733
views
0 answers
1 votes
Made Easy Databases
Consider the following schedules with data item xThe number of serial schedules which are view equal to schedules but not conflict equal is ___________.
User Avatar
2.5k
views
4 answers
3 votes
No. of View equivalent schedules
how many view equivalent schedules are possible for the Sch given below:
User Avatar
1.6k
views
1 answers
1 votes
View Serializability
Consider following Schedule S with data item x :S : W1(X) R2(X) W3(X) R4(X) W5(X) R6(X) W7(X) R8(X) W9(X) R10(X)The number of schedule view equivalent to Schedule S but not conflict equivalent to Schedule S ?
User Avatar
1.6k
views
2 answers
0 votes
Self Doubt Blind Write
Why having a Blind Write may help a schedule(which is not conflict serializable) to be view serializable ?I can see check the condition and verify this. but i don ... I read books but my doubt is still there. Please help me out guys. Thanks
User Avatar
570
views
0 answers
2 votes
Self Doubt: Is this schedule conflict Serializable?
My question, does abort in T2 makes this schedule conflict serializable? as the effect of T2 will be null. T1: Rx T2: Wx T1: Wx T2: ABORT T1: COMMITRx – read item x.Wx – write item x.
User Avatar
1.0k
views
2 answers
3 votes
Self Doubt on serializable
Why is Blind write necessary for a view serializable schedule that is not conflict serializable?
User Avatar
328
views
1 answers
1 votes
[Personal Doubt] View Serializability
Is every serializable schedule view serializable?, or like conflict serializable, there could be a serializable schedule which isn’t view serializable?
User Avatar
2.0k
views
1 answers
1 votes
Thomas write rule doubt
there is a schedule which is allowed in Thomas write rule so it is view serializable. Suppose at a point write operation of an older transaction is ignored. then the same operation will be ignored in its serial order?
User Avatar
1.2k
views
1 answers
0 votes
Raghuramkrishnan
T1: R(X), T2: W(X), T2: commit, T1: W(X), T1: commit, T3: R(X), T3: commitis this allowed in Thomas write rule?if yes then what will be the serial order
User Avatar
1.3k
views
1 answers
1 votes
RaghuramKrishnan
Tl:W(X), T2:R(X), Tl:W(X), T2:Commit, Tl:Abortis this schedule conflict serializable?
User Avatar
914
views
0 answers
0 votes
Number of Conflict Equal and View Equal Schedules
How many Conflict Serializable and View serializable schedules for the Schedule given below$S:r_1(A),w_1(B),w_1(C),r_2(A),w_2(B),w_2(C)$To both my answer comes to be 7.Is it correct?
User Avatar
501
views
2 answers
2 votes
Databases
State true or false: a schedule has only constrained write operations and the schedule is view serializable then it's also conflict serializable
User Avatar
1.2k
views
1 answers
1 votes
Serializability
User Avatar
1.7k
views
1 answers
2 votes
View Serializability
Consider the following schedules: Which of the following is correct about above schedule?Only view serializableOnly conflict serializableBoth conflict and view ... serializable.Please tell me the approach for checking view serializability ?
User Avatar
3.7k
views
1 answers
9 votes
Are aborted transactions ALWAYS ignored when determining result/view/conflict serializability?
I am looking for some clarity on this topic. Here is some random schedule as an example: ... cascading rollbacks.I would be grateful if the question would be answered since this really confuses me.
User Avatar
497
views
0 answers
2 votes
TheGateBook
S1: R(A) W(A) W(B) S2: R(A) W(A) R(B) W(B)How many view serializable schedules are possible which are not conflict serializable?(A) 0 (B) 1 (C) 2 (D) 3
User Avatar
509
views
0 answers
0 votes
View equivalent
Schedules are not view equivalent because of not having similar UPDATE READ ?
User Avatar
Page: