C Books Guide and List
C++ Books Guide and List
Best Java Books

3,749 questions

4,049 answers

114 comments

10,705 users

Explain ACID rule of thumb for transactions?

0 votes
13 views
asked Apr 2, 2014 by sunny Expert (11,410 points)

1 Answer

0 votes
A transaction must be:
1. Atomic - it is one unit of work and does not dependent on previous and following transactions.
2. Consistent - data is either committed or roll back, no “inbetween” case where something has been updated and something hasn’t.
3. Isolated - no transaction sees the intermediate results of the current transaction.
4. Durable - the values persist if the data had been committed even if the system crashes right after.
answered Apr 2, 2014 by felin Advisor (8,400 points)

Related questions

0 votes
1 answer 5 views
5 views asked Dec 24, 2013 by rajesh Guru (39,140 points)
0 votes
1 answer 26 views
0 votes
1 answer 13 views
13 views asked Mar 8, 2014 by smith Geek (15,340 points)
0 votes
1 answer 9 views
9 views asked Dec 24, 2013 by john Guru (27,140 points)
0 votes
1 answer 25 views
25 views asked Dec 24, 2013 by john Guru (27,140 points)
...