Before you keep reading...

Runestone Academy can only continue if we get support from individuals like you. As a student you are well aware of the high cost of textbooks. Our mission is to provide great books to you for free, but we ask that you consider a $10 donation, more if you can or less if $10 is a burden.

Support Runestone Academy Today

Before you keep reading...

Making great stuff takes time and $$. If you appreciate the book you are reading now and want to keep quality materials free for other students please consider a donation to Runestone Academy. We ask that you consider a $10 donation, but if you can give more thats great, if $10 is too much for your budget we would be happy with whatever you can afford as a show of support.

Support Runestone Academy Today

13. The Match Join Operator

The most common operation, and the first of the complex binary operators that we will study.

• 13.1. Introduction to Match Join
  • 13.1.1. Times - Filter - Reduce/Project Pattern
  • 13.1.2. The Match Join Operator: an abstract combination
  • 13.1.3. Considering input relations and the columns being matched
• 13.2. Circumstances For Match Joins
  • 13.2.1. How to consider the Symmetry Aspect
  • 13.2.2. Recap
• 13.3. The Common Circumstances
• 13.4. Different Base A and B, M - 1 match over cols Aid(D), Bid(E)
  • 13.4.1. Other Queries to try
• 13.5. Different Base A and B, M - 1 match over cols Aid(D),Bid(M)
  • 13.5.1. Considering NULL values
  • 13.5.2. Exercise
• 13.6. Different Base A and B, M - 1 match over cols Aid(S),Bid(E)
  • 13.6.1. Other Queries to try:
• 13.7. Different Base A and B, M - M match over cols Aid(D),Bid(D)
  • 13.7.1. Other Queries to try:
• 13.8. Same Base A and B, 1 - 1 match over cols Aid(M),Bid(M)
  • 13.8.1. Exercise
• 13.9. Same Base A and B, 1 - 1 match over cols Aid(E),Bid(E)
• 13.10. Same Base A and B, 1 - 1 match over cols Aid(E),Bid(E)
  • 13.10.1. A Different Interpretation
• 13.11. Same Relation A and B, M - 1 match over cols Aid(D),Bid(E)
• 13.12. Same Relation A and B, M - M match over cols Aid(D),Bid(D)
  • 13.12.1. Other Queries to try:
• 13.13. Match Join Framework
  • 13.13.1. M - 1 match over cols between Different Base A and B
  • 13.13.2. M - M match over cols between Different Base A, B
  • 13.13.3. 1 - 1 match over cols between Same Base A, B: chicken feet in
  • 13.13.4. 1 - 1 match over cols between Same Base A and B
  • 13.13.5. M - 1 match over cols between A and itself (Same Relation)
  • 13.13.6. M - M match over cols between A and itself (Same Relation)

You have attempted of activities on this page