Hierarchical Deadlock Detection in Nested Transactions: A Depth-First Search Optimization Framework
Keywords:
Cycle Detection, Deadlock Detection, Deadlock Resolution, Depth-First Search (DFS), Directed Graph Modelling, Hierarchical Deadlock Scenarios, Nested Transactions, Transaction Relationships.Abstract
Deadlock detection in nested transactions is crucial for maintaining system stability and ensuring efficient transaction processing. In nested transaction systems, deadlocks can occur not only between top-level transactions but also among subtransactions, resulting in intricate cycles that complicate resolution. Traditional methods, which often involve examining the entire Wait-For Graph (WFG) for cycles, tend to be resource-intensive and time-consuming. As the complexity of transactions increases, there is a growing need for efficient deadlock detection techniques to optimize resource utilization and enhance overall system performance. This research focuses on developing an efficient Depth-First Search (DFS)-based algorithm to address hierarchical deadlocks that arise from subtransaction dependencies. By modelling transaction relationships as a directed graph, where nodes represent transactions and edges denote dependencies, the proposed approach iteratively applies the DFS algorithm to identify cycles indicative of potential deadlocks. The algorithm not only detects deadlocks but also provides detailed insights into the involved transactions, the deadlock cycle, and indirect dependencies. Key performance metrics, such as execution time, memory usage, system throughput, response time, and success ratio, were computed during the detection process. Implemented and validated in a MATLAB simulation environment, the algorithm demonstrated significant improvements in deadlock detection efficiency within nested transactional systems. Results showed its effectiveness in identifying hierarchical deadlocks, with favourable performance in execution time, memory usage, and overall throughput, even in scenarios of varying transaction complexity. This research highlights the importance of efficient deadlock detection techniques in optimizing resource utilization and advancing concurrent system performance. The proposed DFS-based algorithm offers a robust solution for managing hierarchical deadlocks and lays the groundwork for future development of resilient and dependable transaction management systems.
Downloads
References
P. A. Bernstein VHaNG. Concurrency Control and Recovery in Database Systems: Addison Wesley; 1987.
Ceri S PG. Distributed Database Principles and Systems: New York: McGraw-Hill; 1984.
Chandy M MJHL. Distributed deadlock detection. ACM Trans Comput Syst.. 1983; 1(2): 144-56.
RC H. Some Deadlock Properties in Computer Systems. ACM Comput Surveys. 1972; 4(3): 179-96.
Gray J RA. Transaction Processing: Concepts and Techniques San Mateo: : Morgan Kaufmann Publ; 1993.
Moss JEB. Nested Transactions: An Approach to Reliable Distributed Computing. Cambridge, MA:; April 1981.
Bjork LA. Recovery scenario for a DB/DC system. In ACM Annual Conference; 1973. p. 142–6.
Davies CT. Recovery semantics for a DB/DC system. In ACM Annual Conference; 1973. p. 136–41.
Salem HGMaK. Sagas. In ACM SIGMOD International Conference on Management of Data; 1987. p. 249–259.
Karabatis G. Nested Transaction Models. In Liu L. ÖM, editor. Encyclopedia of Database Systems; 2017; New York: Springer.
Medjahed MOAKE. Generalization of ACID Properties. In Liu L. ÖMT, editor. Encyclopedia of Database Systems; 2009; Boston, MA: Springer.
Buchmann A. Open Nested Transaction Models. In Liu L. ÖM, editor. Encyclopedia of Database Systems; 2016; New York: Springer.
A. EI-Sayed HSHaMEES. Effect of shaping characteristics on the performance of nested transactions. Information and Software Technology. 2001; 43(10): 579-590.
Rothermel THaK. Concurrency Control Issue in Nested Transactions. VLDB J. 1993; 2(1): 39-74.
M R. Hierarchical Deadlock Detection for Nested Transactions. Distrib Comput.. 1991; 4(3): 123-129.
Sinha MK NM. A Priority Based Distributed Deadlock Detection Algorithm. IEEE Trans Softw Eng.. 1985; 11(1): 67-80.
Rukoz M. A distributed solution for detecting deadlock in distributed nested transaction systems Bermond J,RM, editor. Berlin, Heidelberg: In Distributed Algorithms,Lecture Notes in Computer Science,Springer; 1989.
Dong C. Shin SCM. A deadlock detection algorithm for nested transaction model. Microprocessing and Microprogramming. 1990; 28(1): 9-14.
Rezende F&HT&GA&LJ. Detection arcs for deadlock management in nested transactions and their performance; 2006.
Downloads
Published
How to Cite
Issue
Section
License

This work is licensed under a Creative Commons Attribution-ShareAlike 4.0 International License.
All papers should be submitted electronically. All submitted manuscripts must be original work that is not under submission at another journal or under consideration for publication in another form, such as a monograph or chapter of a book. Authors of submitted papers are obligated not to submit their paper for publication elsewhere until an editorial decision is rendered on their submission. Further, authors of accepted papers are prohibited from publishing the results in other publications that appear before the paper is published in the Journal unless they receive approval for doing so from the Editor-In-Chief.
IJISAE open access articles are licensed under a Creative Commons Attribution-ShareAlike 4.0 International License. This license lets the audience to give appropriate credit, provide a link to the license, and indicate if changes were made and if they remix, transform, or build upon the material, they must distribute contributions under the same license as the original.