Commit (data management)

Short description: Making a set of tentative changes to a database permanent

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.[1]

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.

## References

1. ↑ "What is ACID (atomicity, consistency, isolation, and durability)? - Definition from WhatIs.com" (in en). https://www.techtarget.com/searchdatamanagement/definition/ACID.

## See also

* Atomic commit
* Two-phase commit protocol
* Three-phase commit protocol

* v
* t
* e

Database management systems

Types|

* Object-oriented
* comparison
* Relational
* comparison
* Document-oriented
* Graph
* NoSQL
* NewSQL

Concepts|

* Database
* ACID
* Armstrong's axioms
* CAP theorem
* CRUD
* Null
* Candidate key
* Foreign key
* Superkey
* Surrogate key
* Unique key

Objects|

* Relation
* table
* column
* row
* View
* Transaction
* Transaction log
* Trigger
* Index
* Stored procedure
* Cursor
* Partition

Components|

* Concurrency control
* Data dictionary
* JDBC
* XQJ
* ODBC
* Query language
* Query optimizer
* Query rewriting system
* Query plan

Functions|

* Administration
* Query optimization
* Replication

Related topics|

* Database models
* Database normalization
* Database storage
* Distributed database
* Federated database system
* Referential integrity
* Relational algebra
* Relational calculus
* Relational database
* Relational model
* Object-relational database
* Transaction processing

0.00

(0 votes)

Original source: https://en.wikipedia.org/wiki/Commit (data management). Read more

|

Retrieved from "https://handwiki.org/wiki/index.php?title=Commit_(data_management)&oldid=40871"
*[v]: View this template
*[t]: Discuss this template
*[e]: Edit this template