Transaction - Commit

> (Data|State) 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