It's considered to be "`exotic`, `academic`, `never used in practice`, etc., etc." because for some reason most of the DB people believe that 1 relation in the data model should map to exactly 1 table/B-tree in the database — and of course, the 6NF then becomes ridiculous.
But the relational model from the very beginning was about abstracting the concerns about how, exactly, those relaltions are supposed to be implemented/stored, and concentrating more on the conceptual API for querying.
gnat•1h ago
The newsletter this is from is full of very clear writing about SQL, practically applying theory without getting lost in a tangle of database theory jargon. If you need to read or write SQL then I think you’ll find it as interesting as I have.
Joker_vD•1h ago
But the relational model from the very beginning was about abstracting the concerns about how, exactly, those relaltions are supposed to be implemented/stored, and concentrating more on the conceptual API for querying.