News for hackers. Stuff that matters.
Re:Comparing Database Types by woolcap on Tuesday September 24, 2019 @01:20PM (#21062446)
> 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

[2] https://en.wikipedia.org/wiki/Relation_(database)

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)
Re:Comparing Database Types by tacotime on Tuesday September 24, 2019 @05:32PM (#21064856)