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

Assignment Help:

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.

Related Discussions:- What are costs to be considere when transaction is roll back

Maping constraits, #question.what is mapping constraints and types?.

#question.what is mapping constraints and types?.

Database design and documentation, A use case diagram giving a pictorial ov...

A use case diagram giving a pictorial overview of user requirements and brief use case descriptions. As the case study contains only an outline of a business scenario, you will als

Describe the types of inheritance, Describe the types of Inheritance ...

Describe the types of Inheritance 1. Single inheritance 2. Multiple inheritance 3. Hierarchical inheritance 4. Multilevel inheritance

Indexed (indexed sequential) file organisation, Indexed (Indexed Sequential...

Indexed (Indexed Sequential) File Organisation It organises the file like a big dictionary, i.e., records are kept in order of the key but an index is stored which also allows

Having clause-data manipulation language, Having clause This clause...

Having clause This clause is used for producing conditions on grouped information. Example: Find maximum salary and department number of those departments where maxim

#title using the invoice, using the invoice table shown below,write the rel...

using the invoice table shown below,write the relational schema,draw a dependencies,inclunding all partial and transitive dependencies.assume that the table does not contain repeat

Define shared locks, Define Shared locks? Ans: Shared lock: Throughout ...

Define Shared locks? Ans: Shared lock: Throughout concurrent execution of transactions, earlier than a transaction can access a data item, it has to obtain a lock on it. Now he

What do you mean by atomicity and aggregation, What do you mean by atomicit...

What do you mean by atomicity and aggregation? Atomicity : Either all actions are carried out or none are. Users should not have to worry about the effect of incomplete trans

Transactions and concurrency management, Transactions And Concurrency Manag...

Transactions And Concurrency Management Introduction One of the main benefits of storing data in an integrated repository or a database is to permit sharing of it betwee

Anomalies, define anomalies and different types of anomalies with example

define anomalies and different types of anomalies with example

Write Your Message!

Name

Email id

Message

Verfication Code

User Account

All Pages