Pessimistic concurrency control vs Optimistic concurrency control in Database Systems Explained
In this video, I discuss the different concurrency control at database transactions, specifically the pessimistic vs optimistic concurrency control. and the pros and cons of each.
0:00 Intro
3:00 concurrency Control
5:30 Pessimistic concurrency Control
9:20 Optimistic concurrency Control
Resources
https://en.wikipedia.org/wiki/Optimistic_concurrency_control
https://www.baeldung.com/java-jpa-transaction-locks
https://docs.oracle.com/javaee/7/api/javax/persistence/OptimisticLockException.html
https://en.wikipedia.org/wiki/Time-of-check_to_time-of-use
https://www.2ndquadrant.com/en/blog/postgresql-anti-patterns-read-modify-write-cycles/
🏭 Backend Engineering Videos
https://www.youtube.com/playlist?list=PLQnljOFTspQUNnO4p00ua_C5mKTfldiYT
💾 Database Engineering Videos
https://www.youtube.com/playlist?list=PLQnljOFTspQXjD0HOzN7P2tgzu7scWpl2
🛰 Network Engineering Videos
https://www.youtube.com/playlist?list=PLQnljOFTspQUBSgBXilKhRMJ1ACqr7pTr
🏰 Load Balancing and Proxies Videos
https://www.youtube.com/playlist?list=PLQnljOFTspQVMeBmWI2AhxULWEeo7AaMC
🐘 Postgres Videos
https://www.youtube.com/playlist?list=PLQnljOFTspQWGrOqslniFlRcwxyY94cjj
🚢Docker
https://www.youtube.com/playlist?list=PLQnljOFTspQWsD-rakNw1C20c1JI8UR1r
🧮 Programming Pattern Videos
https://www.youtube.com/playlist?list=PLQnljOFTspQV1emqxKbcP5esAf4zpqWpe
🛡 Web Security Videos
https://www.youtube.com/playlist?list=PLQnljOFTspQU3YDMRSMvzflh_qXoz9zfv
🦠 HTTP Videos
https://www.youtube.com/playlist?list=PLQnljOFTspQU6zO0drAYHFtkkyfNJw1IO
🐍 Python Videos
https://www.youtube.com/playlist?list=PLQnljOFTspQU_M83ARz8mDdr4LThzkBKX
🔆 Javascript Videos
https://www.youtube.com/playlist?list=PLQnljOFTspQWab0g3W6ZaDM6_Buh20EWM
👾Discord Server https://discord.gg/CsFbFce
Become a Member
https://www.youtube.com/channel/UC_ML5xP23TOWKUcc-oAE_Eg/join
Support me on PayPal
https://bit.ly/33ENps4
Become a Patreon
https://www.patreon.com/join/hnasr?
Stay Awesome,
Hussein
Видео Pessimistic concurrency control vs Optimistic concurrency control in Database Systems Explained канала Hussein Nasser
0:00 Intro
3:00 concurrency Control
5:30 Pessimistic concurrency Control
9:20 Optimistic concurrency Control
Resources
https://en.wikipedia.org/wiki/Optimistic_concurrency_control
https://www.baeldung.com/java-jpa-transaction-locks
https://docs.oracle.com/javaee/7/api/javax/persistence/OptimisticLockException.html
https://en.wikipedia.org/wiki/Time-of-check_to_time-of-use
https://www.2ndquadrant.com/en/blog/postgresql-anti-patterns-read-modify-write-cycles/
🏭 Backend Engineering Videos
https://www.youtube.com/playlist?list=PLQnljOFTspQUNnO4p00ua_C5mKTfldiYT
💾 Database Engineering Videos
https://www.youtube.com/playlist?list=PLQnljOFTspQXjD0HOzN7P2tgzu7scWpl2
🛰 Network Engineering Videos
https://www.youtube.com/playlist?list=PLQnljOFTspQUBSgBXilKhRMJ1ACqr7pTr
🏰 Load Balancing and Proxies Videos
https://www.youtube.com/playlist?list=PLQnljOFTspQVMeBmWI2AhxULWEeo7AaMC
🐘 Postgres Videos
https://www.youtube.com/playlist?list=PLQnljOFTspQWGrOqslniFlRcwxyY94cjj
🚢Docker
https://www.youtube.com/playlist?list=PLQnljOFTspQWsD-rakNw1C20c1JI8UR1r
🧮 Programming Pattern Videos
https://www.youtube.com/playlist?list=PLQnljOFTspQV1emqxKbcP5esAf4zpqWpe
🛡 Web Security Videos
https://www.youtube.com/playlist?list=PLQnljOFTspQU3YDMRSMvzflh_qXoz9zfv
🦠 HTTP Videos
https://www.youtube.com/playlist?list=PLQnljOFTspQU6zO0drAYHFtkkyfNJw1IO
🐍 Python Videos
https://www.youtube.com/playlist?list=PLQnljOFTspQU_M83ARz8mDdr4LThzkBKX
🔆 Javascript Videos
https://www.youtube.com/playlist?list=PLQnljOFTspQWab0g3W6ZaDM6_Buh20EWM
👾Discord Server https://discord.gg/CsFbFce
Become a Member
https://www.youtube.com/channel/UC_ML5xP23TOWKUcc-oAE_Eg/join
Support me on PayPal
https://bit.ly/33ENps4
Become a Patreon
https://www.patreon.com/join/hnasr?
Stay Awesome,
Hussein
Видео Pessimistic concurrency control vs Optimistic concurrency control in Database Systems Explained канала Hussein Nasser
Показать
Комментарии отсутствуют
Информация о видео
Другие видео канала
![What is a Distributed Transaction in Microservices?](https://i.ytimg.com/vi/H6F4BorD49g/default.jpg)
![what is OPTIMISTIC LOCK?](https://i.ytimg.com/vi/R-iX1r_7UY0/default.jpg)
![I ask this question to every Backend Engineer I interview](https://i.ytimg.com/vi/bDIB2eIzIC8/default.jpg)
![16 - Concurrency Control Theory (CMU Databases Systems / Fall 2019)](https://i.ytimg.com/vi/mYFo1aE47xE/default.jpg)
![Artificial intelligence and algorithms: pros and cons | DW Documentary (AI documentary)](https://i.ytimg.com/vi/s0dMTAQM4cw/default.jpg)
![When to use UDP vs TCP in Building a Backend Application?](https://i.ytimg.com/vi/G86axGfnWag/default.jpg)
![How to Avoid Double Booking and Race Conditions in Online Web Applications](https://i.ytimg.com/vi/_95dCYv2Xv4/default.jpg)
![Transactions and Concurrency Control Patterns by Vlad Mihalcea](https://i.ytimg.com/vi/onYjxRcToto/default.jpg)
![Why Idempotency is very critical in Backend Applications](https://i.ytimg.com/vi/4OuaONkZw1I/default.jpg)
![The OSI Model - Explained by Example](https://i.ytimg.com/vi/7IS7gigunyI/default.jpg)
![optimistic concurrency control technique](https://i.ytimg.com/vi/kPJT05J6_6o/default.jpg)
![Is there a Limit to Number of Connections a Backend can handle?](https://i.ytimg.com/vi/o-EkdZW4zbA/default.jpg)
![Validation based or optimistic concurrency control protocol - lecture167/ DBMS](https://i.ytimg.com/vi/CSoAqJfi5Fg/default.jpg)
![Using sagas to maintain data consistency in a microservice architecture by Chris Richardson](https://i.ytimg.com/vi/YPbGW3Fnmbc/default.jpg)
![Implementing optimistic locking using hibernate](https://i.ytimg.com/vi/3JsgNYxoINs/default.jpg)
![70GB of Unused Bloated Index Space Freed on Postgres, Here is how they did it](https://i.ytimg.com/vi/Zow5-Pa46MY/default.jpg)
![Distributed Locks | System design basics](https://i.ytimg.com/vi/v7x75aN9liM/default.jpg)
![10 YouTube Backend, Protocols, Networking, Database Channels to Follow in 2021 (I watch them all)](https://i.ytimg.com/vi/eusHw-mUa8Y/default.jpg)
![Problems with Concurrent Execution of Transactions](https://i.ytimg.com/vi/12X58NloDo0/default.jpg)
![Horizontal vs Vertical Database Partitioning](https://i.ytimg.com/vi/QA25cMWp9Tk/default.jpg)