Transaction goes on various steps before the complication.
See the below diagram we will get the clear idea.
Begin transaction
This indicates the beginning of a transaction
Active phase
In this phase the running of the database operations or write sql
queries for perform the tasks is done partially
committed
After
performs the needed operations the transaction indicates end state and come to
the phase partially committed and store in the buffer but not permanently.
Committed
If the
transaction was successfully executed it comes to the commit state and
indicates the database that the operation was success
Fail
If any failure occur during the transaction before
committed it comes to the fail state. The system failures can occur as
transaction, system and media failures.
Terminate
After successfully committed or the rollback after
the failures finally it indicate the transaction is over
No comments:
Post a Comment
If you have any doubt, please let me know.