Heterogeneous ddb and homogeneous ddb, Database Management System

Assignment Help:

Probelm:

(a) A distributed database (DDB) is a collection of multiple, logically interrelated databases which are physically distributed over a computer network"

(i) Give advantages of a Distributed Database as compared to a centralised database.

(ii) Differentiate between a Heterogeneous DDB and Homogeneous DDB and describe under what circumstances would such systems generally arise?

(iii) Show the advantages of having data replicated at various sites.

Related Discussions:- Heterogeneous ddb and homogeneous ddb

How nulls are treated in comparison operator, How nulls are treated in comp...

How nulls are treated in comparison operator? Along with comparison (relational) operators, the null values are ignored as we cannot derive the relation along with the given op

Dataset, The dataset " CFOLYMPICS.XLS " contains the observations used in t...

The dataset " CFOLYMPICS.XLS " contains the observations used in the above article. The definitions of the variables are also included in this spreadsheet. However, for the purpo

Cataloguing, differences between a classified catalog and a dictionary cata...

differences between a classified catalog and a dictionary catalog

Define the term database, QUESTION (a)(i) Define the term database. ...

QUESTION (a)(i) Define the term database. (ii) How is it different from a database management system? (b) What is the difference between an entity and an attribute? (c

Generalization and specialization, design a generalization specialization h...

design a generalization specialization hierarchy for a motor vehicle sales company. the company sells motorcycles, passenger cars, vens and buses.

Mapping, external and internal mapping with examples

external and internal mapping with examples

Include the create database command, Submit the SQL Statements necessary to...

Submit the SQL Statements necessary to create your database according to the following guidelines: Your SQL statements should exactly mirror your ERD. All primary keys,

How many types of users works on database, How many types of users works on...

How many types of users works on database? Users are differentiated through the way they expect to interact along with the system (i) Application programmers-interact with

Improved reliability, Improved Reliability: In a centralised DBMS, a server...

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 cr

3NF Normalization, Need 2 projects completed in 3NF format.

Need 2 projects completed in 3NF format.

Write Your Message!

Name

Email id

Message

Verfication Code

User Account

All Pages