Vlad Mihalcea - Transactions and Concurrency Control Patterns
Transactions and Concurrency Control are very of paramount importance when it comes to enterprise systems data integrity.
However, this topic is very tough since you have to understand the inner workings of the database system, its concurrency control design choices (e.g. 2PL, MVCC), transaction isolation levels and locking schemes.
In this presentation, I'm going to explain what data anomalies can happen depending on the transaction isolation level, with references to Oracle, SQL Server, PostgreSQL, and MySQL.
I will also demonstrate that database transactions are not enough, especially for multi-request web flows. For this reason, I'm going to present multiple application-level transaction patterns based on both optimistic and pessimistic locking mechanisms.
Last, I'm going to talk about Concurrency Control strategies used in the Hibernate second-level caching mechanism, which can boost performance without compromising strong consistency.
Видео Vlad Mihalcea - Transactions and Concurrency Control Patterns канала Devoxx
However, this topic is very tough since you have to understand the inner workings of the database system, its concurrency control design choices (e.g. 2PL, MVCC), transaction isolation levels and locking schemes.
In this presentation, I'm going to explain what data anomalies can happen depending on the transaction isolation level, with references to Oracle, SQL Server, PostgreSQL, and MySQL.
I will also demonstrate that database transactions are not enough, especially for multi-request web flows. For this reason, I'm going to present multiple application-level transaction patterns based on both optimistic and pessimistic locking mechanisms.
Last, I'm going to talk about Concurrency Control strategies used in the Hibernate second-level caching mechanism, which can boost performance without compromising strong consistency.
Видео Vlad Mihalcea - Transactions and Concurrency Control Patterns канала Devoxx
Показать
Комментарии отсутствуют
Информация о видео
Другие видео канала
![](https://i.ytimg.com/vi/_odQElMOTC4/default.jpg)
![Saga about distributed transactions in microservices world (Mikalai Alimenkou, Ukraine) [RU]](https://i.ytimg.com/vi/Kukho-5cqCI/default.jpg)
![JPA beyond copy paste by Jakub Kubrynski](https://i.ytimg.com/vi/EZwpOLCfuq4/default.jpg)
![Concurrency Patterns In Go](https://i.ytimg.com/vi/YEKjSzIwAdA/default.jpg)
![Vlad Mihalcea - Awesome SQL – tips and tricks for application developers](https://i.ytimg.com/vi/-fd_0EGujM0/default.jpg)
![Data Consistency in Microservices Architecture (Grygoriy Gonchar)](https://i.ytimg.com/vi/CFdPDfXy6Y0/default.jpg)
![Why do We Have Repeatable Read and Serializable Isolation Levels?](https://i.ytimg.com/vi/xR70UlE_xbo/default.jpg)
![Concurrency Deep-Dive](https://i.ytimg.com/vi/ZxhBkBNxvR0/default.jpg)
![Using sagas to maintain data consistency in a microservice architecture by Chris Richardson](https://i.ytimg.com/vi/YPbGW3Fnmbc/default.jpg)
![How to do logging in Spring Boot - Brain Bytes](https://i.ytimg.com/vi/lGrcZsw-hKQ/default.jpg)
![Humans, Gods and Technology | VPRO documentary | 2017](https://i.ytimg.com/vi/tQd_5as_cMY/default.jpg)
![Architecting Large Scale Systems | Creating Scalable Web Application Architecture](https://i.ytimg.com/vi/6pjGuuGsqxE/default.jpg)
![High-Performance Hibernate (Vlad Mihalcea)](https://i.ytimg.com/vi/BTdTEe9QL5k/default.jpg)
![What is Slow Query Logging in MariaDB or MySQL and How to Enable Slow Query Log - MariaDB Tutorial](https://i.ytimg.com/vi/xZsB2ZiZQRM/default.jpg)
![Functional Programming Patterns with Java8 with Victor Rentea](https://i.ytimg.com/vi/F02LKnWJWF4/default.jpg)
![Graph Databases in Python](https://i.ytimg.com/vi/nJEfq8qduKA/default.jpg)
![How he got into Google London as Software Engineer | Interview Experience | Preparation Strategies](https://i.ytimg.com/vi/HMsHpNdRyi4/default.jpg)
![Transactions and Concurrency Control Patterns by Vlad Mihalcea](https://i.ytimg.com/vi/onYjxRcToto/default.jpg)
![MSSQL - Understanding Isolation Level By Example (Serializable)](https://i.ytimg.com/vi/ZtPj09tJjnQ/default.jpg)
![Dvorak Keyboard: My Thoughts After 10 Years](https://i.ytimg.com/vi/Ks7dW1CGefg/default.jpg)