3 ms·
> Relational databases get their name from the fact that relationships can be defined between tables. Relational databases get their name from the mathematical
by woolcap 7y ago
> Relational databases get their name from the fact that relationships can be defined between tables.
Relational databases get their name from the mathematical concept of a relation, used by the Relational Model, "an approach to managing data using a structure and language consistent with first-order predicate logic, first described in 1969 by English computer scientist Edgar F. Codd, where all data is represented in terms of tuples, grouped into relations." [1][2] (emphasis added)
Recommended Reading: Database In Depth, by Chris Date.
[1] https://en.wikipedia.org/wiki/Relational_model https://en.wikipedia.org/wiki/Relational_model
[2] https://en.wikipedia.org/wiki/Relation_(database) https://en.wikipedia.org/wiki/Relation_(database)
- reilly3000 7y agoI did a MOOC on relational algebra that made me much more productive in SQL and better appreciate the gravity of what RDBMS really offer. Understanding relational algebra helps demystify the magic or query planners and grok why they both add and reduce latency based on use cases.
- edmundsauto 7y agoMind sharing the course? Sounds useful.
- tacotime 7y agohere is one: https://lagunita.stanford.edu/courses/DB/RA/SelfPaced/about https://lagunita.stanford.edu/courses/DB/RA/SelfPaced/about
- reilly3000 7y agohttps://www.coursera.org/learn/data-manipulation https://www.coursera.org/learn/data-manipulation