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

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

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

c. 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.