Transaction - Commit

> (Data|State|Operand) Management and Processing > Data Properties and Transactions

1 - About

A commit preserve the changes by creating a new version of the data.

See also: Two-phase_commit_protocol

A commit occurs by appending a special record into the WAL.

A commit request that the changes in the transaction be made permanent.

Changes made by the transaction are permanent and visible to other users only after a transaction commits.

Changes mad prior to any commit event are in a sort of staging area.

A commit ends the current transaction and makes permanent all changes performed in the transaction.

Advertising

3 - List

4 - Type

4.1 - Two-phase

Two-phase commit in a distributed environment.