1,132 views
0 votes
0 votes
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

1 Answer

1 votes
1 votes

According to Thomas write rule T1-w(X) will be discarded.

for sake of view serializability T1 will be at first place for first read transaction rule 

U can place T2 and T3 in any place (second or third) it will satisfy last write transaction rule there is no write read dependency .

Related questions

2 votes
2 votes
0 answers
1
susgir2 asked Dec 31, 2018
535 views
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...
3 votes
3 votes
3 answers
2
shivangi5 asked Dec 6, 2017
2,835 views
Consider the 2 transactionsT1: R(A) W(A) W(B)T2: 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(...
7 votes
7 votes
3 answers
4
Supremo asked Jan 28, 2017
2,132 views
$S: R_1(A),R_2(B),W_2(A),W_3(C),R_4(C),R_3(A),W_3(B),R_4(A),W_2(B),W_4(B),W_3(A)$View serializable or not?