avatar

Database Soup - Explaining ACID, BASE, CAP - Part 1

Mobycast
Mobycast
Episode • Feb 12, 2020 • 41m

In this episode, we cover the following topics:

  • In this new series, we are discussing database consistency models explained in three acts. This episode is "Act I: Transaction processing (circa 1973)".
  • We start with the motivation behind talking about database soup - why are ACID, CAP, and BASE important to understand?
  • We define transaction processing and its origins. What exactly is a "transaction"?
  • Transactions are governed by ACID semantics. We define and explain the four characteristics of the ACID acronym::
  • Atomicity
  • Consistency
  • Isolation
  • Durability
  • The computer scientist, Jim Gray, came up with the idea of ACID semantics in the late 1970's. We discuss some of the history behind this, along with a bizarre and tragic ending to his story.
  • We also share a personal story about another important player in transaction processing, Phil Bernstein.

Detailed Show Notes

Want the complete episode outline with detailed notes? Sign up here: https://mobycast.fm/show-notes/

Support Mobycast

https://glow.fm/mobycast


End Song

Talcum by Lost Lake

More Info

For a full transcription of this episode, please visit the episode webpage.

We'd love to hear from you! You can reach us at: