Deadlock prevention, Database Management System

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 concurrency very much, also you may lock some of the items that are not updated by that transaction (the transaction may contain if conditions).Therefore, better prevention algorithm have been evolved to stop a deadlock having the basic logic: not to permit circular wait to occur. This approach rolls back some of the transactions instead of letting them wait.

 

Posted Date: 3/12/2013 3:05:17 AM | Location : United States







Related Discussions:- Deadlock prevention, Assignment Help, Ask Question on Deadlock prevention, Get Answer, Expert's Help, Deadlock prevention Discussions

Write discussion on Deadlock prevention
Your posts are moderated
Related Questions
explain concept of decomposition?

What is an E-R model? Draw an E-R Diagram for the company database with following Descriptions? The company is organized within departments. Each department has a unique name a

What is Relational calculus? Relational calculus is a Non- Procedural language.

This assignment concerns the Research database. The database ER model is shown above, where attributes are omitted for clarity. The relational model for the database is: Departm

Structure of Client Server Systems: In client/server architecture, clients show users who require services while servers give services. Both client and server are a combination of

Project Description: We have purchased facebook style chat software which we are using with our site. It is prepared in PHP but the rest of the site is developed asp.net. Iss

Consider the subsequent relations for a database which keeps track of business trips of salespersons in a sales office: SALESPERSON (SSN, Name, start_year, Dept_no) TRIP (SSN, Fr

Question: Data Mining is the process of extracting knowledge hidden from large volumes of raw data. (a) Using a suitable example, illustrate how Data Mining can be useful t

The need for three level architecture The aim of the three level architecture is to divide each user's view of the database from the way the database is physically shown.

Analyzing Association Traversal Till now, we have supposed that associations are bi-directional. But in the case of traversal, it is in only one direction in any application,