JOINS

 

1PNG

2PNG

I. Objectified foreign key

3PNG

1. Transform foreign key values to records in referenced table

4PNG

5PNG

6PNG

7PNG

8PNG

9PNG

2. Retain nonmatched records only

10PNG

11PNG

II. Normal joins

12PNG

1. Using hashing algorithm

13PNG

14PNG

15PNG

16PNG

17PNG

18PNG

2. Using order-based merge

19PNG

20PNG

21PNG

22PNG

3. Foreign key joins

23PNG

24PNG

25PNG

26PNG

27PNG

28PNG

4. Cross product

29PNG

30PNG

31PNG

32PNG

33PNG

34PNG

5. Joining files

35PNG

36PNG

37PNG

38PNG

39PNG

40PNG

III. Position-based Joins

41PNG

1. Location by sequence numbers

42PNG

43PNG

2. Location by value positions

44PNG

45PNG

46PNG

47PNG

3. Location by field positions

48PNG

49PNG

IV. A join with sequence

50PNG

1. Left join

51PNG

52PNG

53PNG

54PNG

2. Degenerate to cross product

55PNG

56PNG

3. Complicated joins

57PNG

58PNG

59PNG

Click to download the PDF file