Distributed Database Question Bank with Answers 03

Question:

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

Answer:

Advantage: 
There is no need to write intermediate relations to disk, only to read them back immediately.

Disadvantages:

a. Cannot take advantage of high degrees of parallelism, as typical queries do not have large number of operations.

b. Not possible to pipeline operators which need to look at all the input before producing any output. Examples are the Aggregate and the Sort operators.

c. Since each operation executes on a single processor, the most complex ones take a long time to finish. Thus speed-up will be low in spite of parallelism

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

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?

what are the major disadvantages of pipelined parallelism

list some advantages of piplined parallelism in distributed database