Distributed Database Question Bank with Answers 10

Question:

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

Answer:

In distributed databases the nodes are all handled by the same DDBMS so there is no autonomy for the participating database parts. The local DBA of a database part has some autonomy on the data that are managed locally. All operations at a given site are controlled by that site; no site X should depend on some other site Y for its successful functioning. Local operations are purely local to that site.

In parallel databases the PDBMS has full control and there is no autonomy at all for the participating parts.

In federated databases each database participating in the federation is its own separate database with its own DBMS and has full autonomy.

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

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?

 

questions and answers on Autonomy in distributed database

questions and answers on Autonomy in parallel database

questions and answers on Autonomy in federated database