Dark Mode

Recent questions tagged view-serializable

0 votes

1 answer

1

Self Doubt on serializable
If a schedule is not conflict-serializable. Is it serializable?

abhinowKatore asked in Databases Sep 8, 2022

by abhinowKatore

270 views

0 votes

0 answers

2

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 ?

SakarKoot asked in Databases Sep 4, 2022

235 views

1 vote

1 answer

3

Self Doubt
S:- R1(x) R1(y) W1(x) R2(z) R2(y) W3(y) R2(y) Schedule is view Serializable or not ?

Manisha Jaishwal asked in Databases Aug 10, 2022

by Manisha Jaishwal

348 views

0 votes

1 answer

4

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?

atulcse asked in Databases Jan 10, 2022

400 views

0 votes

2 answers

5

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.

ramakrushna asked in Databases Dec 22, 2021

460 views

0 votes

1 answer

6

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?

atulcse asked in Databases Nov 2, 2021

448 views

0 votes

1 answer

7

conflict serializable
Find Total no of conflict serializable and view serializable T1: R1(A) W1(A) R1(B) W1(B) T2: R2(A) W2(A) R2(B) W2(B)

sambey4 asked in Databases Oct 16, 2021

314 views

1 vote

1 answer

8

view serializable
Find View Serializable T1 : R1(A) , R1(B) , W1(B) T2 : R2(A) , R2(B) , W2(B)

sambey4 asked in Databases Oct 15, 2021

306 views

2 votes

1 answer

9

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(y), T1:W(x), T2:R(y) Schedule is view serializable Schedule is conflict serializable but not view serializable Schedule is view serializable but not conflict serializable Neither view serializable nor conflict serializable

ushamya asked in Databases May 22, 2019

8.0k views

1 vote

0 answers

10

Made Easy Databases
Consider the following schedules with data item x The number of serial schedules which are view equal to schedules but not conflict equal is ___________.

Hirak asked in Databases May 5, 2019

by Hirak

709 views

3 votes

4 answers

11

No. of View equivalent schedules
how many view equivalent schedules are possible for the Sch given below:

Nandkishor3939 asked in Databases Jan 18, 2019

by Nandkishor3939

2.4k views

1 vote

1 answer

12

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 ?

Na462 asked in Databases Jan 13, 2019

by Na462

1.5k views

0 votes

2 answers

13

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’t understand the concept, i hope i am able to frame my question properly. I read books but my doubt is still there. Please help me out guys. Thanks

Aakash_ asked in Databases Jan 10, 2019

1.5k views

2 votes

0 answers

14

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: COMMIT Rx – read item x. Wx – write item x.

susgir2 asked in Databases Dec 31, 2018

549 views

3 votes

2 answers

15

Self Doubt on serializable
Why is Blind write necessary for a view serializable schedule that is not conflict serializable?

Saurabh1997 asked in Databases Dec 24, 2018

953 views

1 vote

1 answer

16

[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?

shreejeetp asked in Databases Dec 14, 2018

302 views

1 vote

1 answer

17

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?

aditi19 asked in Databases Dec 1, 2018

1.9k views

0 votes

1 answer

18

Raghuramkrishnan
T1: R(X), T2: W(X), T2: commit, T1: W(X), T1: commit, T3: R(X), T3: commit is this allowed in Thomas write rule? if yes then what will be the serial order

aditi19 asked in Databases Dec 1, 2018

1.1k views

1 vote

1 answer

19

RaghuramKrishnan
Tl:W(X), T2:R(X), Tl:W(X), T2:Commit, Tl:Abort is this schedule conflict serializable?

aditi19 asked in Databases Nov 17, 2018

1.2k views

0 votes

0 answers

20

smsubham asked in Databases Nov 12, 2018

560 views

0 votes

0 answers

21

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?

Ayush Upadhyaya asked in Databases Oct 11, 2018

by Ayush Upadhyaya

858 views

2 votes

2 answers

22

Databases
State true or false: a schedule has only constrained write operations and the schedule is view serializable then it's also conflict serializable

Ajaaz asked in Databases Aug 6, 2018

by Ajaaz

493 views

1 vote

1 answer

23

Serializability

Na462 asked in Databases Jul 14, 2018

by Na462

1.1k views

2 votes

1 answer

24

View Serializability
Consider the following schedules: Which of the following is correct about above schedule? Only view serializable Only conflict serializable Both conflict and view serializable Neither view serializable nor conflict serializable. Please tell me the approach for checking view serializability ?

Na462 asked in Databases May 29, 2018

by Na462

1.5k views

9 votes

1 answer

25

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: $r1(x) w1(x) r2(x) w2(x) r3(y) r3(x) w3(x) c3 a1 c2$ I was told, that for ... , strictness or avoidance of cascading rollbacks. I would be grateful if the question would be answered since this really confuses me.

flow2539 asked in Databases May 28, 2018

3.5k views

2 votes

0 answers

26

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

yolorn123 asked in Databases Jan 31, 2018

479 views

0 votes

0 answers

27

View equivalent
Schedules are not view equivalent because of not having similar UPDATE READ ?

Pawan Kumar 2 asked in Databases Jan 29, 2018

by Pawan Kumar 2

495 views

2 votes

1 answer

28

View-Serializability
Consider the following schedule with data item The number of serial schedules which are view equal to schedule(s) but not conflict equal to schedule(s) are ________.

Inspiron asked in Databases Jan 27, 2018

1.3k views

Page:

1
2
3
next »

Recent questions tagged view-serializable