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

Transaction, what are the states of transaction?

what are the states of transaction?

What is multilevel index, Multilevel Index The Multilevel Index is a m...

Multilevel Index The Multilevel Index is a modification of the secondary level index system. In this system we might be use even more number of levels in case the table is eve

Erd, Table_Name( attribute_1, attribute_2, attribute_3, ….. ,attribute_x) ...

Table_Name( attribute_1, attribute_2, attribute_3, ….. ,attribute_x) Primary Key ( attribute_1, attribute_2) Foreign Key attribute_4 References Table_Name_2 (repeat for each fore

Locks, Locks: Serialisabilty is just a test whether a given interleaved sch...

Locks: Serialisabilty is just a test whether a given interleaved schedule is ok or has a concurrency related trouble. Though, it does not make sure that the interleaved concurrent

Determine the two special events, What are two special events? The two ...

What are two special events? The two special events are as "entry" and "exit". Any action which is marked as linked to entry event is executed whenever given state is entered v

Explain the term- query, Explain the term- Query. Queries are used to re...

Explain the term- Query. Queries are used to repossess and show specific records in a table. They can also be used to show specific fields of specific records, which meet the co

What is e-r model, What is E-R model? This data model is based on real ...

What is E-R model? This data model is based on real world that having of basic objects called entities and of relationship between these objects. Entities are explained in a da

Data base model, why are older data base model are being replaced by new da...

why are older data base model are being replaced by new data model

What are the dbms languages, What are the DBMS languages? Briefly explain?...

What are the DBMS languages? Briefly explain? Data Definition language (DDL):A database schema is specified through a set of definitions expressed through a special language

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd