| ACID: |
|
| Atomicity - all or
nothing. |
|
| Consistency - database stays consistent, no violations of
constraints. |
|
| Isolation - each
transaction executes as if done serially. |
|
| Durability - once the
transaction completes, the changes will persist. |
|
| ACID properties are
implemented by concurrency controls and recovery mechanisms. |
|