2 votes 2 votes (TS: time stamp) If TS (T) < Read-TS (Q), then write is rejected and T is rolled back If TS (T) < write-TS (Q), then write is rejected and T is rolled back Both (A) and (B) None of these Databases databases transaction-and-concurrency test-series + – techbrk3 asked Nov 9, 2017 techbrk3 1.5k views answer comment Share Follow See all 0 reply Please log in or register to add a comment.
Best answer 3 votes 3 votes both are true! 1. a younger transaction has already read the data item, so older transaction is not allowed to update it. 2. a younger transaction has already written the data item, so older transaction is not allowed to write it. Basic Timestamp ordering protocol: Manu Thakur answered Nov 9, 2017 • selected Nov 10, 2017 by Manu Thakur Manu Thakur comment Share Follow See all 3 Comments See all 3 3 Comments reply techbrk3 commented Nov 9, 2017 reply Follow Share a younger transaction means Read-TS (Q) in option A and Write-TS (Q) in option B ? so we take it as Write (Q) TS (T) < Read-TS (Q) ? 0 votes 0 votes Manu Thakur commented Nov 9, 2017 reply Follow Share Read-TS(Q) = max ( timetimeps of all the transactions which performed a successful read operation on data item Q) TS < Read-TS(Q) means timestamp of the transaction which is trying to write Q, has lesser timestamp than than the transaction which has performed read operation successfully. same in the case of 2nd statement. 0 votes 0 votes Manu Thakur commented Nov 9, 2017 reply Follow Share see my updated solution! 0 votes 0 votes Please log in or register to add a comment.