Java Script needs to be enabled for Video to Load.

Timestamp based and Optimistic Protocols

Loading Video Lesson
In this 46 mins Lesson you will Learn about following concepts.
Timestamp based and Optimistic Protocols

Timestamp based Protocols, Timestamp Ordering protocol, Thomas' Write Rule, Optimistic/ Validation Based Protocols, Multiversion Scheme, and related Topics.


Related Video Lessons in this Series

Lock Based Protocols

55 mins Video Lesson

Introduction, Lock Based Protocols, Starvation, Desdlocks, 2 Phase Locking Protocol, Strict 2PL, Rogorous 2PL, Lock Conversion Based Protocol, and other topics.

Timestamp based and Optimistic Protocols

46 mins Video Lesson

Timestamp based Protocols, Timestamp Ordering protocol, Thomas' Write Rule, Optimistic/ Validation Based Protocols, Multiversion Scheme, and other topics.

Deadlocks

38 mins Video Lesson

DeadLocks, Deadlock Prevention, Preemtion/ Rollback Scheme, Wait-Die Scheme, Wound-Wait Scheme, Deadlock Detection, Deadlock Recovery, Selection of Victim, Rollbacks, and other topics.

Failures and Log based Recovery Techniques

45 mins Video Lesson

Introduction, Types of Failures, Log Based Recovery, Deferred Database Modification, Immediate Database Modification, and other topics.

Check point based Recovery and Shadow Paging

36 mins Video Lesson

Checkpoint Based Recovery, Shadow Paging, and other topics.

SQL - Basic Concepts and Queries

56 mins Video Lesson

Introduction, Data Types, Schema And Catalog, Select-From-Where, Cross Product, Aliasing / Rename, Star Symbol (*), SQL results as MultiSet, Set Operations, Generalized Projection - Use of Math. Ops, Order By, String Comparison - Like, and other topics.

Data Definitions, Schemas and Views

39 mins Video Lesson

Table Creation, Domain Creation, Deleting a table - Drop Table, Modifying a Table - Alter Table, Views, and other topics.

NULL Comparisons, Nested and Co-related Queries

41 mins Video Lesson

Introduction, NULL Comparison, Nested Queries - In/ Some/ Any/ All, Co-Related Query - Exist/ Not Exist, and other topics.

Member's Zone