ComputingComputer ScienceData ManagementDatabasesDistributed SystemsConcurrency ControlDatabase ManagementTransaction ManagementDatabase LockingDatabase Management SystemsDatabase TransactionsLockingOptimistic LockingPessimistic Concurrency Control
The traditional approach to concurrency control is based on locking. Recently, new methods have been presented called optimistic methods. These methods are well suited in situations where the likelihood of conflicting actions is rather small. Otherwise locking should be used. Typically in database systems it is not known in advance what kind of transactions are to be processed. Therefore what is really needed are methods which combine the benefits of optimistic methods and locking. This paper is a first step in this direction.
6
The notions of consistency and predicate locks in a database system
Kapali P. Eswaran, Jim Gray, Raymond A. Lorie et al. · Communications of the ACM · 1976 · 2K citations · Full text
Concurrency control for database systems
Richard E. Stearns, Philip Lewis, Daniel J. Rosenkrantz · 1976 · 106 citations
Process synchronization in database systems
Günter Schlageter · ACM Transactions on Database Systems · 1978 · 32 citations · Full text