Consider using the timestamps protocol with Thomas' Write Rule modification. Explain what DBMS will do with...

 

Transcribed Image Text:

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). 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).

Answer rating: 100% (QA)

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