Are you an EPFL student looking for a semester project?
Work with us on data science and visualisation projects, and deploy your project as an app on top of Graph Search.
Lecture
Are you an EPFL student looking for a semester project?
Work with us on data science and visualisation projects, and deploy your project as an app on top of Graph Search.
This lecture covers the Kung-Robinson Model for Optimistic Concurrency Control, where transactions are ordered by timestamps and conflicts are resolved during a validation phase. It explains the tests for conflict detection, critical sections, overheads, and the comparison with Timestamp-based Concurrency Control. The lecture also delves into Multiversion Concurrency Control, Snapshot Isolation, and the challenges of write skew. Various techniques to improve transaction performance are discussed, including prepared statements and query batches.