What is ACID?

ACID is - Atomicity, Consistency, Isolation and Durability

In database world, ACID is an acronym. It stands for; Atomicity, Consistency, Isolation and Durability. Databases should have these four features for them to become a reliable databases. All of these four features relate with transactions.
  • Atomicity:
    A transaction has to be completely committed or roll-backed, a portion of the transaction should not be committed to the database due to any issue even on a hardware failure.
  • Consistency:
    After any transaction the data in the database should be correct and valid according to the requirements. Database should not be having any illegal data after a transaction.
  • Isolation:
    When two or more transactions exists, one's behavior should not give invalid data for the other transaction. That is, when one transaction is in progress, the data alterations made by that transaction should not be visible to any other transactions.
  • Durability:
    After the commit operation is acknowledged by the database, the data inside that transaction should not be lost. The updating of those data into the database has to be guaranteed.

COMMENTS

BLOGGER
Name

About,2,Adsense,3,Ant,1,Apache,3,Axis,3,Blogger,1,Books,1,CentOS,2,Chrome,2,CSS,2,Database,3,Earn Online,3,Eclipse,10,Facebook,1,Firefox,10,Gmail,4,GNU/Linux,9,Google,26,GWT,8,Hardware,2,IE,5,Interesting,15,Internet,14,Java,49,Javascript,7,JBoss,1,Jenkins,1,Log4j,2,Me,6,Microsoft,2,Miscellaneous,1,News,11,Opinion,10,OSGi,1,PHP,1,Productivity,3,Programming,36,Puzzle,3,Security,4,Software,41,Sports,9,Spring,2,Story,6,Subversion,3,TDD,4,Tech,2,Tips,1,Tomcat,6,Tutorial,13,Ubuntu,4,Web application,14,Web Design,2,Web services,3,Windows,10,Yahoo,1,Zip,2,
ltr
item
Digizol: What is ACID?
What is ACID?
ACID is - Atomicity, Consistency, Isolation and Durability
https://1.bp.blogspot.com/-YRGPlhLKopA/WeuHpyGpAJI/AAAAAAAACiE/cMIjBrYi8p4LiFfPln-R1osgCjkhYOQGwCLcBGAs/s1600/What%2Bis%2BACID%2Bwww.digizol.com.jpg
https://1.bp.blogspot.com/-YRGPlhLKopA/WeuHpyGpAJI/AAAAAAAACiE/cMIjBrYi8p4LiFfPln-R1osgCjkhYOQGwCLcBGAs/s72-c/What%2Bis%2BACID%2Bwww.digizol.com.jpg
Digizol
http://www.digizol.com/2006/09/what-is-acid.html
http://www.digizol.com/
http://www.digizol.com/
http://www.digizol.com/2006/09/what-is-acid.html
true
7440473
UTF-8
Loaded All Posts Not found any posts VIEW ALL Readmore Reply Cancel reply Delete By Home PAGES POSTS View All RECOMMENDED FOR YOU LABEL ARCHIVE SEARCH ALL POSTS Not found any post match with your request Back Home Sunday Monday Tuesday Wednesday Thursday Friday Saturday Sun Mon Tue Wed Thu Fri Sat January February March April May June July August September October November December Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec just now 1 minute ago $$1$$ minutes ago 1 hour ago $$1$$ hours ago Yesterday $$1$$ days ago $$1$$ weeks ago more than 5 weeks ago Followers Follow THIS CONTENT IS PREMIUM Please share to unlock Copy All Code Select All Code All codes were copied to your clipboard Can not copy the codes / texts, please press [CTRL]+[C] (or CMD+C with Mac) to copy