What is deadlock, Database Management System

What is deadlock? How can it be avoided? How can it be resolved once it occurs?

Deadlock happens when two transactions are each waiting on a resource that the other transaction holds. Deadlock can be stooped by requiring transactions to acquire all locks at the similar time; once it happens, the only way to cure it is to abort one of the transactions and back out of partially completed work.

 

Posted Date: 7/4/2013 9:08:47 AM | Location : United States







Related Discussions:- What is deadlock, Assignment Help, Ask Question on What is deadlock, Get Answer, Expert's Help, What is deadlock Discussions

Write discussion on What is deadlock
Your posts are moderated
Related Questions
how to submit answers softcopy

Deadlock Prevention One of the easiest approaches for avoiding a deadlock would be to obtain all the locks at the begin of the transaction. Though, this approach restricts conc

I am going to develop a web site to present decision tree structure. For this, I want a web application with AJAX technology to connect the database and prepare the decision tree's

Describe Application programming interface? Application Programming Interface - Commercial SQL implementations take one of the two primary techniques for involving SQL in a p


Why do so various organizations use MySQL? Advantages: Open source Highly efficient Offers a high scalability in terms of size and connectivity. Highly prote

Define an operator that a Relational Algebra does not have Ans: Relational Algebra does not have Aggregation operators.

Horizontal Fragmentation- Horizontal fragmentation groups together the tuples in a relation that are collectively used by the main transactions. A horizontal fragment is produced b

Define the concept of generalization A generalization is relationship between specific kind of thing and general thing. It is also known as "is-a-kind-of" relationship. Inher

Explain in detail about Collaboration Diagrams Collaboration diagrams are interaction diagrams which emphasize structural organisation of an object that transmit and receive m