In the previous post, we read about the various issues possible if we use weaker forms of isolation like read committed and snapshot isolation. We read about the lost-updates and write-skew problems. We concluded the section by admitting that Serializable Isolation is the way to go in order to avoid all sorts of concurrency issues. In this post, let’s define the Snapshot Isolation and see how it is implemented in databases.

Serializable Isolation is the strongest isolation that is possible in databases. It ensures that the result produced by a transaction (in presence of multiple concurrent transactions) is the same…

Ishan Mishra

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store