A Study of the Effects of Locking Granularity in a Data Base Management System
Summary: Using a simulation model, the study analyzes how lock granularity affects DBMS integrity and concurrency. Contrary to intuition, results favor surprisingly coarse granularity, casting doubt on predicate locking and impacting lock-manager design. (summarized by gpt-5-nano on Feb 09 2026)
Incoming Non-self Citations Over Time
Authors
Incoming Citations (Sorted by Pagerank)
Showing 5 of 5 citing papers.
| Rank | Citing Paper | Year | Venue | Pagerank |
|---|---|---|---|---|
| 828 | Queueing Network Models for Concurrent Transaction Processing in a Database System | 1979 | SIGMOD | 0.00016189544 |
| 1,739 | Precision Locks | 1981 | SIGMOD | 0.00010719584 |
| 2,088 | Empirical Comparison of Database Concurrency Control Schemes | 1983 | VLDB | 9.570953e-05 |
| 5,546 | A Fast General-Purpose Hardware Synchronization Mechanism | 1985 | SIGMOD | 5.4460661e-05 |
| 13,052 | An Experimental Comparison of Locking Policies in a Testbed Database System | 1983 | SIGMOD | 4.1945683e-05 |
Previous
Page 1 / 1
Next
Outgoing Citations (Sorted by Pagerank)
Showing 0 of 0 cited papers.
Citations counted here include only citations to other VLDB/SIGMOD/CIDR/PODS papers in this database.
| Rank | Cited Paper | Year | Venue | Pagerank |
|---|
Previous
Page 1 / 1
Next
Semantically Similar Papers
| Overall Rank | Paper | Year | Venue | Pagerank |
|---|---|---|---|---|
| 2,581 | On-the-Fly, Incremental, Consistent Reading of Entire Databases | 1985 | VLDB | 8.5019381e-05 |
| 3,351 | An Abstract Model of Database Concurrency Control Algorithms | 1983 | SIGMOD | 7.1873372e-05 |
| 3,591 | A Quantitative Comparison of Lock Protocols for Centralized Databases | 1983 | VLDB | 6.9418919e-05 |
| 3,060 | A Simple Analytic Model For Performance Of Exclusive Locking In Database Systems | 1983 | PODS | 7.6387559e-05 |
| 2,950 | The Performance Of Concurrency Control Algorithms For Database Management Systems | 1984 | VLDB | 7.8329866e-05 |
| 1,739 | Precision Locks | 1981 | SIGMOD | 0.00010719584 |
| 13,052 | An Experimental Comparison of Locking Policies in a Testbed Database System | 1983 | SIGMOD | 4.1945683e-05 |
| 606 | Concurrency In Database Systems - A Simulation Study | 1977 | SIGMOD | 0.00019328792 |
| 828 | Queueing Network Models for Concurrent Transaction Processing in a Database System | 1979 | SIGMOD | 0.00016189544 |
| 3,109 | Choice and Performance in Locking for Databases | 1984 | VLDB | 7.5489619e-05 |