DBMS Korth Edition 4 Exercise 16 Question 3 (Page No. 632)

Question

What benefit does strict two-phase locking provide ? What disadvantages result ?

Answer 1

STRICT 2pl has one more feature i.e STRICT RECOVERABILITY.

Answer 2

Strict two-phase locking is:

• easier to implement
• avoids cascading aborts because of which rollback overhead is low and recovery is easy

Disadvantages:

Under strict two-phase locking, a transaction may hold a lock throughout its execution. This life-time blocking may be too long for a high priority transaction to wait.

Relatively less concurrency.