Redirected from Transaction
In database products the ability to handle transactions allows the user to ensure that integrity of a database is maintained.
A single transaction might require several queries, each reading and/or writing information in the database. When this happens it is usually important to be sure that the database is not left with only some of the queries carried out. For example, when doing a money transfer, if the money was debited from one account, it is important that it also be credited to the depositing account. Also, transactions should not interfere with each other. For more information about desirable transaction properties, see ACID.
A simple transactions is usually issued to the database system in a language like SQL in this form:
If the transaction fails at any point (possibly before getting to the Commit phase), the database system will rollback any changes. All other transactions will behave the same way as if the transaction had never existed.
Transactions are supported in some form or other in database systems like Mimer SQL, PostgreSQL, MySQL and Oracle.
See also:
Search Encyclopedia
|
Featured Article
|