title: What is the difference between inconsistent analysis and dirty reads?
body: <p>I am a newbie at SQL and prepering for a test. I would like to know what the difference is between 'dirty reads' and 'inconsistent analysis'. These are to do with the integrity of the table. I googled and found some answers but can't seem to differentiate the two. This is what I've gathered and they both pretty much have the same meaning:
  Dirty Read/Inconsistent Analysis: if transaction A starts and changes a value and transaction B reads this value before transaction A can commit/rollback then there's a possibilty of a false value being entered since A may have rollbacked but B read a invalid value.</p>
  
  <p>If someone can point the difference between the two then that would be great :)</p>