0 votes 0 votes S=r1(A),w2(A),r3(A),w1(A),w3(A) Is this Schedule Non Recoverable? As there is a dirty read happening at w2(A)->r3(A) Databases databases transaction-and-concurrency dirty recoverable read + – sripo asked Nov 25, 2018 sripo 660 views answer comment Share Follow See all 5 Comments See all 5 5 Comments reply Show 2 previous comments Shamim Ahmed commented Nov 26, 2018 reply Follow Share There may be rollback in upcoming steps :) 0 votes 0 votes sripo commented Nov 26, 2018 reply Follow Share Maybe rollback cannot imply that transaction is cascading right? It can also be cascadless. 0 votes 0 votes Shamim Ahmed commented Nov 26, 2018 reply Follow Share If a rollback leads to rollback of other transactions, then its cascading... The commit operations should be there after write operations to avoid dirty read and hence cascade. you may refer:- https://www.quora.com/What-is-the-difference-between-cascading-shedule-and-recoverable-shedule 0 votes 0 votes Please log in or register to add a comment.
0 votes 0 votes If T2 commits before T3 then it is recoverable with cascading rollback If T3 commits before T2 then it is not recoverable Asutosh answered Nov 30, 2018 Asutosh comment Share Follow See all 0 reply Please log in or register to add a comment.