© Dmitri Korotkevitch 2018
Dmitri KorotkevitchExpert SQL Server Transactions and Lockinghttps://doi.org/10.1007/978-1-4842-3957-5_2

2. Transaction Management and Concurrency Models

Dmitri Korotkevitch1 
Land O Lakes, Florida, USA

Transactions are the key concept in data management systems; they guarantee the consistency and durability of the data in the database. It is impossible to implement a database system without proper transaction management in place.

This chapter will explain the importance of transactions, provide an overview of both pessimistic and optimistic concurrency models, and outline transaction isolation levels and the possible data consistency phenomena they may introduce. Finally, the chapter will discuss several questions related ...

Get Expert SQL Server Transactions and Locking: Concurrency Internals for SQL Server Practitioners now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.