Databases Illuminated, 3rd Edition

 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 ...