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

Write a C++ program that uses the statements in Exercise 3.7 to calculate x raised to the y power. The program should have a while repetition statement.

What will be an ideal response?

Computer Science & Information Technology

What tool helps you detect and remove private or confidential information from a document?

A. Document Inspector B. Protect Document C. Privacy Inspector D. Prepare Document

Computer Science & Information Technology

WPA and WPA2 can implement enterprise mode authentication, where the access point passes authentication information to a _____ for validation.

A. Remote Authentication Dial-In User Service B. Circumference C. Remote Access Server D. One ring to control them all

Computer Science & Information Technology

The New Adjustment Layer command is located on the Layer menu.

Answer the following statement true (T) or false (F)

Computer Science & Information Technology