Transactions and Concurrency Control Patterns

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.

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