ACID Transactions

When most database programmers refer to a transaction, they are referring to an ACID transaction. These transactions (logical unit of work) are designed for short-lived decisions usually lasting under a few seconds.

These transactions identify a logical unit of work that is either performed in complete or not at all. That is, either a COMMIT or a ROLLBACK is performed on the operations. This enables the data to maintain a state of consistency.

ACID is an acronym:

• A = Atomic – Transactions are atomic (all or none)
• C = Consistency – A consistent state of the database may be expected at all times.
• I = Isolation – Transactions are isolated from another; race conditions ensure that multiple transaction instances attempts do not collide.
• D = Durable – Once a transaction commits, it’s updates survive even, if the system goes down.

ACID Transactions are described in the GXA via the WS-Transaction specification. WS-Transaction refers to ACID transactions as, “atomic transactions”.