Learning about Serializability Theory
(siemens.blog)
I’ve been reading Concurrency Control and Recovery in Database Systems as part of Phil Eaton’s software internals book club. I’m currently working my way through the third chapter on two phase locking (2PL). I’ve had some light exposure to transaction serializability and 2PL in the past. I even wrote a toy transaction scheduler complete with strict 2PL and deadlock detection using a wait-die algorithm for victim selection.
I’ve been reading Concurrency Control and Recovery in Database Systems as part of Phil Eaton’s software internals book club. I’m currently working my way through the third chapter on two phase locking (2PL). I’ve had some light exposure to transaction serializability and 2PL in the past. I even wrote a toy transaction scheduler complete with strict 2PL and deadlock detection using a wait-die algorithm for victim selection.