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.
If I turn the "correct" diagrams sideways, it looks very much like a venn diagram again.