1976
DOI: 10.1145/360363.360369
|View full text |Cite
|
Sign up to set email alerts
|

The notions of consistency and predicate locks in a database system

Abstract: In database systems, users access shared data under the assumption that the data satisfies certain consistency constraints. This paper defines the concepts of transaction, consistency and schedule and shows that consistency requires that a transaction eannot request new locks after releasing a lock. Then it is argued that a transaction needs to lock a logical rather than a physical subset of the database. These subsets may be specified by predicates. An implementation of predicate locks which satisfies the con… Show more

Help me understand this report

Search citation statements

Order By: Relevance

Paper Sections

Select...
2
1
1
1

Citation Types

0
146
0
6

Year Published

1999
1999
2016
2016

Publication Types

Select...
5
4

Relationship

0
9

Authors

Journals

citations
Cited by 1,544 publications
(152 citation statements)
references
References 3 publications
0
146
0
6
Order By: Relevance
“…Finally the original paper on two-phase locking made explicit the idea of locking not just objects, but program predicates [10]. Logical locks are such predicates, which we realize in practice by mapping logical locks onto physical locks using a lock placement.…”
Section: Discussion and Related Workmentioning
confidence: 99%
“…Finally the original paper on two-phase locking made explicit the idea of locking not just objects, but program predicates [10]. Logical locks are such predicates, which we realize in practice by mapping logical locks onto physical locks using a lock placement.…”
Section: Discussion and Related Workmentioning
confidence: 99%
“…Some fellow schedulers also use the same notions as Omega. The purpose of using OCC in shared-state scheduling is to maintain integrity of cell state and serial equivalence [10,11] of concurrent schedule transactions. Since Kung and Robinson firstly proposed Optimistic concurrency control in 1981 [12].…”
Section: Background and Motivationmentioning
confidence: 99%
“…Coarse-grained conflict detection is similar to backward validation and more suitable for users who have stricter requirement about serial equivalence [10,11]. Finegrained conflict detection is a completed relaxed method which has no concurrency control mechanism.…”
Section: Background and Motivationmentioning
confidence: 99%
“…The Two phase locking protocol [17] consists of two consecutive phases for handling transaction locks:…”
Section: Two-phase Lockingmentioning
confidence: 99%