Transactions for System Design Interview (3): isolation levels
Don’t forget to get your copy of Designing Data Intensive Applications, the single most important book to read for system design interview prep! Udacity | Coursera | Pluralsight.
Check out ByteByteGo’s popular System Design Interview Course
Consider signing-up for paid Medium account to access our curated content for system design resources.
If you are interviewing, consider buying our number#1 course for Java Multithreading Interviews.
Introduction
Databases generally have several transactions in-flight at the same time, however, these transactions aren’t aware of each other and the database must ensure that one transaction doesn’t step on another transaction. The ability of a database to execute a transaction as if there’s no other transaction executing at the same time is referred to as database isolation.
Check out the course Coderust: Hacking the Coding Interview for Facebook and Google coding interviews.
Unfortunately, there’s no standard definition of the various named isolation levels. Different vendors implement isolation levels differently and the guarantees made for a particular isolation level may not be consistent across…
