Acid Property of Database

ACID (an acronym for Atomicity, Consistency Isolation, Durability) is a concept that Database Professionals generally look for when evaluating databases and application architectures. For a reliable database all these four attributes should be achieved.

- Atomicity- Atomicity is an all-or-none proposition.
- Consistency- Consistency guarantees that a transaction never leaves your database in a half-finished state.
- Isolation- Isolation keeps transactions separated from each other until they’re finished.
- Durability- Durability guarantees that the database will keep track of pending changes in such a way that the server can recover from an abnormal termination.

#database  # acid property  # sql  # mysql  # mssql