3 ms·
Yet a relational database in 5th normal form is equivalent to a RDF-Like first order Triple graph. A lot of network databases store graphs as pointer-bogs whic
by j-pb 5y ago
Yet a relational database in 5th normal form is equivalent to a RDF-Like first order Triple graph.
A lot of network databases store graphs as pointer-bogs which are hard to process and query, but that does not diminish the virtues of the graph model itself or preclude a representation based on joins.
I'd argue that a 5th normal form graph representation contains a lot less implementation detail and is a lot more flexible than a regular old buch of tables.
- AlecSchueler 5y agoCould you recommend some resources for reading more/learning about Nth normal forms?
- alex_anglin 5y agoWikipedia is a good start: https://en.wikipedia.org/wiki/Database_normalization https://en.wikipedia.org/wiki/Database_normalization
- zozbot234 5y ago> Yet a relational database in 5th normal form is equivalent to a RDF-Like first order Triple graph. Not quite. The definition of 5NF depends on real-world constraints on valid combinations of attributes in the database; it has nothing to do with any pre-defined data model such as RDF. There can be "wide", horizontally-modeled tables (quite unlike the RDF model) which are in 5NF simply because no real-world constraints apply to the data beyond those that are implied by the candidate keys.
- brightball 5y agoWow. First time I’ve heard of a normal form above 3rd. Guess I need to read up.
- HideousKojima 5y agoFWIW, there's very little practical reason to normalize your DB beyond the third normal form (or technically the Boyce-Codd normal form, which your DB will probably already meet if it's in 3NF)
- jbritton 5y agohttp://graphdatamodeling.com/resources/rettigNormalizationPoster.pdf http://graphdatamodeling.com/resources/rettigNormalizationPo...