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 Databases databases transaction-and-concurrency concurrency timestamp-ordering view-serializable + – aditi19 asked Dec 1, 2018 aditi19 1.1k views answer comment Share Follow See all 2 Comments See all 2 2 Comments reply Deepanshu commented Dec 1, 2018 reply Follow Share t1 ,t2 ,t3 wil be order 1 votes 1 votes Tiger12335 commented Jan 11, 2020 reply Follow Share @deepanshu how it will be?.can you explain. iam getting answer as t2,t3,t1 0 votes 0 votes Please log in or register to add a comment.
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 . sachin486 answered Nov 19, 2020 sachin486 comment Share Follow See all 0 reply Please log in or register to add a comment.