4 ms·
Chapter 3, 'The Structure of the Relational Model', has a helpful background on the origins of table-oriented relational algebra. Unfortunately, it misses the
by mitchtbaum 7y ago
Chapter 3, 'The Structure of the Relational Model', has a helpful background on the origins of table-oriented relational algebra. Unfortunately, it misses the importance of graphs, which afaict, transcend the dependence on tables' bias for normalized topologies of pathologically regular 2D metric spaces, and it even reinforces their relevance by saying, "Intuitively, the data is represented in tables...". Whereas,
> Graphs allow us to build complex, intuitive relationships between data points. Unlike many traditional methods of structuring data, which focus on the format of relationships, graphs focus on the topology of relationships in the dataset.
https://blog.usejournal.com/data-modelling-with-graph-theory-part-1-introduction-f52aaf11f974 https://blog.usejournal.com/data-modelling-with-graph-theory...
When it comes to making database concepts more intuitive, I find visually rich representations very helpful, for example using geometric space-encoded logical relationships to aid diagrammatic reasoning.
It goes along well with many other people's efforts to improve mathematical represenations and interfaces through intuitive visualizations, ie:
https://intuitive-math.club/ https://intuitive-math.club/
http://acko.net/ http://acko.net/
https://www.reddit.com/r/mathgifs/ https://www.reddit.com/r/mathgifs/
https://www.reddit.com/r/visualizedmath/ https://www.reddit.com/r/visualizedmath/
...