Lock Downgrading: An Approach to Increase Inter-transaction Parallelism in Advanced Database Applications

Authors:
Angelo Brayner
Affiliations:
-
Venue:
DEXA '01 Proceedings of the 12th International Conference on Database and Expert Systems Applications
Year:
2001

Citing 9
Cited 0

Concurrency control and recovery in database systems

Concurrency control and recovery in database systems
Sagas

SIGMOD '87 Proceedings of the 1987 ACM SIGMOD international conference on Management of data
Altruistic locking

ACM Transactions on Database Systems (TODS)
ASSET: a system for supporting extended transactions

SIGMOD '94 Proceedings of the 1994 ACM SIGMOD international conference on Management of data
A critique of ANSI SQL isolation levels

SIGMOD '95 Proceedings of the 1995 ACM SIGMOD international conference on Management of data
Locks with constrained sharing (extended abstract)

PODS '90 Proceedings of the ninth ACM SIGACT-SIGMOD-SIGART symposium on Principles of database systems
Locking Primitives in a Database System

Journal of the ACM (JACM)
The notions of consistency and predicate locks in a database system

Communications of the ACM
Concurrency control issues in nested transactions

The VLDB Journal — The International Journal on Very Large Data Bases

Quantified Score

Hi-index	0.00

Visualization

Abstract

In this paper, we propose a concurrency control protocol, denoted Cooperative Locking, which extends the two-phase locking protocol by introducing the notion of downgrading of locks proposed in [9]. The basic idea of the proposed protocol is to provide the following functionality: after using an object in a transaction, the user can downgrade a lock on an object to a less restrictive mode before the transaction ends its execution. The prime goal of our proposal is to provide a high degree of inter-transaction parallelism while ensuring serializability of schedules.