The I in ACID
summary
Explains the meaning of the I in the ACID database properties (Atomicity, Consistency, Isolation, Durability), focusing on Isolation and how databases implement it. Covers specific technologies and mechanisms such as isolation levels, locking, transactions and concurrency control used by relational databases to ensure correct concurrent behavior. Compares approaches and practical implications for application developers when choosing isolation strategies.
AI-written summary · about
chapters (10)
- 0:00Introduction
- 1:05What is ACID
- 5:23Transaction isolation
- 9:39Isolation anomalies explained
- 19:06Isolation levels and locks
- 22:37Choosing isolation level
- 25:48Practical cases by app
- 29:00Invoice numbers and serialization
- 31:49Avoiding unnecessary layers
- 33:14Q&A
related talks
38mThe I in ACID
52mACID in SQL Server: what it is, how it works, and how to live more adventurously.- 52mACID in SQL Server: what it is, how it works, and how to live more adventurously.
- 52mACID in SQL Server: what it is, how it works, and how to live more adventurously.
52mTransactions: Myths, Surprises and Opportunities
06mIgnite: DevOps on ACID
01mDon't Drop ACID - Transactions in Distributed NoSQL
47mBeing transactional in 2019 - what does this actually mean?