0 votes 0 votes S:R1(x),w1(x),R2(x),R1(y),w2(x),C2,A1 why it is violating Ti->Tj condition? gabbar asked Nov 1, 2016 gabbar 700 views answer comment Share Follow See all 6 Comments See all 6 6 Comments reply sudsho commented Nov 1, 2016 reply Follow Share i dont think it is violating any such condition...if there was a loop between T1 and T2 then the condition would have been violated....but we are getting a serialisable schedule from T1->T2... 1 votes 1 votes gabbar commented Nov 1, 2016 reply Follow Share please visit this link https://www.youtube.com/watch?v=Wa_z_8q0I8Y lecture time 13.40...question no 5.. 0 votes 0 votes sudsho commented Nov 1, 2016 reply Follow Share ohh ohkk...u wre asking about recoverability.. then yes it is violating.. see T2 is reading x from T1..and it is getting commited before T1..so it is not recoverable....if u r reading from a transition then let that gets commited first then u commit..but it is not happening here...i hope u got it.. why actually this is not right...because see T1 is getting aborted after some time.....so whatever T2 has read from it earlier before getting commited is a fault now.....so if u r reading from something let that commit first else ur schedule will not be recoverable.. 0 votes 0 votes gabbar commented Nov 1, 2016 reply Follow Share firstly m sorry for not completing my question... yeah got it.. thank,..but in the line "whatever T2 has read from it earlier before getting commited is a fault now.....so if u r reading from something let that commit first else ur schedule will not be recoverable.."i m stuck here.. 0 votes 0 votes sudsho commented Nov 1, 2016 reply Follow Share means like if u r taking some food from a stranger(reading from someone)..then what will u do to be safe....let him eat first(let that transition commit first)...then u can be sure and can eat(now u commit)..else u may die(not recoverable).....got it 1 votes 1 votes gabbar commented Nov 1, 2016 reply Follow Share yeah got it..thnx bro 1 votes 1 votes Please log in or register to add a comment.
1 votes 1 votes 2nd transaction reads the value that is updated by the first transaction and commit of second transaction is done first. if there is any failure ocurs first tranaction is rollback but 2nd transaction we cannot because it is already commited. so it is irrecoverable schdeule. so commit of 2nd transaction is delayed until commit or rollback of first transaction santhoshdevulapally answered Nov 4, 2016 santhoshdevulapally comment Share Follow See all 0 reply Please log in or register to add a comment.