ACID: Isolation, Transactions and what can go wrong with your data

Is your data correct? Do you “get” isolation levels in a database and why they are important? Every app has different requirements for data correctness and the “I” in ACID is the key to understanding these concepts.

ACID is a core concept in a relational database. And while many claim to deliver ACID transactions it is important to dive a little deeper into the acronym to understand how it is delivered and what are the trade-offs of different database isolation levels.

In this session, we’ll explore the I in ACID and talk through…

• What is data isolation and what can for wrong with your data
• What are isolation levels for a database
• Dirty Reads, Phantom reads, Non-repeatable reads, and the problems with inconsistent databases