Transactions

Table of Contents

Transactions

Introduction

ACID Properties

Example

Transaction State

Concurrent Executions

Example

Schedule 1 - Serial

Schedule 2 - Serial

Schedule 3 - Concurrent

Schedule 4 - Concurrent but Incorrect

Schedule 3 : Only Read and Write

Conflict Serializability

Schedule 5 and Schedule 6

Schedule 7: Not Conflict Serialiable

Schedule 8

Schedule 8

Schedule 9

Schedule 11

Schedule 12

Realizing Concurrent Schedules

Transactions in SQL

Test for Conflict Serializability

Summary

Email: bina@cse.buffalo.edu

Home Page: http://www.cse.buffalo.edu/~bina

Download presentation source