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

Save Big on Coursera Plus. 7,000+ courses at $160 off. Limited Time Only!
Explore the critical aspects of transactions and concurrency control in enterprise systems data integrity through this comprehensive 45-minute Devoxx conference talk. Delve into the complexities of database system inner workings, concurrency control design choices like 2PL and MVCC, transaction isolation levels, and locking schemes. Examine potential data anomalies across various transaction isolation levels, with specific references to Oracle, SQL Server, PostgreSQL, and MySQL. Discover why database transactions alone may not suffice, particularly in multi-request web flows, and learn about application-level transaction patterns based on optimistic and pessimistic locking mechanisms. Cover key topics including atomicity, consistency, durability, isolation, conflicts, locking, MVCC, phantom reads, version columns, and Hibernate implementation.

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.