- If it is a case of execution of two or more transactions, the interleaving of logs will occur. It will become very inconvenient for the system of recovery to backtrack every record and start the process of recovering.
- Most database management systems make use of the concept of “checkpoint” to make the situation more convenient and more manageable.
The idea of “checkpoint” has already been extensively discussed under the Transaction Processing part of the tutorial. So, please, take your time and revise the concepts before proceeding further with the theories of DBMS.
