I have read some notes about the two but yet still confused about why there is a need for the strict 2phase locking. Based on some slides,
Two Phase Locking and Strict Two Phase Locking
They have a single difference which is :
- If transaction T releases any lock, it can acquire no new locks. <- 2PL
- Hold all locks until end of transaction. <- S2PL
I will like a practical example of a Transaction in both strict and normal.Highlighting the differences.