Set operations

 

1PNG

2PNG

I. When members are basic data types

3PNG

1. Concatenation

4PNG

5PNG

2. Intersection

6PNG

7PNG

3. Union

8PNG

9PNG

4. Difference

10PNG

11PNG

5. XOR

12PNG

13PNG

6. Operation on more than two sets: Concatenation

14PNG

15PNG

16PNG

17PNG

6. Operation on more than two sets: Union & Difference

18PNG

19PNG

6. Operation on more than two sets: Intersection

20PNG

21PNG

22PNG

6. Operation on more than two sets: XOR

23PNG

24PNG

II. When members are records

25PNG

1. Reference eligible records directly

26PNG

27PNG

28PNG

29PNG

30PNG

31PNG

32PNG

2. Merge sets by certain fields

33PNG

34PNG

35PNG

36PNG

37PNG

38PNG

39PNG

40PNG

41PNG

42PNG

43PNG

3. Merge sets by the primary key

44PNG

45PNG

4. Merge sets by all fields

46PNG

47PNG

5. When records are not ordered by the key

48PNG

49PNG

III. Big data operations

50PNG

1. Concatenation of sets

51PNG

52PNG

53PNG

54PNG

2. Merge sets by column values

55PNG

56PNG

57PNG

58PNG

59PNG

Click to download the PDF file