• 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.
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.
Julian F.
Head of Cybersecurity
I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.
Addison B.
Field Engineer
I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.
Amir M.
Data Platform Tech Lead
I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.