Deadlock Detection and Resolution in a CODASYL Based Data Management System

Summary: CODASYL-based DMS cannot prevent deadlock; approaches rely on simple detection and minimal-page-change rollback, degrading throughput. Proposes a novel deadlock detection algorithm and a throughput-aware resolution method to maximize system throughput. (summarized by gpt-5-nano on Feb 09 2026)

Paper ID: 2094
Venue: SIGMOD
Year: 1976
Pagerank: 7.091712e-05
Overall Rank: 3,825 | 73.76%
DOI: 10.1145/509383.509392

Incoming Non-self Citations Over Time

Authors

1. Philip P. Macri (AT&T)

BibTeX Citation

@inproceedings{macri_sigmod76,
        title = {{Deadlock Detection and Resolution in a CODASYL Based Data Management System}},
        author = {Macri, Philip P.},
        series = {{SIGMOD} '76},
        booktitle = {Proceedings of the {ACM} {SIGMOD} International Conference on Management of Data},
        publisher = {Association for Computing Machinery},
        doi = {10.1145/509383.509392},
        url = {https://dl.acm.org/doi/10.1145/509383.509392},
        year = {1976}
}

Incoming Citations (Sorted by Pagerank)

Showing 2 of 2 citing papers.

Rank	Citing Paper	Year	Venue	Pagerank
1,682	Concurrency In Database Systems - A Simulation Study	1977	SIGMOD	0.00010021488
6,361	Contention-Aware Lock Scheduling for Transactional Databases	2018	VLDB	5.9009048e-05

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

Semantically Similar Papers

#	Overall Rank	Paper	Year	Venue
1	2,309	A Scalable Lock Manager for Multicores	2013	SIGMOD
2	10,942	HAWK: A Workload-driven Hierarchical Deadlock Detection Approach in Distributed Database System	2025	VLDB
3	7,253	Compatibility And Commutativity In Non-Two-Phase Locking Protocols	1982	PODS
4	6,245	An Efficient Deadlock Removal Scheme for Non-Two-Phase Locking Protocols	1982	VLDB
5	1,682	Concurrency In Database Systems - A Simulation Study	1977	SIGMOD
6	14,502	A Framework for Understanding Distributed (Deadlock Detection) Algorithms	1983	PODS
7	14,438	Deadlock Resolution and Semantic Lock Models in Object-Oriented Distributed Systems	1988	SIGMOD
8	4,397	Deadlock Removal Using Partial Rollback in Database Systems	1981	SIGMOD
9	13,210	DEADLOCK-FREEDOM (AND SAFETY) OF TRANSACTIONS IN A DISTRIBUTED DATABASE (Extended Abstract)	1985	PODS
10	14,563	A Practical Deadlock Avoidance Algorithm for Data Base Systems	1977	SIGMOD