Basic properties of any databse transaction should be Atomicity, Consistency, Isolation, and Durability.
In short referred to as ACID.
All Oracle database transactions are ACID complaint . However, I believe that Oracle's Berkeley DB database is not ACID-compliant.
I need to research more on this statement though.
In short ACID refers to:
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.
Thursday, June 23, 2011
Subscribe to:
Posts (Atom)
Canada’s Changing Technology Landscape
Technology is changing quickly in Canada and becoming a bigger part of our everyday lives. AI, cloud technology, automation and cybersecur...
-
This command was introduced in Oracle10g and is very efficient. The command will clean up all datafiles, online redo log files, controlfile...
-
The title "Evolving Architect: Combining Data, Design, and Project Management" captures my journey as I grow from data-centric e...
-
Zero Trust Packet Routing is an advanced cybersecurity concept that applies the Zero Trust framework to network traffic. Unlike traditional...