Failure controlling methods, Database Management System

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 recovery techniques as a failure control mechanism?  The recovery methods are somewhat expensive both in terms of memory space and in time for small systems.  In such a case it is more useful to better avoid the failure by some checks instead of deploying recovery method to make database consistent.  Also, recovery from failure includes manpower that can be used in some other productive work if failure can be avoided.  It is, thus, main to find out some general precautions that help in controlling failure. Some of these precautions might be:

  • Having a better secondary storage system like RAID.
  • Having a regulated power supply.
  • Taking periodic backup of database states and keeping track of transactions after every recorded state.
  • setting important integrity checks in the databases as well as user interfaces.
  • Properly testing the transaction programs prior to use etc.

Though, it may be noted that if the database system is significant it must use a DBMS that is suitably equipped with recovery measures.

 

 

Posted Date: 3/12/2013 3:39:23 AM | Location : United States







Related Discussions:- Failure controlling methods, Assignment Help, Ask Question on Failure controlling methods, Get Answer, Expert's Help, Failure controlling methods Discussions

Write discussion on Failure controlling methods
Your posts are moderated
Related Questions
The Incident table, with an auto-incrementing incident number, etc, looks like: incident_num reporter date time incide

Define a relation ? Relation - A relations is a named two-dimensional table of data. Mathematically, a relation can be described as a subset of the cartesian product of a lis

What are the states of transaction? The states of transaction are:- a) Active b) Partially committed c) Failed d) Aborted e )Committed   f) Terminated

Design a gennalization and specialization hierarchy for an automobile sales company

lock and types of lock

what problems are raised by the database? why is it so controversial? why is data quality an issue?

Components of database manager The above functions are reached by the database manager. The major elements of a database manager are: Authorisation control: This mod

Q. Describe how an ER schema can be represented by relation schemas and constraints arising from ER design can be mapped to constraints on a relation schema.     The entity rela

Deadlock Prevention One of the easiest approaches for avoiding a deadlock would be to obtain all the locks at the begin of the transaction. Though, this approach restricts conc

The primary key is selected from the