About this document
Locking Methods in Concurrency Control by Ivan Hfos is a document available to read on EtoBox.
The document discusses various methods for concurrency control in databases using locking techniques. It describes lock granularity at different levels - database, table, page, row and field. Page-level locking is most commonly used. Lock types can be binary or shared/exclusive. Deadlocks are addressed through prevention, detection or avoidance. Other concurrency control methods discussed include time stamping and optimistic approaches. The two-phase commit protocol is described to guarantee consistency acr
- Author
- Ivan Hfos
- Language
- EN