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.
YouTube Encyclopedic
-
1/3Views:54 99655 22981 828
-
MySQL: AUTOCOMMIT, COMMIT, ROLLBACK
-
Distributed Systems 7.1: Two-phase commit
-
two phase commit protocol | Distributed systems | Lec-61 | Bhanu Priya
Transcription
See also
References
- ^ "What is ACID (atomicity, consistency, isolation, and durability)? - Definition from WhatIs.com". SearchDataManagement. Retrieved 2022-09-27.
| Types | |
|---|---|
| Concepts | |
| Objects | |
| Components | |
| Functions | |
| Related topics | |
 | This computer science article is a stub. You can help Wikipedia by expanding it. |
This page was last edited on 12 April 2024, at 05:45