Skip to content
Pessimistic concurrency control vs Optimistic concurrency control in Database Systems Explained episode artwork

Aug 20, 2020 16 min

Pessimistic concurrency control vs Optimistic concurrency control in Database Systems Explained

from The Backend Engineering Show with Hussein Nasser Hosted by Hussein Nasser

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/

Episode details come from the podcast's RSS feed.

Embed this episode

Ready to play

Pessimistic concurrency control vs Optimistic concurrency control in Database Systems Explained

0:00 16:49

No transcript yet.

Requests help us decide what to transcribe next.

Frequently asked questions

How long is this episode of The Backend Engineering Show with Hussein Nasser?

This episode is 16 minutes long.

When was this The Backend Engineering Show with Hussein Nasser episode published?

This episode was published on August 20, 2020.

Can I download this The Backend Engineering Show with Hussein Nasser episode?

Yes. Use the download control on the episode player to save the publisher-provided media file.