Subscribe:

Pages

Tuesday, 11 February 2014

Transaction and their properties | Transaction management

WHAT IS TRANSACTION?

A Transaction is a set of changes that must all be made together.It is a collection of Operations that form a single logical unit of work.It must be either completed or entirely apported to ensure the consistency and integrity of database.For Example - A transfer of money from one bank account to another requires two changes to the database both must succeed or fail together.  Consider the example - You are working on a system for a bank.

States of transaction |Transaction Management

STATES OF TRANSACTION

A transaction must be in one of the following states.
1.Active-The initial state,the transaction stays in this state while it is executing.
2.Partially committed- After the final statement has been executed.
3.Failed-when the normal execution can no longer proceed.