CHAPTER 

9

Transaction Management

TABLE OF CONTENTS

9.1    ACID Properties of Transactions

9.2    Need for Concurrency Control

9.3    Serializability

9.4    Locking

9.5    Timestamping

9.6    Optimistic Techniques

9.7    Need for Recovery

9.8    Recovery Techniques

9.9    Transaction Management in Oracle

9.10  Chapter Summary

Exercises

CHAPTER OBJECTIVES

In this chapter you will learn the following:

  Why concurrency control is needed

  The meaning of serializability

  Why and how locking is done

  How the two-phase locking protocol works

  How timestamping is used for serializability

  How optimistic concurrency control techniques operate

  The meaning of database recovery

  The nature and purpose of the transaction log

  Why and ...

Get Databases Illuminated, 3rd Edition now with O’Reilly online learning.

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