Page 155 - DCAP402_DCAO204_DATABASE MANAGEMENT SYSTEM_MANAGING DATABASE

Database Management Systems/Managing Database Pooja Gupta, Lovely Professional University

Notes Unit 9: Transaction Management

CONTENTS

Objectives
Introduction

9.1 Concept of a Transaction
9.2 Transaction State

9.3 Implementation of Atomicity and Durability
9.4 Concurrent Execution

9.5 Serializability
9.6 Recoverability

9.7 Implementation of Isolation
9.8 Testing for Serializability

9.9 Lock based Protocols
9.9.1 Two-phase Locking (2 PL) Protocol

9.9.2 Strict Two-phase Locking (Strict 2PL) Protocol
9.10 Timestamp based Protocol

9.11 Validation Based Protocols
9.12 Deadlock Handling

9.12.1 Deadlock Prevention
9.12.2 Deadlock Recovery

9.13 Insert and Delete Operation
9.14 Weak Level of Consistency

9.14.1 Degree-two Consistency
9.14.2 Weak Levels of Consistency in SQL

9.15 Summary
9.16 Keywords

9.17 Self Assessment
9.18 Review Questions

9.19 Further Readings

148 LOVELY PROFESSIONAL UNIVERSITY