What are costs to be considere when transaction is roll back, Database Management System

What are the costs to be considered when a transaction has to be rolled back when recovering from deadlock?       

 Ans: A few transaction will must rolled back (made a victim) to break deadlock.

Choose that transaction as victim which will incur minimum cost. 

  • Rollback - find out how far to roll back transaction.
  • Total rollback: Abort the transaction and after that restart it.
  • More efficient to roll back transaction only as far as essential to break deadlock.
  • Starvation occurs if same transaction is always selected as victim. Include the number of rollbacks in the cost factor to prevent starvation.

 

Posted Date: 5/4/2013 5:14:02 AM | Location : United States







Related Discussions:- What are costs to be considere when transaction is roll back, Assignment Help, Ask Question on What are costs to be considere when transaction is roll back, Get Answer, Expert's Help, What are costs to be considere when transaction is roll back Discussions

Write discussion on What are costs to be considere when transaction is roll back
Your posts are moderated
Related Questions
Project Description: I am having a random problem with my Wordpress site. If I click on "Publish" and "Add new", it takes me to a 404 page not found of /wp-admin/post.php (th

what characterizes the levels in RAID technology

Most computer systems authenticate users by asking them for the user name and password. However, the user names and passwords often can be guessed by hackers. Suggest an automated,

client server architeutre

How many types of users works on database? Users are differentiated through the way they expect to interact along with the system (i) Application programmers-interact with

Compare wait-die deadlock prevention scheme with wait-wound scheme   Ans:  Wait-Die Scheme  a) Based upon a nonpreemptive technique.  b) If Pi requests a resource present

Which component is not included in database environment ? A users component is not included in database environment.

Consider the subsequent relation schemes:  Project (Project#, Project_name, chief_architect)  Employee (Emp#, Empname)  Assigned_To (Project#, Emp#)  Give expression i


Redo Logs: Any database must have minimum two redo logs. These are the rules for the database; the redo logs record all modifies to the system objects or user objects. If any type