06-01-2018, 10:17 AM | #1 |
Registered User
Join Date: Mar 2018
Posts: 341
|
What is ACID property in database?
ACID property is used to ensure that the data transactions are processed reliably in a database system.
A single logical operation of a data is called transaction. ACID is an acronym for Atomicity, Consistency, Isolation, Durability. Atomicity: it requires that each transaction is all or nothing. It means if one part of the transaction fails, the entire transaction fails and the database state is left unchanged. Consistency: the consistency property ensure that the data must meet all validation rules. In simple words you can say that your transaction never leaves your database without completing its state. Isolation: this property ensure that the concurrent property of execution should not be met. The main goal of providing isolation is concurrency control. Durability: durability simply means that once a transaction has been committed, it will remain so, come what may even power loss, crashes or errors.
__________________
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts. | To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts. | To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts. | To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts. |
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Best way to appeal property taxes | poconnor | General Discussion | 0 | 04-08-2016 02:53 AM |