Question

Difference between interoperation and intra operation parallelism

Answer 1

Inter-operation parallelism: Execution of different operations of same queery in parallel.

Example: SELECT *FROM Emp WHERE Salary >5000 ORDER BY NAME; In this example we perform two operations:

a.Scan Emp table for salary>5000

b. Sort all the Emp records on Name attribute Now we may use two processors, one to scan the table, and other to perform sortinng Intra-operation parallelism: Execution of single operation of a query in parallel.

Example: SELECT*FROM customer ORDER BY cNAME Let us assume that we have ten million customers.

For such a huge number of records sorting would consume a considerable amount of time.

Hence, we would divide all the customer records into n parallel servers and each can perform sorting on the assigned records.