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 Applied science, practical discipli ...
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 and providing ''Durability'' to
ACID transactions
In computer science, ACID ( atomicity, consistency, isolation, durability) is a set of properties of database transactions intended to guarantee data validity despite errors, power failures, and other mishaps. In the context of databases, a sequ ...
. 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 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 ...
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)
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
Data management
SQL
Transaction processing
{{comp-sci-stub