Already have an account? Get multiple benefits of using own account!
Login in your account..!
Remember me
Don't have an account? Create your account in less than a minutes,
Forgot password? how can I recover my password now!
Enter right registered email to receive password!
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.
Explain the ANSI SPARC architecture The three-schema architecture is as well known as ANSI SPARC architecture. The aim of the three-schema architecture is to separate the user
What is Oracle Process? Explain any four processes started by Oracle. Oracle Process is as follows: SMON: The System Monitor carries out a crash recovery while a crashed in
Determine the Strong and Weak Entity Based on the method of foreign key, there might be arise a situation when we have to relate an entity having a primary key of its own and a
Have database built but having problems with some questions that go with the database
properties of derirable decomposition
Funky Festivals Specification Funky Festivals organise music festivals which take place at various venues throughout the UK. A venue needs to be booked before a Festival can t
What does the extract statement do in extract datasets? The data is written to virtual memory by extract commands.
What are the various properties of Relational tables? Relational tables have 6 properties: 1. Each row is unique. 2. Column values are of the same kind. 3. Values are
What is a homogeneous distributed database? In homogeneous distributed databases, all sites have the same database management system software, are aware of one another, and agr
What are the basic objects of the data dictionary? Tables Domains Data elements Structures Foreign Keys
Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!
whatsapp: +91-977-207-8620
Phone: +91-977-207-8620
Email: [email protected]
All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd