Abstract
The problem of distributed transactions deadlock is analyzed from a new point of view. Consequently we are able to obtain three results. The first is a sufficient condition for deadlock freedom of transactions. The second establishes how many syntactically identical transactions must be analyzed to determine their freedom from deadlock. The third extends the Havender scheme ([3]) for deadlock prevention (locking entities in a fixed order) to the distributed case.
Preview
Unable to display preview. Download preview PDF.
References
K.P. Eswaran, J.N. Gray, R.A. Lorie and I.L. Traiger, "The Notion of Consistency and Predicate Locks in a Database System", CACM, 19(11), pp. 624–633, (1976).
P.C. Kanellakis and C.H. Papadimitriou, "Is Distributed Locking Harder?", JCSS, (28), pp. 103–120, (1984).
J.W. Havender, "Avoiding Deadlock in Multitasking Systems", IBM Sys. J., 7(2), pp. 74–84, (1968).
J.N. Gray, "Notes on Database Operating Systems", in Operating Systems, an Advanced Course, Springer Verlag (1979).
J.D. Ullman, Principles of Database Systems, Computer Science Press, (1979).
D.A. Menasce and R.R. Munz, "Locking and Deadlock Detection in Distributed Databases", IEEE TOSE, 5(3), pp. 195–202, (1979).
O. Wolfson and M. Yannakakis, "Deadlock Freedom (and Safety) of Transactions in a Distributed Database", Proc. ACM Symp. on Principles of Database Systems, pp. 105–112, (1985).
M. Yannakakis, "Freedom from Deadlock of Safe Locking Policies", SIAM J. Comput., 11, pp. 391–408, (1982).
R. Obermack, "Distributed Deadlock Detection Algorithm", ACM TODS, 7(2), pp. 187–208, (1982).
T. Minoura, "Deadlock Avoidance Revisited", JACM, 29(4), pp. 1023–1048, (1982).
O. Wolfson, "Concurrent Execution of Syntactically Identical Transactions", Technion-IIT TR 387, November 1985.
Author information
Authors and Affiliations
Editor information
Rights and permissions
Copyright information
© 1986 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
Wolfson, O. (1986). A new characterization of distributed deadlock in databases. In: Ausiello, G., Atzeni, P. (eds) ICDT '86. ICDT 1986. Lecture Notes in Computer Science, vol 243. Springer, Berlin, Heidelberg. https://doi.org/10.1007/3-540-17187-8_52
Download citation
DOI: https://doi.org/10.1007/3-540-17187-8_52
Published:
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-540-17187-4
Online ISBN: 978-3-540-47346-6
eBook Packages: Springer Book Archive