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
Define the phases of two phase locking protocol Growing phase: a transaction may get locks but not release any lock. Shrinking phase: a transaction might be release locks bu

Limitations of File Based System The file-based system has some limitations. The limitations are listed as follows: Isolation and separation of data: When the data is

The PROJECT operation The project operation is used to choose the records with specified attributes as discarding the others based on some related criteria. This is denotes as ∏

Attributes attached to an entity can be of various types. Simple The attribute that cannot be further separated into smaller parts and shows the basic meaning is known as a

A Data Model in software engineering is an abstract model that organizes and documents the business data for interaction between team members and is used as a plan for creating

SELECT Statement This statement is used for retrieving information from the databases. It can be coupled with many clauses. Let us talk about these clauses in more detail:

Instructions: Follow the instructions below for completing this project: 1. Creating the Database: · Use the physical table descriptions given below to define and create each t

Describe association design of an object by giving one suitable example of it. The Design of Associations Associations are "glue" of advanced object oriented analysis and

What are the two types of serializability? The two types of serializability is a)      Conflict serializability b)      View serializability

Before we talk about the relational model in more detail, let us first define some very basic terms used in this model. Tuple Every row in a table shows a record and is cal