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.
- Partially Committed
This is the initial state. The transaction stay in this state while it is executing.
This is the state after the final statement of the transaction is executed.
After the discovery that normal execution can no longer proceed.
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.
The state after successful completion of the transaction.
We cannot abort or rollback a committed transaction.