Welcome to WebmasterServe!

FREE TO JOIN! Join us now to engage in informative and friendly discussions about Webmastering, SEO, SEM, Internet Marketing, Programming, Graphic Design, Online Jobs and more. What are you waiting for? Ready to join our friendly community? It takes just one minute to register.

Dismiss Notice

Join WebmasterServe Forums 
Join the discussion! Have a better idea or an opinion? It takes just one minute to register Click Here to Join

Help Me/Question Why Checkpoints Are Used In Dbms?

Discussion in 'Database Management' started by krishatg, Mar 12, 2016.

  1. krishatg

    Yellow Belt

    Joined:
    Jan 16, 2016
    Messages:
    240
    Ratings:
    +14 / -0
    Whenever any failure occurd it is required to check the entire log file to determine what is to be undone and what is to be redone which ofcourse is a very daunting task. In order to over come this problem the concept of CHECKPOINTS are used.

    As every transection is recorded in the log file and when checkpoints are used all the transections successfully commited before checkpoint will be moved to the stable storage.
     
  2. Pooja Sharma

    Yellow Belt

    Joined:
    Feb 5, 2016
    Messages:
    373
    Ratings:
    +20 / -0
    A database is a system where all the activities are recorded in the form of logs. It becomes complex to keep track of all the logs together. To reduce this checkpoints were introduced. It saves time as it is not possible to check all the logs at a given point of time.
     
  3. VIVEK KUMAR

    Yellow Belt

    Joined:
    Mar 8, 2016
    Messages:
    300
    Ratings:
    +2 / -0
    Suppose you make a transaction in a ATM machine. Your transaction is in process and in between process machine crash. in this situation check point provide the information about your transaction . check points is the temporary file which maintained during the transaction for preventing inconsistency of data.
     

Share This Page