News for hackers. Stuff that matters.
Re:Comparing Database Types by taffer on Tuesday September 24, 2019 @01:58PM (#21062894)
The table is the relation. A join is just an operation that combines two relations to a superrelation.
Re:Comparing Database Types by Pheebau on Tuesday September 24, 2019 @02:12PM (#21063031)
A join in an intersection in relational algebra
Re:Comparing Database Types by Darkphibre on Tuesday September 24, 2019 @06:41PM (#21065418)
Oh, wow.

I've been in the industry for over 20 years. I even worked on SQL Server Analysis Services for 5 years (up to 256-dimensional 'cubes' in the early 2000s)... and I never thought of joins in this way. Granted, MDX was a beast in its own right.

Cue discussion about self-taught vs college educations. I've got advantages being self-driven learner... but I've definitely missed out in some regards.

Re:Comparing Database Types by greggyb on Tuesday September 24, 2019 @07:57PM (#21066075)
MDX isn't a relational language, though. It's a dimensional language.

The best short description I can give about MDX is that it's the language your pedantic uncle would come up with after falling in love with Ralph Kimball, when all he knew to base it on was SQL.

But the core operations in MDX operate upon hierarchical dimensions and facts that can be aggregated.

    SELECT ... FROM ... WHERE
has no inherent relational semantic. It is simply a syntax that has been standardized upon for interacting with relational database systems. It was also, coincidentally, chosen as the syntax for another language, MDX.

Funny enough, the successor to SSAS Multidimensional is SSAS Tabular, where the query language is DAX. DAX was designed with an explicit goal of looking like Excel's formula language, but it is in fact a relational language which is semantically very similar to SQL, despite looking nothing like it.

Re:Comparing Database Types by namanyayg on Tuesday September 24, 2019 @02:57PM (#21063449)
Not necessarily, it can be a union too? Depends on the type of join.
Re:Comparing Database Types by kthejoker2 on Tuesday September 24, 2019 @09:07PM (#21066555)
A union is not a join at all - a union is a union. They're different concepts entirely.
Re:Comparing Database Types by pas on Wednesday September 25, 2019 @03:33AM (#21068615)
Isn't a full outer join a Descartes product? And thus any other join is just a special case where rows get selected/projected/filtered out?
Re:Comparing Database Types by ithkuil on Wednesday September 25, 2019 @01:51PM (#21073243)
The Cross join is a Cartesian product. Good read: https://en.m.wikipedia.org/wiki/Join_(SQL)