News for hackers. Stuff that matters.

A comment on One million queries per second with MySQL. Parent comment

Re:One million queries per second with MySQL by closeparen on Thursday September 01, 2022 @05:04PM (#32683176)
"Relational" actually refers to tables, not foreign keys. https://en.wikipedia.org/wiki/Relation_(database)
[ Parent | on HN ]
Re:One million queries per second with MySQL by alexvoda on Friday September 02, 2022 @06:24AM (#32688974)
Indeed. Unfortunately the terminology is so easy to confuse. I have heard the term "relationship" used to describe foreign keys to distinguish it from "relation". But usage is inconsistent and everyone who has heard of "relational databases" but has not heard of "relational algebra" and "relational calculus" will think "relational" refers to foreign keys.

Foreign keys are a form of strong typing.

[ Parent | on HN ]
Re:One million queries per second with MySQL by johannes1234321 on Thursday September 01, 2022 @05:30PM (#32683539)
More to "relational algebra" of which joins are a part. (But not necessarily "foreign keys")
[ Parent | on HN ]