Question: Consider the following concurrency control protocols: 2 PL , Strict 2 PL , Conservative 2 PL , Timestamp without the Thomas Write Rule, Times tamp
Consider the following concurrency control protocols: PL Strict PL Conservative PL Timestamp without the Thomas Write Rule, Times tamp with the Thomas Write Rule, and Multiversion.
a For each of the following schedules, state which of these protocols allows itthat is allows the actions to occur in exactly the order shown.
b Give reasons for at least two No answers if they were found for each concurrency technique.
Assume that the timestamp of transaction Ti is i
RX RX WX WX
WX RY RY RX
RX RY WXRY WY WX RY
RX WX WX T:Abort, T:Commit
RX RY WX RX RY
RX WX WX T:Commit, T:Commit
WX RX WX T:Commit, T:Commit
WX RX WX T:Commit, T:Abort
WX RX WX T:Abort, T:Commit
RX WX T:Commit, WY T:Commit, RY WZ T:Commit
RX WX T:Commit, WX T:Commit, RX T:Commit
RX WX WX RX T:Commit, T:Commit, T:Commit
Answer a by filling the table below:
PL SPL CPL TSwoTwr TSwTwr Multiv
example No No No No No No
Note the following abbreviations. SPL: Strict PL; CPL: Conservative PL; TS wo Twr: Timestamp without Thomas Write Rule; TSw Twr : Timestamp withThomas Write Rule; MultiversionTSo :Multiv.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
