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