Скачать или смотреть Log Based Recovery Nepali Explained

This video is only for Educational Purpose laa.
BBIS 5th Sem
DBMS

Summary :-
Deferred Method
If system damage after commit then recover by redo meaning latest values updated by the system and which are present in log will come back to the system.
If system damage before commit then recover by rollback to the intial state of where the T starts replacing the inital values back to the system.

Immediate Method
If system damage after commit then recover by redo meaning latest updated values from log put back to the system
If system damage before commit then do undo i.e to recover old value present in the log file back to the system.

Undo :- Can change modify values before commit.
No-undo:- Once T commits then cannot modify values.
Redo:- Once T commits then the latest updated values committed by the system can be put back.

00:00 Starts
00:43 Log
05:30 Deferred Method
14:32 Immediate Method
20:21 Undo, No-undo and Redo