O'Reilly logo

Principles of Transaction Processing, 2nd Edition by Eric Newcomer, Philip A. Bernstein

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 6

Locking

6.1 Introduction

An important property of transactions is that they are isolated. Technically, this means that the execution of transactions has the same effect as running the transactions serially, one after another, in sequence, with no overlap in executing any two of them. Such an execution is called serializable, meaning that it has the same effect as a serial execution. A serializable execution gives each user the easy-to-understand illusion that while the system is processing his or her transaction, it is doing no other work.

The most popular mechanism used to attain serializability is locking. The concept is simple:

■ Each transaction reserves access to the data it uses. This reservation is called a lock.

■ There are read ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required