Extend the definition of two-phase locking to apply to distributed transactions. Explain how this is ensured by distributed transactions using strict two-phase locking locally.

What will be an ideal response?


Two-phase locking in a distributed transaction requires that it cannot acquire a lock at any server after it has released a lock at any server.
A client transaction will not request commit (or abort) (at the coordinator) until after it has made all its requests and had replies from the various servers involved, by which time all the locks will have been acquired. After that, the coordinator sends on the commit or abort to the other servers which release the locks. Thus all locks are acquired first and then they are all released, which is two-phase locking

Computer Science & Information Technology

You might also like to view...

How many parameters are there in a binary operator implemented as a friend?

a. 0 b. 1 c. 2 d. as many as you need

Computer Science & Information Technology

Define a function named average that returns as its value the average of its two type double input parameters.

What will be an ideal response?

Computer Science & Information Technology

In the HLOOKUP function, the third argument is the column index number

Indicate whether the statement is true or false

Computer Science & Information Technology

A printer app for iOS or Android must be obtained by visiting the printer vendor's website

Indicate whether the statement is true or false

Computer Science & Information Technology