Transaction States in DBMS

Transaction States in DBMS

Transaction States in  transaction processing in a Database System.

 

The following are the different states in  transaction processing in a Database System.

  • Active
  • Partially Committed
  • Failed
  • Aborted
  • Committed

Active
This is the  initial state. The transaction stay in this state while it is executing.

Partially Committed
This is the  state after the final statement of the transaction is executed.

Failed
After the discovery that normal execution can no longer proceed.

Aborted
The state after the transaction has been rolled back and the database has been restored to its state prior to the start of the transaction.

Committed
The state after successful completion of the transaction.

We cannot abort or rollback a committed transaction.