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
What are the advantages of DBMS ? 1. Centralized Management and Control - One of the major advantages of using a database system is in which the organization could exert, thr

Multiple column Queries: Syntax: SELECT COLUMN1, COL2,...... FROM TABLE WHERE (COLUMN1, COL2, ...) IN (SELECT COLUMN1, COL2,....  FROM TABLE WHERE );

Surgeons identified by doctor ID (DOCID) operate on patients identified by patient ID (PATID) in operating theaters identified by room numbers (ROOMNO). Each surgeon can operate on

Define the term Domain. For each n every attribute there is a set of permitted values known as the domain of that attribute.

Question 1 Explain the 10 reasons to use MySQL Question 2 Write the SQL statements to demonstrate the following using SELECT command Expression Evaluation ORDER BY

Differentiate between horizontal & mixed horizontal fragmentation?

Aggregation Aggregation is stronger form of association. It represents the "has-a" or "part-of" relationship. An aggregation association depicts a complex object which is comp

Discuss the term- Design Optimization  We have seen various ways of representing the objects.The fundamental design model uses analysis model as the framework for implementati

Inconsistent Analysis : The problem as given with transactions T1 and T2 where two transactions interleave to make incorrect result during an analysis by Audit is the instance of s

One-way Associations When an association is traversed only in the one direction, then it is implemented as a pointer i.e.an attribute which contains an object reference. If mu