An Approach to Eliminate Transaction Blocking in Locking Protocols
Summary: Introduces “ordered sharing”, a lock relation that records relative operation order to avoid transaction blocking in 2PL and relax mutual exclusion after operations. Theory and simulation show it cuts RW/WR/WW blocking, boosts throughput, and reduces thrashing vs 2PL. (summarized by gpt-5-mini on Feb 09 2026)
Incoming Non-self Citations Over Time
No non-self incoming citations found for this paper in this database.
Authors
- 1. D. Agrawal (University of California Santa Barbara)
- 2. A. El Abbadi (University of California Santa Barbara)
- 3. R. Jeffers (University of California Santa Barbara)
BibTeX Citation
@inproceedings{agrawal_pods92,
address = {New York, NY, USA},
series = {{PODS} '92},
title = {{An Approach to Eliminate Transaction Blocking in Locking Protocols}},
url = {https://dl.acm.org/doi/10.1145/137097.137877},
doi = {10.1145/137097.137877},
booktitle = {Proceedings of the {ACM} {SIGMOD} Symposium on {Principles} of {Database} {Systems}},
publisher = {Association for Computing Machinery},
author = {Agrawal, D. and Abbadi, A. El and Jeffers, R.},
year = {1992}
}
Incoming Citations (Sorted by Pagerank)
Showing 1 of 1 citing papers.
| Rank | Citing Paper | Year | Venue | Pagerank |
|---|---|---|---|---|
| 8,469 | Reducing Recovery Constraints on Locking based Protocols | 1994 | PODS | 5.4184681e-05 |
Previous
Page 1 / 1
Next
Outgoing Citations (Sorted by Pagerank)
Showing 8 of 8 cited papers.
Citations counted here include only citations to other VLDB/SIGMOD/CIDR/PODS papers in this database.
| Rank | Cited Paper | Year | Venue | Pagerank |
|---|---|---|---|---|
| 260 | Models for Studying Concurrency Control Performance: Alternatives and Implications | 1985 | SIGMOD | 0.00023103999 |
| 405 | Distributed Database Concurrency Controls Using Before-Values | 1981 | SIGMOD | 0.00019061195 |
| 2,533 | Empirical Comparison of Database Concurrency Control Schemes | 1983 | VLDB | 8.4562631e-05 |
| 3,385 | Load Control for Locking: The 'Half-and-Half' Approach | 1990 | PODS | 7.4544138e-05 |
| 4,191 | Adaptive Load Control in Transaction Processing Systems | 1991 | VLDB | 6.8430181e-05 |
| 4,874 | A Quantitative Comparison of Lock Protocols for Centralized Databases | 1983 | VLDB | 6.4690211e-05 |
| 5,290 | Using Delayed Commitment in Locking Protocols for Real-Time Databases | 1992 | SIGMOD | 6.2802216e-05 |
| 5,696 | Locks with Constrained Sharing (Extended Abstract) | 1990 | PODS | 6.1174956e-05 |
Previous
Page 1 / 1
Next
Semantically Similar Papers
| # | Overall Rank | Paper | Year | Venue |
|---|---|---|---|---|
| 1 | 3,880 | Controlled Lock Violation | 2013 | SIGMOD |
| 2 | 4,874 | A Quantitative Comparison of Lock Protocols for Centralized Databases | 1983 | VLDB |
| 3 | 7,253 | Compatibility And Commutativity In Non-Two-Phase Locking Protocols | 1982 | PODS |
| 4 | 13,251 | An Experimental Comparison of Locking Policies in a Testbed Database System | 1983 | SIGMOD |
| 5 | 4,397 | Deadlock Removal Using Partial Rollback in Database Systems | 1981 | SIGMOD |
| 6 | 13,253 | A Non-Two-Phase Locking Protocol for Concurrency Control in General Databases | 1983 | VLDB |
| 7 | 6,751 | An Almost-Serial Protocol for Transaction Execution in Main-Memory Database Systems | 2002 | VLDB |
| 8 | 5,290 | Using Delayed Commitment in Locking Protocols for Real-Time Databases | 1992 | SIGMOD |
| 9 | 5,696 | Locks with Constrained Sharing (Extended Abstract) | 1990 | PODS |
| 10 | 14,016 | Process Locking: A Protocol based on Ordered Shared Locks for the Execution of Transactional Processes | 2001 | PODS |