Recovery techniques, Database Management System

Recovery Techniques:After Reading the types of failures and database errors, let us talk about how to recover from the failures. Recovery can be complete using/restoring the previous consistent state (backward recovery) or by moving forward to the next consistent state as per the committed transactions recovery (forward recovery).  Please note that a system can recover from software and hardware failures by using the forward and backward recovery only if the system log is intact.  What is the system log? We will talk about it in more detail, but first let us describe forward and backward recovery.

 

Posted Date: 3/12/2013 5:09:40 AM | Location : United States







Related Discussions:- Recovery techniques, Assignment Help, Ask Question on Recovery techniques, Get Answer, Expert's Help, Recovery techniques Discussions

Write discussion on Recovery techniques
Your posts are moderated
Related Questions
1. Which model is used to store data in tree structures Ans: Hierarchical model is used to store data in tree structures

What are stored and derived attributes? Stored attributes: The attributes keeps in a data base are known as stored attributes. Derived attributes: The attributes that are de

Self-Join:   In a self join a table is joined with itself.  Let consider the following sample partial data of EMP table EMPNO ENAME MGRID

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

Part 1: Security Plan Consider the Case study and identify 3 security requirements. For each of these security requirements: • Discuss the necessity for the feature and how

#question. acompani datdbase needs to store information about employees (identified by a social security number,with salary and phone as attributes) and departments (identified by

Create centralized relational database using bottom up method.   (a) Recognize a single un-normalized relation for the above scenario.          (b) Recognize the primary key for


Define Direct file organization? The direct file organization is employed to enhance the performance in accessing the records than sequential file organization. In direct file

Write a short note on built in function in QBE? Built in function in QBE: QBE involves various built in functions like AVG, MAX,MIN,SUM and CNT. We must prefix these operator