Concepedia

Predicate Locking

Predicate Locking is a concurrency control mechanism that belongs to the class of locking protocols, differing from conventional key-based locking by allowing transactions to lock sets of data items satisfying a specified predicate, thereby preventing phantom reads and ensuring serializability in relational database systems.

11

Publications

2.6K

Citations

21

Authors

7

Institutions

Publications per year

2017–2026

0

Parents

Publications

11

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

, , +16

Processing conjunctive predicates and queries

Daniel J. Rosenkrantz, Harry B. Hunt · Very Large Data Bases · 1980 · 119 citations

, , +16

Effects of locking granularity in a database management system

Daniel R. Ries, Michael Stonebraker · ACM Transactions on Database Systems · 1977 · 108 citations · Full text

, , +16

Key Range Locking Strategies for Improved Concurrency

David Lomet · 1993 · 90 citations

, , +14

High-Concurrency Locking in R-Trees

Marcel Kornacker, Douglas Banks · 1995 · 67 citations

, , +13

1–5 of 11

Authors

21

  1. MS
    Michael Stonebraker

    University of California, Berkeley, United States

    2 publications · 164 citations

    2

    h-index

  2. HB
    Harry B. Hunt

    University at Albany, State University of New York, United States

    2 publications · 145 citations

    2

    h-index

  3. SM
    Sharad Mehrotra

    University of California, Irvine, United States

    2 publications · 63 citations

    2

    h-index

  4. KC
    Kaushik Chakrabarti

    Microsoft (United States), United States

    2 publications · 63 citations

    2

    h-index

  5. DJ
    Daniel J. Rosenkrantz

    University at Albany, State University of New York, United States

    2 publications · 145 citations

    2

    h-index

1–5 of 21

Institutions

7

  1. University of Illinois Urbana-Champaign

    Urbana, United States

    2 h-index

    2 publications

    63 citations

  2. University of California, Irvine

    Irvine, United States

    2 h-index

    2 publications

    63 citations

  3. Minneapolis Business College

    Roseville, United States

    1 h-index

    3 publications

    162 citations

  4. Columbia University

    New York, United States

    1 h-index

    1 publications

    26 citations

  5. University at Albany, State University of New York

    Albany, United States

    1 h-index

    1 publications

    26 citations

  6. University of California, Berkeley

    Berkeley, United States

    1 h-index

    2 publications

    216 citations

  7. IBM (United States)

    Armonk, United States

    1 h-index

    4 publications

    7.8K citations

1–7 of 7

Venues

  1. ACM SIGMOD Record

    1 publications · 36 citations

    1

    h-index

  2. Very Large Data Bases

    Conference · 1 publications · 119 citations

    1

    h-index

  3. ACM Transactions on Database Systems

    TODS · 1 publications · 108 citations

    1

    h-index

  4. Communications of the ACM

    1 publications · 2K citations

    1

    h-index

  5. IFIP Congress

    Conference · 1 publications · 26 citations

    1

    h-index

1–5