1.

What do you understand by a checkpoint in Database Management Systems?

Answer»

The Checkpoint in Database Management Systems (DBMS) is a TECHNIQUE that removes all previous logs from the system and stores them permanently on the storage drive. Preserving the log of each TRANSACTION and maintaining shadow pages are two methods that can assist the DBMS in recovering and maintaining the ACID PROPERTIES. When it comes to a log-based recovery system, checkpoints are NECESSARY. Checkpoints are the MINIMAL points from which the database engine can recover after a crash as a specified minimal point from which the transaction log record can be utilised to recover all committed data up to the moment of the crash.



Discussion

No Comment Found