Commit (data management)

In computer science and data management, a commit is the making of a set of tentative changes permanent, marking the end of a transaction and providing Durability to 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.

A  statement in SQL ends a transaction within a relational database management system (RDBMS) and makes all changes visible to other users. The general format is to issue a  (or , depending on the database vendor) statement, one or more SQL statements, and then the   statement. Alternatively, a  statement can be issued, which undoes all the work performed since   was issued. A  statement will also release any existing savepoints that may be in use.