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 |
|---|---|---|---|---|
| 824 | Queueing Network Models for Concurrent Transaction Processing in a Database System | 1979 | SIGMOD | 0.0001617801 |
| 1,734 | Precision Locks | 1981 | SIGMOD | 0.00010715681 |
| 2,091 | Empirical Comparison of Database Concurrency Control Schemes | 1983 | VLDB | 9.5645672e-05 |
| 5,550 | A Fast General-Purpose Hardware Synchronization Mechanism | 1985 | SIGMOD | 5.4424257e-05 |
| 13,063 | An Experimental Comparison of Locking Policies in a Testbed Database System | 1983 | SIGMOD | 4.1905499e-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,584 | On-the-Fly, Incremental, Consistent Reading of Entire Databases | 1985 | VLDB | 8.4954563e-05 |
| 3,354 | An Abstract Model of Database Concurrency Control Algorithms | 1983 | SIGMOD | 7.1812114e-05 |
| 3,593 | A Quantitative Comparison of Lock Protocols for Centralized Databases | 1983 | VLDB | 6.9359423e-05 |
| 3,064 | A Simple Analytic Model For Performance Of Exclusive Locking In Database Systems | 1983 | PODS | 7.6344252e-05 |
| 2,950 | The Performance Of Concurrency Control Algorithms For Database Management Systems | 1984 | VLDB | 7.8274188e-05 |
| 1,734 | Precision Locks | 1981 | SIGMOD | 0.00010715681 |
| 13,063 | An Experimental Comparison of Locking Policies in a Testbed Database System | 1983 | SIGMOD | 4.1905499e-05 |
| 605 | Concurrency In Database Systems - A Simulation Study | 1977 | SIGMOD | 0.000193138 |
| 3,112 | Choice and Performance in Locking for Databases | 1984 | VLDB | 7.5444888e-05 |
| 824 | Queueing Network Models for Concurrent Transaction Processing in a Database System | 1979 | SIGMOD | 0.0001617801 |