Distributed Database Question Bank with Answers 07

Question:

Explain the differences between distributed, parallel, and federated databases

Answer:

A distributed DBMS (DDBMS) is a DBMS where different parts of the database is located at different geographic locations (i.e. in several different computers or clusters) but where each part of the database is managed by local instances of the same DDBMS.

A parallel DBMS (PDBMS) is a single DBMS running on a single cluster where the PDBMS engine automatically decides how data is distributed and queries parallelized.

A federated DBMS (FDBMS) is a middleware DBMS that combines data from several different autonomous underlying DBMSs. SQL queries to the FDBMS are more or less automatically translated into queries to the underlying DBMSs.

**********************

Related Questions:

• Go to Distributed Database Quiz Questions Home page
• Go to Distributed Database Home page

• What is a distributed database? What is it not? If all sites use a DBMS from the same vendor, what do we call it?

• List two ways to measure the time improvement when processing a query using parallel architecture? Why is linearity important

• Describe the main advantage of pipelined parallelism and some of its drawbacks.

• When and why is replication favorable in a distributed database?

• When and why is fragmentation favorable in a distributed database?

• Compare and analyze the relative merits of centralized and hierarchical deadlock detection approaches in a distributed DBMS.

• Explain the differences between distributed, parallel, and federated databases

• What different kinds of transparencies are handled by distributed, parallel, and federated databases?

• List few situations in which adaptive query processing is beneficial.

• How is autonomy handled by distributed, parallel, and federated databases?

 

Differentiate between distributed, parallel and federated databases

What are the major differences between distributed, parallel and federated databases

List the differences in distributed database