Question: Consider using the timestamps protocol with Thomas' Write Rule modification. Explain what DBMS will do with each of the following transactions. Give the read
Consider using the timestamps protocol with Thomas' Write Rule modification. Explain what DBMS will do with each of the following transactions. Give the read timestamp (R-ts) and write timestamp (W-ts) for each data item after each case. (a) Transaction T1, with timestamp 18, wishes to write a data item A, and this data item has the following timestamps (R-ts(A) = 8), and (W-ts(A) = 7). (b) Transaction T2, with timestamp 19, wishes to write a data item B, and this data item has the following timestamps (R-ts(B) = 22), and (W-ts(B) = 21). (c) Transaction T3, with timestamp 13, wishes to read a data item C, and this data item has the following timestamps (R-ts(C) = 17), and (W-ts(C) = 12).
Step by Step Solution
3.49 Rating (156 Votes )
There are 3 Steps involved in it
A solution The DBMS will compare the timestamp of the transaction T1 with the read and write timesta... View full answer
Get step-by-step solutions from verified subject matter experts
