Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

YouTube

Transactions and Concurrency Control Patterns

Devoxx via YouTube

Overview

Google, IBM & Meta Certificates – 40% Off
One Coursera Plus subscription covers most Professional Certificates on Coursera.
Unlock All Certificates
This presentation explains how transaction isolation levels and database concurrency designs affect data anomalies, with examples from Oracle, SQL Server, PostgreSQL, and MySQL. It also presents application-level optimistic and pessimistic locking patterns for multi-request web flows.

Syllabus

Intro
History
Atomicity
Consistency
Durability
Isolation
Conflicts
Locking
Two Phase Locking
MVCC
MVCCC
Delete
Update
Two types of isolation
Isolation leverage
Phantom rate
Reads Q
Lexical Standards
Reality
Version column
Multiple columns
Splitting tables
Updating tables
Hibernate

Taught by

Devoxx

Reviews

Start your review of Transactions and Concurrency Control Patterns

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.