Hierarchical Deadlock Detection in Nested Transactions: A Depth-First Search Optimization Framework

Authors

  • Meenu

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

Download data is not yet available.

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

12.06.2024

How to Cite

Meenu. (2024). Hierarchical Deadlock Detection in Nested Transactions: A Depth-First Search Optimization Framework. International Journal of Intelligent Systems and Applications in Engineering, 12(4), 5243–5259. Retrieved from https://www.ijisae.org/index.php/IJISAE/article/view/7318

Issue

Section

Research Article