• Consistency implies that only a valid data will be written to a database. If, for some reason,
a transaction violates the database’s consistency rules, then the entire transaction should be
rolled back, and the database will be restored to a state that was consistent with those rules.
On the other hand, if a transaction successfully executes as per the consistency rules of the
database, the database moves from one state that is consistent with the rules to another state
that is also consistent with those rules.
• Isolation requires that multiple transactions occurring on the database at the same time
should not impact one another. For example, if John carries out a transaction on a database at
the same time when ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month, and much more.