4 ms·
> Perhaps this is in reference to nested data structures If you have nested data structures then it violates 1NF, i.e. the data isn't normalised. Any "pure" R
by chippiewill 5y ago
> Perhaps this is in reference to nested data structures
If you have nested data structures then it violates 1NF, i.e. the data isn't normalised.
Any "pure" RDBMS won't even be able to represent that denormalised data in a table, let alone query it with SQL. Normally this is worked around by straight up serialising it. Obviously some implementations have extensions, like Postgres has JSON columns.
- e-master 5y agoTo be honest, I’m unsure how many ‘pure’ RDBMS are out there, and doesn’t seem like the parent comment had them in mind. I’d rather suggest that mainstream RDBMS in general don’t have trouble working with data formats such as json or xml. SQL Server for one has no trouble querying into deeply nested XML/JSON columns and it does it surprisingly quickly based on my experience.
- maweki 5y agoAs there are various degrees of "not normalized", this was a very valid question (and answer). SQL databases do indeed work with data not in Boyce-Codd-Normal-Form. :D
- user3939382 5y agoYes, MySQL also has functions dedicated to traversing and selecting JSON