Please enable JavaScript.
Coggle requires JavaScript to display documents.
Concurrency Control (Locking - procedure used to control concurrent access…
Concurrency Control
-
Timestamping
Transactions ordered globally so ones with smaller timestamps get priority in the event of a conflict
-
-
-
2PL Issues
Deadlock - an impasse that may result when two or more transactions are each waiting for locks held by the other to be released
Livelock - transaction is left in wait state indefinitely, unable to acquire any new locks. The DB itself is not in deadlock
Deadlock Prevention - the DBMS looks ahead to see if transaction would cause deadlock and prevents it