Listen "Back to Basics: MVCC - Why databases are magic!"
Episode Synopsis
Databases are incredibly complex pieces of software, which can come as a surprise given that anyone can throw together a few lines of C code to read and write data from a file. What differentiates a database from simple file read/write is how databases handle concurrent access to the data. For many years, the feature that has set Oracle Database apart from all others is its "read consistency" implementation or Multi Version Concurrent Control (MVCC). We've all heard the mantra: readers don't block writers; writers don't block readers. In this episode we'll explore why the feature is so cool, but also see what such flexibility could also lead a developer down the wrong path to corrupted data.
If you like this episode, be sure you hit the Like button and share it with your colleagues. Catch me on Twitter at https://twitter.com/connor_mc_d if you have comments or questions.
If you like this episode, be sure you hit the Like button and share it with your colleagues. Catch me on Twitter at https://twitter.com/connor_mc_d if you have comments or questions.
More episodes of the podcast The Spoken Nerd
Tech chat with Martin Bach - part 3
22/05/2024
Tech chat with Martin Bach - part 2
14/05/2024
Tech chat with Martin Bach - part 1
08/05/2024
The Best Things in Life are Free - part 2
27/03/2024
The Best Things in Life are Free - part 1
06/03/2024
Back to Basics - The Burden of Proof
04/10/2023
Catching up with Maria Colgan - part4
11/05/2023
Catching up with Maria Colgan - part3
23/03/2023
ZARZA We are Zarza, the prestigious firm behind major projects in information technology.