BeginnersBook

  • Home
  • Java
    • Java OOPs
    • Java Collections
    • Java Examples
  • C
    • C Examples
  • C++
    • C++ Examples
  • DBMS
  • Computer Network
  • Python
    • Python Examples
  • More…
    • jQuery
    • Kotlin
    • WordPress
    • SEO
    • JSON
    • JSP
    • JSTL
    • Servlet
    • MongoDB
    • XML
    • Perl

Failure Classification in DBMS

By Chaitanya Singh | Filed Under: DBMS

In DBMS there are several transactions running in a specified schedule. However sometimes these transactions fail due to several reasons. In previous tutorial, we learned how to identify a recoverable schedule. In this guide, we will discuss the types of failures that can occur in DBMS.

Failures in DBMS are classified as follows:

  1. Transaction failure
  2. Underlying System crash
  3. Data transfer fail

1. Transaction Failure

A transaction is a set of statements, if a transaction fails it means there is a statement in the transaction which is not able to execute. This can happen due to various reasons such as:

Logical Error: If the logic used in the statement itself is wrong, it can be fail.

System Error: When the transaction is executing but due to a fault in system, the transaction fails abruptly. For example: Deadlock condition in transaction can result in System error.

2. Underlying System Crash

The system on which the transactions are running can crash and that can result in failure of currently running transactions.

System can crash due to various reasons such as:

  • Power supply disruptions
  • Software issues such as Operating system issues
  • Hardware issues

3. Hard-disk fail

Hard-disk fail can also cause transaction failure. When transactions are reading and writing data into the disk, the failure in an underlying disk can cause failure of currently running transaction. This is because transactions are unable to read and write data in disks due to disk not working properly. This can result in loss of data as well.

There can be several reasons of a disk failure such as: formation of bad sectors in disk, corruption of disk, viruses, not enough resources available on disk.

❮ Recoverability Of ScheduleLog based recovery ❯

Leave a Reply Cancel reply

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

DBMS Tutorial

Basics

  • DBMS Tutorial
  • DBMS Introduction
  • Database Applications
  • DBMS vs File System
  • DBMS vs RDBMS
  • DBMS Architecture
  • Three-level DBMS architecture
  • View in DBMS
  • Abstraction
  • Instance & Schema
  • DBMS languages

Data Models

  • Data Models
  • ER Diagram
  • ER Design issues
  • Convert ER to table
  • DBMS Generalization
  • DBMS Specialization
  • DBMS Aggregration
  • Relational Model
  • Hierarchical Model
  • Constraints
  • Cardinality

Relational Database

  • RDBMS concepts
  • Relational Algebra
  • Relational Calculus
  • Keys Index
  • Primary Key
  • Super Key
  • Candidate Key
  • Foreign Key
  • Composite Key
  • Alternate Key

Normalization

  • Normalization
  • Functional dependency

Transaction Management

  • Transaction Management
  • ACID properties
  • Transaction States
  • DBMS Schedules
  • Serializability
  • Conflict Serializability
  • View Serializability
  • Recoverability Of Schedule
  • Failure Classification
  • Log based Recovery
  • DBMS Checkpoint
  • Deadlock

Concurrency Control

  • Concurrency Control
  • Lock based protocol
  • Timestamp based protocol
  • Validation based protocol

File Organization

  • File Organization
  • Sequential File Organization
  • Heap File Organization
  • Hash File Organization
  • DBMS ISAM
  • B+ File Organization
  • Cluster File Organization

SQL Introduction

  • SQL Introduction
  • SQL Characteristics
  • Advantages of SQL
  • SQL Commands
  • SQL Operators
  • SQL CREATE
  • SQL DROP
  • SQL SELECT
  • SQL INSERT

Copyright © 2012 – 2022 BeginnersBook . Privacy Policy . Sitemap