Suppose you wish to handle a workload consisting of a large number of small tran

Question

Suppose you wish to handle a workload consisting of a large number of small transactions by using shared-nothing parallelism.

Is intraquery parallelism required in such a situation? If not, why, and what form of parallelism is appropriate?

What form of skew would be of significance with such a workload?

Suppose most transactions accessed one account record, which includes an account type attribute, and an associated account type master record, which provides information about the account type. How would you partition and/or replicate data to speed up transactions? You may assume that the account type master relation is rarely updated.

Suppose you wish to handle a workload consisting of a large number of small transactions by using shared-nothing parallelism.

Is intraquery parallelism required in such a situation? If not, why, and what form of parallelism is appropriate?

What form of skew would be of significance with such a workload?

Suppose most transactions accessed one account record, which includes an account type attribute, and an associated account type master record, which provides information about the account type. How would you partition and/or replicate data to speed up transactions? You may assume that the account type master relation is rarely updated.

Explanation / Answer

Yes, we can use the shared nothing architecture as for the sake of handling a large number of transactions going in parallel. For this we need both scale-up and speedup in parallelism.

Now question arises that what kind of parallelism to be used so we can say that for linear scale-up it is better to use interquery parallelism because it is mainly used for the handling of this much workload but processing speed is lesser in it and also it uses shared memory architecture.

So it is nearly better to use intraquery parallelism uses shared nothing architecture so we get both linear scale-up and speedup also the ingredient parallelism work in two ways that is intraoperation and interpretation and this can work in all of the architecture.

Hope that I fulfilling your answer.

Related Questions

Navigate

• Browse (All)
• Browse S
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.