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

Access, I have to solve a problem using access

I have to solve a problem using access

Example of alter table command, Example - ALTER TABLE emp MODIFY (empno NUM...

Example - ALTER TABLE emp MODIFY (empno NUMBER (7));

Views-data control, Views A view is like a window by which data from ta...

Views A view is like a window by which data from tables can be changed or viewed. The table on which a view is based is known as Base table. The view is stored as a SELECT stat

Explain the process-oriented decomposition, Breaking into Subsystems D...

Breaking into Subsystems Decomposition is a significant technique for coping with complexity based on idea of divide and conquers. In dividing a problem into sub problems, the

Compare the efficiency of the two mining processes, Consider the following ...

Consider the following database containing five transactions. Let min_sup = 60%. Mine all frequent itemsets using Apriori and FP-growth algorithm. Compare the efficiency of the t

What is called as an n-way merge, What is called as an N-way merge? The...

What is called as an N-way merge? The merge operation is a generalization of the two-way merge used by the standard in-memory sort-merge algorithm. It merges N runs, so it is k

What is the full form of ddl, What is the full form of DDL? DDL is stan...

What is the full form of DDL? DDL is stand for Data Definition Language.

Differentiate oo development from structured development., Differentiate OO...

Differentiate OO development from structured development. Structured approach of problem solving is based upon the idea of decomposition of system into subsystem. In this appro

Shared lock or read lock, Shared lock or Read Lock It is requested ...

Shared lock or Read Lock It is requested by a transaction that needs to just read the value of data item. A shared lock on a data item does not permit an exclusive lock

gaps in sequence values can happen when-sequences, Gaps in sequence values...

Gaps in sequence values can happen when: - A rollback happens that is when a statement changes are not accepted. - When the system crashes - When a sequence i

Write Your Message!

Name

Email id

Message

Verfication Code

User Account

All Pages