Improved reliability, Database Management System

Improved Reliability:In a centralised DBMS, a server failure stops the operations of the DBMS. Though, a failure at single site of a DDBMS, or a failure of a communication link creation some sites inaccessible, does not make the whole system inoperable. Distributed DBMSs are designed to continue to function despite such as failures. In particular, if data are replicated in various sites, a transaction requiring a particular data item may find it at various sites. Therefore, the failure of a site does not necessarily imply the shutdown of the system.

The failure of one site must be identified by the system, and appropriate action may be required to recover from the failure. The system has no longer used the services of the failed site. At last, when the failed site recovers or is repaired, mechanisms have to be available to integrate it smoothly back into the system. The recovery from failure in distributed systems is much more difficult than in a centralised system.

 

Posted Date: 3/12/2013 5:54:49 AM | Location : United States







Related Discussions:- Improved reliability, Assignment Help, Ask Question on Improved reliability, Get Answer, Expert's Help, Improved reliability Discussions

Write discussion on Improved reliability
Your posts are moderated
Related Questions
why shadow copy technique is used?

Convert the following ER - diagram (Entity Relationship Diagram) into a relational database (the primary keys are underlined): 2160_Convert the following ER - diagram into a

Have database built but having problems with some questions that go with the database


Explain the Exec statement in SQL Ans: Exec statement has the structure    EXEC SQL END-EXEC   Embeded SQl statements are of a form identical to non embedded SQL statem

Concatenation operator Example : Printing name and job as one string as column name employees: SELECT ENAME||JOB "EMPLOYEES" FROM EMP;

Question: In a multi-user database environment, locking mechanisms can be used to solve the three basic problems of concurrency. On the other hand, however, locking may also le

Explain the EXISTS and UNIQUE functions of SQL. Give an example for each? EXISTS: The EXISTS function takes one parameter that is a SQL statement. If any records exist which

Examine about the Behavioural Diagrams  The main objective of behavioural diagrams is to visualize, specify, construct and document dynamic aspects of a system. The interactio

What is RDBMS terminology for a row? A tuple is a RDBMS terminology for a row