Transactions

Video Lessons & Revision Notes

Transactions - Basic Concepts and ACID properties
Transactions - Basic Concepts and ACID properties
1. Transactions - Basic Concepts and ACID properties
In this 41 mins Video Lesson
Introduction, ACID Properties, Atomicity, Consistency, Isolation, Durability, Transaction states, and other topics.
Concurrency and Concept of Schedules
Concurrency and Concept of Schedules
2. Concurrency and Concept of Schedules
In this 40 mins Video Lesson
Introduction, Concurrency, Advantages of Concurrency, Schedule, Serial Schedule, Equivalence of Schedules, Conflicting Set of Operations, Conflict Serializability, Serializability, and other topics.
Serializability, View Equivalence and Recoverability
Serializability, View Equivalence and Recoverability
3. Serializability, View Equivalence and Recoverability
In this 49 mins Video Lesson
Need For Serializability, Example: Confilct serializability, Conflict Equivalence, Test For Conflict Serializability, View Equivalence, View Serializability, Recoverability, Recoverable Schedule, Cascadeless Schedule, and other topics.

Revision Notes

Transactions (2.14 Mb)

Basic concept of a Transaction, Properties of Transactions, Concept of Schedule, Serial Schedule, Serializability: Conflict and View, Cascaded Aborts, Recoverable and Non-recoverable Schedules

Member's Zone