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
What is horizontal fragmentation? Horizontal fragmentation divides the relation by assuming every tuple of r to one or more fragments

The Conceptual Level or Global level The conceptual level presents a logical view of the complete database as a unified whole. It permits the user to bring all the data in th

Define the terms i) Key attribute ii) Value set Key attribute: An entity type usually has an attribute whose values are exact from each individual entity in the collection. Su

Isolation or Independence : The isolation property shows that the updates of a transaction should not be visible till they are committed. Isolation assurance that the progresses of

entity relationship diagram about finance

as a customer service employee explain five measures you would recommend to make even a displeased students patronize the school canteen

Describe the GRANT function and explain, how it associates to security. What kind of privileges may be granted? How are they revoked? Ans: Since more than one user can aacce

Define seek time. The time for repositioning the arm is known as the seek time and it enhances with the distance that the arm is known as the seek time.

Define blocks? The database system resides eternally on non-volatile storage, and is into fixed-length storage units known as blocks.