Advanced Database Management System - Tutorials and Notes: Distributed Database Question Bank with Answers 03

Friday, 1 May 2020

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:


what are the major disadvantages of pipelined parallelism

list some advantages of piplined parallelism in distributed database

No comments:

Post a comment

Featured Content

Multiple choice questions in Natural Language Processing Home

MCQ in Natural Language Processing, Quiz questions with answers in NLP, Top interview questions in NLP with answers Multiple Choice Que...

All time most popular contents