Home
Categories
EXPLORE
True Crime
Comedy
Society & Culture
Business
Sports
History
Music
About Us
Contact Us
Copyright
© 2024 PodJoint
00:00 / 00:00
Sign in

or

Don't have an account?
Sign up
Forgot password
https://is1-ssl.mzstatic.com/image/thumb/Podcasts114/v4/d8/0e/74/d80e7414-c2e4-55c7-7c68-e484fe4e28d7/mza_16992237731753751335.jpg/600x600bb.jpg
The Spoken Nerd
Connor McDonald
41 episodes
9 months ago
Musings on technology from long time database professional. Some times we can’t dedicate 100% of our attention to blog posts, or videos, or webinars, so whether you are working, or just working out. you can enjoy these podcasts alongside the daily grind
Show more...
Technology
RSS
All content for The Spoken Nerd is the property of Connor McDonald and is served directly from their servers with no modification, redirects, or rehosting. The podcast is not affiliated with or endorsed by Podjoint in any way.
Musings on technology from long time database professional. Some times we can’t dedicate 100% of our attention to blog posts, or videos, or webinars, so whether you are working, or just working out. you can enjoy these podcasts alongside the daily grind
Show more...
Technology
https://is1-ssl.mzstatic.com/image/thumb/Podcasts114/v4/d8/0e/74/d80e7414-c2e4-55c7-7c68-e484fe4e28d7/mza_16992237731753751335.jpg/600x600bb.jpg
Back to Basics: Understanding Database Locking
The Spoken Nerd
31 minutes 31 seconds
2 years ago
Back to Basics: Understanding Database Locking
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/  
The Spoken Nerd
Musings on technology from long time database professional. Some times we can’t dedicate 100% of our attention to blog posts, or videos, or webinars, so whether you are working, or just working out. you can enjoy these podcasts alongside the daily grind