ACID Property in database

Suma M

12y1.8k

Hello,

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

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Manish Kumar12y ago
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.

0
Mukesh Kumar Tiwari12y ago
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.
0
Satyapriya Nayak12y ago
http://databases.about.com/od/specificproducts/a/acid.htm
http://www.lightwolftech.com/index.php?page=backgrounders
0