ACID
ACID (Atomicity, Consistency, Isolation, Durability) is a set of properties that guarantee that database transactions are processed reliably, as follows:
- Atomicity — All of the tasks of a transaction are performed or none of them are. This means that if the entire transaction succeeds, it is committed. If any part of the transaction fails, the entire transaction fails and is rolled back.
- Consistency — Data integrity constraints are maintained. This ensures that the database remains in a consistent state before the start of the transaction and after the transaction is over (whether successful or not). Vertica provides limited constraint checking.
- Isolation — Concurrent transactions do not interact with one another.
- Durability — Short of catastrophic failure, the effects of committed transactions persist.