3 ms·
This completely tangential, but any time I see someone talking about normalizing a database, I briefly think they are talking about doing something like: x/|x|
by bee_rider 4y ago
This completely tangential, but any time I see someone talking about normalizing a database, I briefly think they are talking about doing something like:
x/|x|
Ya know, like normalizing a vector. Of course this brief confusion doesn't matter, I sort it out quickly, and it is totally clear language to other database people -- it is just a funny quirk of overloaded lingo.
But I wonder if as big data and machine learning folks (since there's some overlap with Linear Algebra there) ever get their lingo mixed up.
"To predict where the ridesharing customers will want to go, we will apply the taxicab norm to our database."
- adepressedthrow 4y agoWhile the overloading is annoying, database normalization actually has a strict definition that is not unlike the standard mathematical use; that is, to imply consistency (to make normal): https://en.wikipedia.org/wiki/Database_normalization https://en.wikipedia.org/wiki/Database_normalization I would also point out that normalization within mathematics does not have a single concrete definition either, and it depends on your domain and desired property to stabilize: https://en.wikipedia.org/wiki/Normalization_(statistics) https://en.wikipedia.org/wiki/Normalization_(statistics)
- bee_rider 4y agoJust to be clear -- I'm not annoyed really, I actually find these little momentary confusions to be a charming little quirk of our language. And I think it is not a big deal anyway, 99% of the time we're talking inside our fields where it is obvious what we mean.