Prove that with a two-phase locking protocol, one possible equivalent serial order is the order in which the transactions perform their first unlock operation.

What will be an ideal response?


If two transactions do not acquire conflicting locks in some schedule S, all their
operations commute and they can be ordered arbitrarily in an equivalent serial schedule. Suppose they acquire conflicting locks on item x, and T1 accesses x before T2. Then
T1’s first unlock in S must precede T2’s lock on x, which must precede T2’s first
unlock. If they also acquire conflicting locks on y, their accesses to y must be in the
same order as their accesses to x since otherwise we could conclude that T2’s first
unlock in S must precede T1’s first unlock – a contradiction. Hence, all conflicting
operations in T1 and T2 are ordered in the same way as their first unlock events and
the two transactions can be serialized in that order.

Computer Science & Information Technology

You might also like to view...

Which of the following is true?

a. An @RequestScoped bean can be access by all of an app's pages during a session. b. Sessions never expire. c. An @SessionScoped is created when a session begins and exists throughout the entire session. d. None of the above.

Computer Science & Information Technology

When a video is inserted on a slide, it displays in the middle of the slide

Indicate whether the statement is true or false

Computer Science & Information Technology

If the external drive is connected to a PC with Windows 7 installed and BitLocker To Go is running, disconnecting the drive from the computer ________

a. Causes data on the drive to become corrupt b. Causes the computer to shut down c. May encrypt that external drive d. None of the above

Computer Science & Information Technology

The ____________________ layer of the TCP/IP model uses segments and datagrams as its Protocol Data Units.

Fill in the blank(s) with the appropriate word(s).

Computer Science & Information Technology