News for hackers. Stuff that matters.
Re:Say no to Venn diagrams when explaining SQL joins (2016) by Vogtinator on Saturday January 12, 2019 @09:14AM (#18891229)
I really don't see the point here.

If I turn the "correct" diagrams sideways, it looks very much like a venn diagram again.

Re:Say no to Venn diagrams when explaining SQL joins (2016) by 0xfffafaCrash on Saturday January 12, 2019 @10:44AM (#18891617)
Yep: https://i.imgur.com/cgYkQbS.png

I'm drawing the conclusion that some people just need to see arbitrary concrete values to be able to understand what's going on.

Re:Say no to Venn diagrams when explaining SQL joins (2016) by johnNash05 on Wednesday January 23, 2019 @07:05PM (#18984610)
This image isn't opening on my end. Can you please share in another format. You can use https://www.coolutils.com/TotalImageConverter
Re:Say no to Venn diagrams when explaining SQL joins (2016) by _underfl0w_ on Saturday January 12, 2019 @11:04AM (#18891739)
This seems to be more accurate. The primary contribution here is the concrete values.

Otherwise it's literally a square, sideways Venn Diagram. You can turn your phone sideways to confirm.

Re:Say no to Venn diagrams when explaining SQL joins (2016) by Thorrez on Sunday January 13, 2019 @04:00AM (#18895839)
I see that those circles look like a Venn diagram. But for a Venn diagram to be useful in explaining something, there needs to be an easily understandable definition about what the 2 circles are. That doesn't seem to exist here. I can't come up with a logical definition for what the top circle or the bottom circle represent.
Re:Say no to Venn diagrams when explaining SQL joins (2016) by Too on Sunday January 13, 2019 @04:01AM (#18895844)
In a venn diagram the sum of the area combined by A and B can never be larger than A+B.

In a join the result can multiply and you get up to A*B rows instead.

Hence the geometrical representation can mislead you into thinking your data is smaller than what it actually is. As a quick mental model i think the diagrams can help but you have to understand they are only a reminder of how the join is being matched, not a representation of the complete data set.