Find knowledge base article(s) by searching for keywords in the title e.g. type linux in the search box below
Find knowledge base article(s) by browsing the subject categories of articles
Technology quick references, cheatsheets, user manuals etc.
Shop Online through ShopifyLite
Tutorials on various IT applications.
Search Title    (UL:0 |SS:f)

Glossary >> A >> ACID >> What is ACID (as in ACID transaction)

Atomicity, Consistency, Isolation and Durability

"a set of properties that guarantee that database transactions are processed reliably" ... wikipedia

Atomicity requires that each transaction be "all or nothing": if one part of the transaction fails, the entire transaction fails...

The consistency property ensures that any transaction will bring the database from one valid state to another...

The isolation property ensures that the concurrent execution of transactions results in a system state that would be obtained if transactions were executed serially....

Durability means that once a transaction has been committed, it will remain so, even in the event of power loss, crashes, or errors

 

[ © 2008-2021 myfaqbase.com - A property of WPDC Consulting ]