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 syst ...
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 syst ...
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
In political science, rollback is the strategy of forcing a change in the major policies of a state, usually by replacing its ruling regime. It contrasts with containment, which means preventing the expansion of that state; and with détente, w ...
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
In political science, rollback is the strategy of forcing a change in the major policies of a state, usually by replacing its ruling regime. It contrasts with containment, which means preventing the expansion of that state; and with détente, w ...
.
See also
*
Commit (version control)
In version control systems, a commit is an operation which sends the latest changes of the source code to the repository, making these changes part of the head revision of the repository. Unlike commits in data management, commits in version co ...
*
Atomic commit
*
Two-phase commit protocol
In transaction processing, databases, and computer networking, the two-phase commit protocol (2PC) is a type of atomic commitment protocol (ACP). It is a distributed algorithm that coordinates all the processes that participate in a distributed ...
*
Three-phase commit protocol In computer networking and databases, the three-phase commit protocol (3PC) is a distributed algorithm which lets all nodes in a distributed system
A distributed system is a system whose components are located on different networked computers, ...
Data management
SQL
Transaction processing
{{comp-sci-stub