Chapter 14. Concurrency Control

Table of Contents

14.1. Introduction
14.2. Transaction Isolation
14.2.1. Read Committed Isolation Level
14.2.2. Repeatable Read Isolation Level
14.2.3. Serializable Isolation Level
14.3. Explicit Locking
14.3.1. Table-Level Locks
14.3.2. Row-Level Locks
14.3.3. Page-Level Locks
14.3.4. Deadlocks
14.3.5. Advisory Locks
14.4. Data Consistency Checks at the Application Level
14.4.1. Enforcing Consistency with Serializable Transactions
14.4.2. Enforcing Consistency with Explicit Blocking Locks
14.5. Caveats
14.6. Locking and Indexes

This chapter describes the behavior of the LightDB database system when two or more sessions try to access the same data at the same time. The goals in that situation are to allow efficient access for all sessions while maintaining strict data integrity. Every developer of database applications should be familiar with the topics covered in this chapter.