Difference between interoperation and intra operation parallelism
Answers
Explanation:
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
Answer:
Intra-operation parallelism refers to the parallel execution of a single operator and inter-operation parallelism means executing a multiple operators in parallel. The first heavily relies on the data partitioning techniques and the latter is more architectural-dependent.