Home > DeveloperSection > Interviews > Explain ACID rule of thumb for transactions.

Posted on    December-31-2010 12:00 AM

 DB2 DB2 
Ratings:
 1 Answer(s)
  921  View(s)
Rate this:

Mahesh Rawat
Mahesh Rawat

Total Post:138

Points:690
Posted on    December-31-2010 1:00 AM

Transaction must be Atomic (it is one unit of work and does not dependent on previous and following transactions), Consistent (data is either committed or roll back, no “in-between” case where something has been updated and something hasn’t), Isolated (no transaction sees the intermediate results of the current transaction), Durable (the values persist if the data had been committed even if the system crashes right after).

Don't want to miss updates? Please click the below button!

Follow MindStick