Transaction States: Active, Partially Committed, Committed, Failed, Aborted, Assignments of Database Management Systems (DBMS)

The different transaction states in a database system, including the active state, partially committed state, committed state, failed state, aborted state, and terminated state. The failed state occurs when a transaction cannot continue due to a failure, requiring it to be undone and enter the aborted state. The terminated state marks the end of a transaction's life cycle.

Typology: Assignments

2019/2020

Uploaded on 06/05/2020

ayesha-akhtar-531
ayesha-akhtar-531 🇵🇰

1 document

1 / 1

Toggle sidebar

This page cannot be seen from the preview

Don't miss anything!

bg1
DIFFERENT TRANSACTION STATES ARE:
Transaction states are- Active state, Partially committed state, Committed state, Failed state,
Aborted state, Terminated state.
1. Failed State:
When a transaction is getting executed in the active state or partially committed state
and some failure occurs due to which it becomes impossible to continue the execution, it
enters into a failed state.
2. Aborted State:
After the transaction has failed and entered into a failed state, all the changes made
by it have to be undone.
To undo the changes made by the transaction, it becomes necessary to roll back the
transaction.
After the transaction has rolled back completely, it enters into an aborted state.
3. Terminated State:
This is the last state in the life cycle of a transaction.
After entering the committed state or aborted state, the transaction finally enters into a
terminated state where its life cycle finally comes to an end.

Partial preview of the text

Download Transaction States: Active, Partially Committed, Committed, Failed, Aborted and more Assignments Database Management Systems (DBMS) in PDF only on Docsity!

DIFFERENT TRANSACTION STATES ARE:

Transaction states are- Active state, Partially committed state, Committed state, Failed state, Aborted state, Terminated state.

1. Failed State: When a transaction is getting executed in the active state or partially committed state and some failure occurs due to which it becomes impossible to continue the execution, it enters into a failed state. 2. Aborted State: After the transaction has failed and entered into a failed state, all the changes made by it have to be undone. To undo the changes made by the transaction, it becomes necessary to roll back the transaction. After the transaction has rolled back completely, it enters into an aborted state. 3. Terminated State : This is the last state in the life cycle of a transaction. After entering the committed state or aborted state, the transaction finally enters into a terminated state where its life cycle finally comes to an end.