Re: 'Official' definition of ACID compliance? - Mailing list pgsql-general

From Reid Thompson
Subject Re: 'Official' definition of ACID compliance?
Date
Msg-id 43BE904E.70108@ateb.com
Whole thread Raw
In response to Re: 'Official' definition of ACID compliance?  (Russ Brown <pickscrape@gmail.com>)
List pgsql-general
Russ Brown wrote:
> On Thu, 5 Jan 2006 15:11:49 -0500
> Jaime Casanova <systemguards@gmail.com> wrote:

> Anyone know who came up with the term in the first place?
>
FWIW --- as defined by ORACLE  http://www.orafaq.com/glossary/faqglosa.htm

ACID
     The basic properties of a database transaction: Atomicity, Consistency, Isolation, and Durability. All Oracle
transactions 
comply with these properties.

         * 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.



pgsql-general by date:

Previous
From: Daniel Kunkel
Date:
Subject: Re: Adding another primary key to a populated table
Next
From: John McCawley
Date:
Subject: Reordering columns in a table