| 1 |
Transaction - a logical unit of work that comprises one or more SQL statements executed by a single user
|
| 2 |
A transaction begins with the user's first executable SQL statement
|
| 3 |
A transaction ends when it is explicitly committed or rolled back
|
| 4 |
Transactions provide the database user or application developer with the capability of guaranteeing consistent changes to data, as long as the SQL statements within a transaction are grouped logically
|
| 5 |
A transaction should consist of all of the necessary parts for one logical unit of work - no more and no less
|
| 6 |
Data in all referenced tables are in a consistent state before the transaction begins and after it ends.
|
| 7 |
Transactions should consist of only the SQL statements that comprise one consistent change to the data
|
