Give an example of a schedule of two transactions in which a two-phase locking concurrency control causes one of the transactions to wait but a SNAPSHOT isolation control aborts one of the transactions.
What will be an ideal response?
The schedule as handled by a two-phase locking concurrency control:
r1(x) w1(x) r2(y) Request[w2(x)] commit1 Execute[w2(x)] commit2
The schedule as handled by a SNAPSHOT isolation control:
r1(x) w1(x) r2(y) w2(x) commit1 Request[commit2] abort2
Computer Science & Information Technology
You might also like to view...
Which IE tab enables you to configure the web page that opens when the browser application starts?
A) Connections B) Programs C) General D) Content
Computer Science & Information Technology
The final round of both encryption and decryption of the AES structure consists of __________ stages.
A. one B. two C. three D. four
Computer Science & Information Technology