It is very critical for any database to maintain DATA integrity and having consistent data. For choosing any database this is one of the important CONSIDERATIONS. Data architects evaluate database on ACID  properties only. The ACID is an acronym and STANDS for Atomicity, Consistency Isolation, Durability.

Let me EXPLAIN to you four pillars of ACID property:

• Atomicity -These properties ensure that either all operation part of any database transaction will commit or none of the operations will be successful. This will ensure the consistency of data. Nothing partially gets committed in the database either all or none.
• Consistency-This properties ensure that data will never be in a half-finished state. It ensures changes in data always happen in a consistent way.
• Isolation-This ensure that all transactions run independently and without intervening one another and till the time each transaction is finished in its own way.
• Durability- This property is very critical as it ensures that even in case of any failover, there is enough mechanism to recover data in the system.