Chapter 18, Problem 10PE

Explanation of Solution

Practical applications of two-phase locking protocol

• Two-phase locking protocol is used for simple applications where a single granularity is accepted...

Explanation of Solution

Practical applications of two-phase locking with multiple granularity locking protocol

• It is used for applications where some applications access individual records and others access whole relations or substantial parts...

Explanation of Solution

Practical applications of tree protocol

• It is used for all applications that tend to access data items in an order consistent with a particular partial order...

Explanation of Solution

Practical applications of timestamp ordering protocol

• It is used if the application demands a concurrent execution that is equivalent to a particular serial ordering.
• Conflicts are handled by roll-back of transactions rather than waiting and schedules are also not recoverable...

Explanation of Solution

Practical applications of validation protocol

• If the probability of two conflict of two concurrently executing transaction is low, then this protocol can be used...

Explanation of Solution

Practical applications of multiversion timestamp ordering protocol

• It is used it timestamp ordering is appropriate...

Explanation of Solution

Practical applications of multiversion multiversion two phase locking protocol

• It allows read-only transactions to always commit without waiting.
• Update transactions follow two phase locking protocol and allows recoverable schedules with conflicts solved by waiting rather than roll-back...