Software failures-database recovery and security, Database Management System

Software failures:  In such cases, a software error abruptly stops the implementation of the current transaction (or all transactions), therefore leading to losing the state of program implementation and the contents / state of the buffers.  But what is a buffer? A buffer is the portion of RAM that kept the partial contents of database that is currently needed by the transaction. The software failures can further be subdivided as:

a)   Application or Statement program failure

b)   DBMS software failure

c)   Failure due to viruses

d)   Operating system failure

A Statement of program may cause abnormal termination if it does not implement totally.  This happens if during the implementation of a statement, an integrity constraint gets desecrated. This leads to irregular termination of the transaction because of which any prior updates made by the transaction may still get reflected in the database going it in an inconsistent state.

A failure of transaction can happen if some code in a transaction program leads to its abnormal termination. For instance, a transaction can go into an infinite loop.

In such a case the only technique to break the loop is to abort the program.  Likewise, the failure can be traced to the DBMS or operating system and transactions are aborted abruptly. Therefore part of the transaction that was implemented before abort may cause some updates in database, and therefore the database is updated only partially which leads to an inconsistent state of database.

Posted Date: 3/12/2013 3:33:26 AM | Location : United States







Related Discussions:- Software failures-database recovery and security, Assignment Help, Ask Question on Software failures-database recovery and security, Get Answer, Expert's Help, Software failures-database recovery and security Discussions

Write discussion on Software failures-database recovery and security
Your posts are moderated
Related Questions
How external/conceptual mapping and conceptual /internal mapping is performed

Explain the function of Object model Object model describes the classes of objects in system, including their attributes and operations which they support. The analysis object

User error :  This contains errors in the program (e.g., Logical errors) with errors made by online users of database.  These types of errors can be avoided by applying some check

Failure Controlling Methods: Failures can be handled using different recovery methods that are talk about later in the unit. But the first question is doing we really require recov

Which data type can store unstructured data? Raw data type can store unstructured data.

Which model is record based logical model? Network Modelis basically known as record based logical model.

What is De-normalization? De-normalization is the method of attempting to optimize the performance of a database by adding redundant data. It is sometimes essential because cur

What is OMR? OMR (Optical Mark Recognition) is the translation of marks - or the absence of marks - but not the shape of the mark on forms that have small circles ("also called

Explain recovery process after system failure using checkpoint. Ans: Checkpoint scheme or method is an extra component of the log based recovery system. This scheme is used to

Need a sample of a clinic database relationships