In
computer science
Computer science is the study of computation, automation, and information. Computer science spans theoretical disciplines (such as algorithms, theory of computation, information theory, and automation) to practical disciplines (includin ...
and
data management
Data management comprises all disciplines related to handling data as a valuable resource.
Concept
The concept of data management arose in the 1980s as technology moved from sequential processing (first punched cards, then magnetic tape) to ...
, a commit is the making of a set of tentative changes permanent, marking the end of a
transaction
Transaction or transactional may refer to:
Commerce
* Financial transaction, an agreement, communication, or movement carried out between a buyer and a seller to exchange an asset for payment
*Debits and credits in a Double-entry bookkeeping sys ...
and providing ''Durability'' to
ACID transactions. A ''commit'' is an act of committing. The record of commits is called the commit log.
Data management
A
COMMIT statement in
SQL ends a
transaction
Transaction or transactional may refer to:
Commerce
* Financial transaction, an agreement, communication, or movement carried out between a buyer and a seller to exchange an asset for payment
*Debits and credits in a Double-entry bookkeeping sys ...
within a
relational database management system
A relational database is a (most commonly digital) database based on the relational model of data, as proposed by E. F. Codd in 1970. A system used to maintain relational databases is a relational database management system (RDBMS). Many relati ...
(RDBMS) and makes all changes visible to other users. The general format is to issue a
BEGIN WORK (or
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
savepoint
A savepoint is a way of implementing subtransactions (also known as nested transactions) within a relational database management system by indicating a point within a transaction that can be " rolled back to" without affecting any work done in t ...
s that may be in use.
In terms of transactions, the opposite of commit is to discard the tentative changes of a transaction, a
rollback.
See also
*
Commit (version control)
*
Atomic commit
*
Two-phase commit protocol
*
Three-phase commit protocol
Data management
SQL
Transaction processing
{{comp-sci-stub