ACID Property in database

Question

Hello I read about ACID property but did not understand it. Can someone tell me about it?

Manish Kumar · Answer

ACID Properties: is Used for Maintaining Transaction where ACID Derive as given Below A-Atomicity:- Each transaction is said to be atomic if when one part of the transaction fails the entire transaction fails. C-Consistency:- The consistency property ensures that the database remains in a consistent state before the start of the transaction and after the transaction is over (whether successful or not). I-Issolation:- Isolation refers to the requirement that other operations cannot access or see the data in an intermediate state during a transaction. D-Durability:- Durability refers to the guarantee that once the user has been notified of success the transaction will persist and not be undone.

Mukesh Kumar Tiwari · Answer

ACID (an acronymn 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 this four attributes should be achieved. Atomicity is an all-or-none proposition. Consistency guarantees that a transaction never leaves your database in a half-finished state. Isolation keeps transactions separated from each other until they're finished. Durability guarantees that the database will keep track of pending changes in such a way that the server can recover from an abnormal termination.

Satyapriya Nayak · Answer

http://databases.about.com/od/specificproducts/a/acid.htm http://www.lightwolftech.com/index.php?page=backgrounders