What is Transaction (Its ACID Property)

{\rtf1\ansi\ansicpg1252\deff0\deflang16393{\fonttbl{\f0\froman\fprq2\fcharset0 Times New Roman;}{\f1\fswiss\fprq2\fcharset0 Verdana;}{\f2\fnil\fcharset0 Calibri;}}
{\*\generator Msftedit 5.41.21.2509;}\viewkind4\uc1\pard\li1080\lang1033\f0\fs28 A transaction is a logical unit of work that compromises one or more SQL Statements executed by a single User. According to ANSI, a transaction begins with first executable statement and ends when it is explicitly committed or rolled back. A transaction is an atomic unit of work that either fails or succeeds. There is no such thing as a partial completion of a transaction. Since a transaction can be made up of many steps, each step in the transaction must succeed for the transaction to be successful. If any one part of the transaction fails, then the entire transaction fails. When a transaction fails, the system needs to return to the state that it was in before the transaction was started. This is known as rollback. When a transaction fails, then the changes that had been made are said to be "rolled back." In effect, this is acting similar to the way the Undo command works in most word processors. When you select undo, the change that you just may have made is reversed. The transaction processing system is responsible for carrying out this undo.\par
When a transaction processing system creates a transaction, it will ensure that the transaction will have certain characteristics.\f1\fs18 \f0\fs28 ACID is an acronym for atomicity, consistency, isolation, and durability.\par
An \b atomic transaction\b0 is either fully completed, or is not begun at all.\par
A transaction enforces \b consistency\b0 in the system state by ensuring that at the end of any transaction the system is in a valid state.\par
When a transaction runs in \b isolation\b0 , it appears to be the only action that the system is carrying out at one time.\par
A transaction is \b durable\b0 in that once it has been successfully completed, all of the changes it made to the system are permanent.\par
\pard\sa200\sl276\slmult1\lang9\f2\par
}