Artwork

Content provided by Connor McDonald. All podcast content including episodes, graphics, and podcast descriptions are uploaded and provided directly by Connor McDonald or their podcast platform partner. If you believe someone is using your copyrighted work without your permission, you can follow the process outlined here https://ppacc.player.fm/legal.
Player FM - Podcast App
Go offline with the Player FM app!

Back to Basics: Understanding Database Locking

31:31
 
Share
 

Manage episode 365391057 series 3376484
Content provided by Connor McDonald. All podcast content including episodes, graphics, and podcast descriptions are uploaded and provided directly by Connor McDonald or their podcast platform partner. If you believe someone is using your copyrighted work without your permission, you can follow the process outlined here https://ppacc.player.fm/legal.

If you are the only person using a PC, then the concept of having to lock information is totally foreign, because all of the data is yours and yours alone. But databases were built for the multi-user world, where concurrent access to the data is the norm. To handle this, we sometimes need to lock the data to ensure it is controlled and updated in a way that guarantees integrity and correctness. In this episode, we discuss the "Optimistic" and "Pessimistic" locking strategies, how they are used to handle the "Lost Update" problem, and what role the internet played in changing our view of database locking. 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.

Blog post referred to in the episode: https://stewashton.wordpress.com/2017/06/17/avoiding-lost-updates-with-ora_rowscn/

  continue reading

41 episodes

Artwork
iconShare
 
Manage episode 365391057 series 3376484
Content provided by Connor McDonald. All podcast content including episodes, graphics, and podcast descriptions are uploaded and provided directly by Connor McDonald or their podcast platform partner. If you believe someone is using your copyrighted work without your permission, you can follow the process outlined here https://ppacc.player.fm/legal.

If you are the only person using a PC, then the concept of having to lock information is totally foreign, because all of the data is yours and yours alone. But databases were built for the multi-user world, where concurrent access to the data is the norm. To handle this, we sometimes need to lock the data to ensure it is controlled and updated in a way that guarantees integrity and correctness. In this episode, we discuss the "Optimistic" and "Pessimistic" locking strategies, how they are used to handle the "Lost Update" problem, and what role the internet played in changing our view of database locking. 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.

Blog post referred to in the episode: https://stewashton.wordpress.com/2017/06/17/avoiding-lost-updates-with-ora_rowscn/

  continue reading

41 episodes

All episodes

×
 
Loading …

Welcome to Player FM!

Player FM is scanning the web for high-quality podcasts for you to enjoy right now. It's the best podcast app and works on Android, iPhone, and the web. Signup to sync subscriptions across devices.

 

Quick Reference Guide

Copyright 2025 | Privacy Policy | Terms of Service | | Copyright
Listen to this show while you explore
Play