Re:Comparing Database Types
by reilly3000 on Tuesday September 24, 2019 @03:42PM
(#21063797)
I 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.
Re:Comparing Database Types
by edmundsauto on Tuesday September 24, 2019 @04:12PM
(#21064128)
Mind sharing the course? Sounds useful.
Re:Comparing Database Types
by reilly3000 on Tuesday September 24, 2019 @10:45PM
(#21067098)
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
[2] https://en.wikipedia.org/wiki/Relation_(database)