How do we perform Duplicate data elimination, Projection, and Aggregation in parallel in parallel database system?
|Figure 1 - Partitioning Employee table|
- When we would like to count the number of unique values present in a table under a particular attribute.
- When we need to retrieve the values and present only the unique values of an attribute.
- When we need to join two tables, etc.