ACID is a standard compliance requirement in the database ecosystem. It represents the following four principles: Atomicity, Consistency, Isolation, and Durability.
Atomicity - This ensures that a transaction is treated as a single unit. For example, when debiting payment data from the source, it should match the data in the receiver database.
Consistency - It guarantees that a database's integrity constraints are not violated during a transaction.
Isolation - This ensures that each transaction is independent of another, even when multiple concurrent transactions are happening in real-time. Each transaction should be considered as isolated.
Durability - This property ensures that once a transaction is committed, its changes are permanent and will survive any subsequent failures, such as a system crash.
In general, OLTP databases use techniques like ACID to maintain data accuracy and reliability. However, Amazon Redshift sacrifices some ACID compliance (Atomicity, Consistency, Isolation, Durability) in order to achieve high performance.
Read more: ACID Compliance
