Comment on How does this pic show that Elon Musk doesnt know SQL?
h4x0r@lemmy.dbzer0.com 1 year ago
I think a lot of comments here miss the mark, it’s not really just about stating the gov does not use SQL.
Deduplication is generally part of a compression strategy and has nothing to do with SQL. If we’re being generous he may have been talking about normalization, but no one I have ever met has confused the two terms (they are distinctly different from an engineering perspective).
There are degrees of normalization too, so it may make total sense to normalize 3NF (third normal form) rather than say 6NF.
Thats interesting. I didn’t know anything about normal forms, but a quick glance at G4G has some interesting information. I don’t have the time to go through their full article at the moment, but its been added to my to do list.
Link for the lazy: geeksforgeeks.org/types-of-normal-forms-in-dbms/
whotookkarl@lemmy.world 1 year ago
This is it, relational databases are normalized under forms, deduplicate is usually a term used when talking about a concrete data set from data sources like a database, not the relational data model in the database itself.