JOIN as a diagram

Discipline

Databases

Form

Visual Representation

Attribution — Origin / Source

Collected by Daphne Miedema — Garcia-Molina, H., Ullman, J., & Widom, J. (2009). Database Systems: The Complete Book. 2 ed. Prentice Hall Press, Upper Saddle River, NJ, USA.

Topic

Query languages (basic)

Domain

Within-Database

Conceptual Advantage

Visualizes how the JOIN looks at intersections in data

Mapping

SymbolConcept
boxes relations / tuples
vertical lines attributes

Draws Attention To

The construction of joined tuples (in terms of attributes)

Comments or Feedback?

Do you have feedback on this notional machine? Did you find a mistake, or do you have a request for improvement? You can create an Issue on GitHub, where the description is hosted. This way we can see your feedback and address it.

For this, you need a GitHub account. Then follow this link to see the source file of this page. In there, click the ... left of the highlighted line, then pick "Reference in a new issue".

Create an Issue on GitHub