Menu
Home Explore People Places Arts History Plants & Animals Science Life & Culture Technology
On this page
Commit (data management)
SQL statement that executes a database commit

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 as in Atomicity, Consistency, Isolation, and Durability (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 COMMIT 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 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 savepoints that may be in use.

We don't have any images related to Commit (data management) yet.
We don't have any YouTube videos related to Commit (data management) yet.
We don't have any PDF documents related to Commit (data management) yet.
We don't have any Books related to Commit (data management) yet.
We don't have any archived web articles related to Commit (data management) yet.

See also

References

  1. "What is ACID (atomicity, consistency, isolation, and durability)? - Definition from WhatIs.com". SearchDataManagement. Retrieved 2022-09-27. https://www.techtarget.com/searchdatamanagement/definition/ACID