Precision Locks

Summary: Precision locks (PL) lock required tuples for correctness, phantoms included, yielding peak concurrency. A framework reveals locking errors; PL supports arbitrary predicates, enforces 2-phase transactions, and is cheaper than conventional locking. (summarized by gpt-5-nano on Feb 09 2026)

Paper ID: 2214
Venue: SIGMOD
Year: 1981
Pagerank: 9.0500644e-05
Overall Rank: 2,166 | 85.15%
DOI: 10.1145/582318.582340

Incoming Non-self Citations Over Time

Authors

1. J. R. Jordan (Sperry Research Center)
2. J. Banerjee (Sperry Research Center)
3. R. B. Batman (Sperry Research Center)

BibTeX Citation

@inproceedings{jordan_sigmod81,
        title = {{Precision Locks}},
        author = {Jordan, J. R. and Banerjee, J. and Batman, R. B.},
        series = {{SIGMOD} '81},
        booktitle = {Proceedings of the {ACM} {SIGMOD} International Conference on Management of Data},
        publisher = {Association for Computing Machinery},
        doi = {10.1145/582318.582340},
        url = {https://dl.acm.org/doi/10.1145/582318.582340},
        year = {1981}
}

Incoming Citations (Sorted by Pagerank)

Showing 10 of 10 citing papers.

Rank	Citing Paper	Year	Venue	Pagerank
233	Fast Serializable Multi-Version Concurrency Control for Main-Memory Database Systems	2015	SIGMOD	0.00023815642
652	An Overview of The System Software of A Parallel Relational Database Machine GRACE	1986	VLDB	0.00015304915
4,718	Solving the Phantom Problem by Predicative Optimistic Concurrency Control	1983	VLDB	6.5468872e-05
5,154	Cooperative Update Exchange in the Youtopia System	2009	VLDB	6.3423714e-05
5,406	Ad Hoc Transactions in Web Applications: The Good, the Bad, and the Ugly	2022	SIGMOD	6.2289734e-05
6,099	Transaction Repair for Multi-Version Concurrency Control	2017	SIGMOD	5.9776969e-05
6,291	Adaptive Optimistic Concurrency Control for Heterogeneous Workloads	2019	VLDB	5.9252026e-05
7,737	Contest of XML Lock Protocols	2006	VLDB	5.5558475e-05
10,864	Oze: Decentralized Graph-based Concurrency Control for Long-running Update Transactions	2025	VLDB	5.093636e-05
10,976	TreeCat: Standalone Catalog Engine for Large Data Systems	2025	VLDB	5.093636e-05

Outgoing Citations (Sorted by Pagerank)

Showing 1 of 1 cited papers.

Citations counted here include only citations to other VLDB/SIGMOD/CIDR/PODS papers in this database.

Rank	Cited Paper	Year	Venue	Pagerank
1,471	A Study of the Effects of Locking Granularity in a Data Base Management System	1977	SIGMOD	0.00010671012

Semantically Similar Papers

#	Overall Rank	Paper	Year	Venue
1	6,751	An Almost-Serial Protocol for Transaction Execution in Main-Memory Database Systems	2002	VLDB
2	13,253	A Non-Two-Phase Locking Protocol for Concurrency Control in General Databases	1983	VLDB
3	13,251	An Experimental Comparison of Locking Policies in a Testbed Database System	1983	SIGMOD
4	4,829	Strong consistency is not hard to get: Two-Phase Locking and Two-Phase Commit on Thousands of Cores	2019	VLDB
5	1,420	Lightweight Locking for Main Memory Database Systems	2013	VLDB
6	4,718	Solving the Phantom Problem by Predicative Optimistic Concurrency Control	1983	VLDB
7	14,450	Safety Of Non-Well-Locked Transaction Systems	1986	PODS
8	2,911	The Performance of Concurrency Control Algorithms for Database Management Systems	1984	VLDB
9	1,501	Key Range Locking Strategies for Improved Concurrency	1993	VLDB
10	1,471	A Study of the Effects of Locking Granularity in a Data Base Management System	1977	SIGMOD