Give an example of a schedule of two transactions in which a two-phase locking concurrency control
a. makes one of the transactions wait, but a control implementing SNAPSHOT isolation aborts one of the transactions.
b. aborts one of the transactions (because of a deadlock), but a control implementing SNAPSHOT isolation allows both transactions to commit.
a. r1(x) w1(x) r2(y) w2(x) commit2
A two-phase locking concurrency control would make T2 wait, but a SNAPSHOT isolation control would abort T1, since T2 was the first committer.
b. r1(x) r2(y) w2(x) w1(y)
You might also like to view...
While viewing a report in Print Preview, the Margins button is found in the ________ group
A) Page Layout B) Data C) Zoom D) Page Size
The information systems operations group is responsible for the day-to-day running of IS hardware to process the organization's information systems workload.
Answer the following statement true (T) or false (F)