Properties of SQL Transactions
By definition, a database transaction needs to be atomic, consistent, isolated, and durable. The abbreviation These are frequently referred to as ACID properties.
- Atomicity – This property guarantees the successful completion of all tasks inside the work unit. So, in case any task fails, all prior operations are rolled back to their initial states and the transaction is aborted at the point of failure.
- Consistency – This property makes sure that after a successful committed transaction, the database's states are changed appropriately.
- Isolation – This property allows transactions to function transparently and independently of one another.
- Durability – This property makes sure that a committed transaction's outcome or impact endures in the event of a system malfunction.