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

Stock market, need requirement analysis for database management of stock ma...

need requirement analysis for database management of stock market

Physical model of traffic data management, After the completion of the logi...

After the completion of the logical model the physical model is to be made. The oracle 10 G will be used as a database server and all the tables with their column are created and i

Explain data abstraction, Explain data abstraction? Data abstraction Da...

Explain data abstraction? Data abstraction Data abstraction is a methodology in which enables us to isolate how a compound data object is utilized from the details of how it is

Distinguish among different kinds of parameters, How can one distinguish am...

How can one distinguish among different kinds of parameters? Input parameters are used to pass data to subroutines. Output parameters are used to pass data from subrout

Data fragmentation in distributed database system, brief history,definition...

brief history,definition,current trends and future trends if any of data fragmentation

In case of entity integrity the primary key may be declared, In case of ent...

In case of entity integrity, the primary key may be declared? In a case of entity integrity primary key may be not Null.

There are two major types of fragmentation, There are two major types of fr...

There are two major types of fragmentation: Horizontal& Vertical. Horizontal fragments, as the name suggests are subsets of tuples and vertical fragments are subsets of attributes

Explain the exec statement in sql, Explain the EXEC statement in SQL A...

Explain the EXEC statement in SQL Ans: All statements which start with EXEC SQL are embedded SQL database statements. High level languages such as C can be employed to write a

What are the benefits of prepared statements, What are the benefits of prep...

What are the benefits of prepared statements and place holders? Parameter binding operations automatically handle escaping of characters Encourage Statement reuse

2phase locking, we need example of 2phase locking

we need example of 2phase locking

Write Your Message!

Name

Email id

Message

Verfication Code

User Account

All Pages