ACID

From Oracle FAQ
Jump to: navigation, search

ACID refers to the basic properties of a database transaction: Atomicity, Consistency, Isolation, and Durability.

All Oracle database, Oracle RDB and InnoDB transactions comply with these properties. However, Oracle's Berkeley DB database is not ACID-compliant.

Atomicity

The entire sequence of actions must be either completed or aborted. The transaction cannot be partially successful.

Consistency

The transaction takes the resources from one consistent state to another.

Isolation

A transaction's effect is not visible to other transactions until the transaction is committed.

Durability

Changes made by the committed transaction are permanent and must survive system failure.

Glossary of Terms
A B C D E F G H I J K L M N O P Q R S T U V W X Y Z #