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
Ask q“A database will be made to store information about patients in a hospital. On arrival, each patient’s personal details (name, address, and telephone number) are recorded wher

Define the terms 1) physical schema 2) logical schema. Physical schema: The physical schema explains the database design at the physical level, which is the lowest level of abs

The database application project (DAP) for this assignment consists of the creation of a fully functional Microsoft Access database application for a real client. I recommend you s

Submit SQL INSERT Statements that will populate the database with sample data.  You must insert at least 5 records into each table in your database.Submit your SQL INSERT Statement

A field-groups statement or an insert statement reverses storage space and transfers values. False.

Create a table according to given data:  AmbulanceDriver(Driver_Number#, Name, Address, Birth_Date) AmbulanceDriverTeam(Team_Number#, Driver_Number#, Join_Date, Lea

Write short notes on domain relational calculus   The domain relational calculus uses domain variables that take on values from an attribute domain rather than values for whole

What Count function return in SQL? Count function within SQL returns the number of values. (Count function counts all the not null values in the exact column. If we need to cou

Express the ways provided by MySQL for Pattern Matching? MySQL provides two kinds of pattern matching. 1) One is based on SQL patterns 2) Regular expressions.

Explain Clustering file organization (i) Determine if a record of file is physically ordered on a nonkey field - that does not comprise a different value for each record - that