Database Recovery System: Classification of Failures

Failure refers to the state when system can no longer continue with its normal execution and that results in loss of  information. Different types of failure are  as follows:

  1. System crash : This failure happens due to the bugs in software or by hardware failure etc.
  2. Transaction failure : This failure happens due to any logical error such as overflow of stack, bad input, data not found, less free space available , or by system error such as deadlocks etc.
  3. Disk failure : This failure happens due to head crash, tearing of tapes, failure during transfer of data etc.

Source: Gupta Satinder Bal, Mittal Aditya (2017), Introduction to Basic Database Management System, 2nd Edition-University Science Press (2017)

Leave a Reply

Your email address will not be published. Required fields are marked *