✳flâneur — a map of the web's best reading

Iterators and Joins | Database Systems

cs186berkeley.net · 3,924 words · saved by 1 readers

Online textbook for CS186, Berkeley’s Database Systems course.

Iterators and Joins - Database Systems Iterators and Joins | Database Systems Search Menu Expand Document Database Systems Save this note as PDF Introduction Let’s begin with the simplest question: what, exactly, is a join? If you remember the SQL project, you’ll remember writing things like R INNER JOIN S ON R.name = S.name and other similar statements. What that actually meant is that you take two relations, R and S , and create one new relation out of their matches on the join condition – that is, for each record \(r_i\) in R , find all records \(s_j\) in S that match the join condition we

Explore this link on the map →

related reading