Re:Easy Steps to a Complete Understanding of SQL
by chris_wot on Tuesday September 03, 2013 @11:34AM
(#6321518)
Oh, the relational query model based on relational algebra! I thought you wrote "relational model".
For what it's worth, a join is indeed part of relational algebra - it's a composition of binary relations.
What is intuitive to users is the idea of related files/tables, and this really doesn't have much to do with the relational algebra. While we have implemented HTSQL using SQL, this is an implementation choice -- our experiment is syntax/semantics, we didn't want to be in the business of data storage and query optimization, and, we use (the incredibly awesome) PostgreSQL. HTSQL's logical query model depends upon is a tabular based abstract storage.