Chapter 22, Problem 1PE

Explanation of Solution

Inter-Query Parallelism:

When different transactions or queries get executed in parallel then it is called as inter-query parallelism.

Inter-operation Parallelism:

When different operation for a single query executes in parallel on a multiple disks and processors then it is called as inter operation parallelism.

Intra-operation parallelism:

When each and every operation that takes place in a query are parallelized then it is called as intra query operation parallelism.

a)

Increasing the throughput of the system:

• In order to increase the throughput of the system that operates with many small queries inter-query parallelism can be utilized.
• Parallelizing each of the queries will result in the increased initiation overhead while no significant improvement are be identified with the response time.
• So, Parallelizing is avoided and use of inter-query parallelism is recommended.

Explanation of Solution

Inter-Query Parallelism:

When different transactions or queries get executed in parallel then it is called as inter-query parallelism.

Inter-operation Parallelism:

When different operation for a single query executes in parallel on a multiple disks and processors then it is called as inter operation parallelism.

Intra-operation parallelism:

When each and every operation that takes place in a query are parallelized then it is called as intra query operation parallelism.

b)

Increasing the throughput of the system:

• In order to increase the throughput of the system that operates with few large queries intra-query parallelism can be utilized because it will provide a better response time.
• Intra query parallelism will provide more advantage when large number of disks and processors because these queries are considered to have fewer operations but each one of them will need to process large number of records.