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
Explain Thomas' Write rule.  Show how it is different from timestamp ordering protol Ans: In timestamp-based concurrency control the thomas Write rule is a rule. Given a Timest

Describe substring comparison in SQL. For the relation Person (name, address), write a SQL query that retrieves the names of people whose name starts along with ‘A' and address co

What is first normal form? The domain of attribute must contain only atomic (simple, indivisible) values.

give some example real-life situations where DBMS are most suiitabe


What is a data dictionary? Data Dictionary is a main source of data in a data management system.  Its major function is to carry the creation and management of data definition


please describe the data base management with the easy example &give the application?

Consider entity type Employee with attributes empNumber (this is unique), empName, and the year when he/she was hired. An employee can either be a technical employee, a marketing e

The result of the UNION operation between R1 and R2 is a relation that includes? The result of the operation between R1 and R2 includes all the tuples of R1 and R2 which have c