Commit (data management)
This article needs additional citations for verification. (May 2014) |
In
ACID transactions
. A commit is an act of committing. The record of commits is called the commit log.
In terms of transactions, the opposite of commit is to discard the tentative changes of a transaction, a rollback.
The transaction, commit and rollback concepts are key to the ACID property of databases.[1]
A BEGIN WORK (or that may be in use.
BEGIN TRANSACTION
, depending on the database vendor) statement, one or more SQL statements, and then the COMMIT
statement. Alternatively, a ROLLBACK
statement can be issued, which undoes all the work performed since BEGIN WORK
was issued. A COMMIT
statement will also release any existing savepoints
See also
References
- ^ "What is ACID (atomicity, consistency, isolation, and durability)? - Definition from WhatIs.com". SearchDataManagement. Retrieved 2022-09-27.