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 

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

1 Expert Approved Answer
Step: 1 Unlock

A solution The DBMS will compare the timestamp of the transaction T1 with the read and write timesta... View full answer

blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!