Transaction Management in Database Management Systems

Transaction Management in Database Management Systems, Transaction Processing Concepts in DBMS, Transactions in DBMS, Serializability, Concurrency Control, Recovery in Database

Transactions Management in DBMS

• Definition

• ACID Properties - Atomicity, Consistency, Isolation, Durability

• Types of failures that causes a transaction to fail

• Transaction States

• Concurrent Execution of Transactions and its Advantages

• Need for Concurrency Control in DBMS

• Schedules - Defined with examples

• Serial Schedules

• Serializable Schedules

• Serializability

• Conflict Serializability
• Testing for conflict serializability using precedence graph

• View Serializability

• Recoverable Schedules
• Why do we need recoverable schedules?

• Cascadeless Schedules

• Serializability Testing

• Properties of schedule of transactions in DBMS

• Concurrency Control - Definition

• Lost Update Problem (due to Write-Write conflict) - Example

• Uncommitted / Dirty Read Problem (Write-Read conflict) - Example

• Inconsistent Analysis Problem - Example

• Two Phase Locking (2PL) protocol

•  Important facts about serializable transactions and schedules

***************

Go to Advanced DBMS concepts page

Go to Transactions in Distributed DBMS page