| From: | Reid Thompson <reid(dot)thompson(at)ateb(dot)com> |
|---|---|
| To: | |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: 'Official' definition of ACID compliance? |
| Date: | 2006-01-06 15:44:14 |
| Message-ID: | 43BE904E.70108@ateb.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Russ Brown wrote:
> On Thu, 5 Jan 2006 15:11:49 -0500
> Jaime Casanova <systemguards(at)gmail(dot)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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | John McCawley | 2006-01-06 15:45:53 | Reordering columns in a table |
| Previous Message | Daniel Kunkel | 2006-01-06 15:40:55 | Re: Adding another primary key to a populated table |