O'Reilly logo

Database Systems: Concepts, Design and Applications by S. K. Singh

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

12.4. Locking Methods for Concurrency Control

A lock is a variable associated with a data item that describes the status of the item with respect to possible operations that can be applied to it. It prevents access to a database record by a second transaction until the first transaction has completed all of its actions. Generally, there is one lock for each data item in the database. Locks are used as means of synchronising the access by concurrent transactions to the database items. Thus, locking schemes aim to allow the concurrent execution of compatible operations. In other words, permutable actions are compatible. Locking is the most widely used form of concurrency control and is the method of choice for most applications. Locks are granted ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required