Lecture
Concurrency Control: Lock-Based Protocols
In course
DEMO: incididunt labore occaecat
Ad dolore in adipisicing eiusmod. Esse exercitation do aliquip non ex qui ipsum veniam consectetur et. Duis anim officia aute quis commodo velit elit irure incididunt. Eu voluptate laborum qui velit amet magna quis.
Description
This lecture covers lock-based concurrency control protocols, including Two-Phase Locking (2PL) and deadlock prevention and detection. It also discusses the limitations of flat transactions, transaction savepoints, transaction chains, nested transactions, compensating transactions, and SAGA transactions.
Instructor
est labore
Sint non irure fugiat sit minim Lorem tempor. Anim culpa minim proident reprehenderit commodo sint incididunt exercitation nostrud do. Elit est enim pariatur labore magna pariatur nisi Lorem non incididunt magna sunt excepteur culpa.
Official source
About this result
This page is automatically generated and may contain information that is not correct, complete, up-to-date, or relevant to your search query. The same applies to every other page on this website. Please make sure to verify the information with EPFL's official sources.
Ontological neighbourhood
Related lectures (33)
Concurrency Control & Recovery in Databases
Delves into transaction management, concurrency control, and recovery in databases to ensure data integrity and system resilience.
Transactions and Concurrency Control
Delves into lock-based concurrency control, deadlock handling, transaction models, and their limitations.
Transaction Management & Concurrency Control
Explores transaction management, concurrency control, ACID properties, anomalies, and conflict serializability in database systems.
Transactional Memory: Hardware Concurrency Control
Explores transactional memory for hardware concurrency control, discussing locking mechanisms, performance trade-offs, and hardware changes.
Architecture of CockroachDB
Explores the architecture of CockroachDB, focusing on transaction management, concurrency control, and scalability.