3 ms·

Normalization is important for deduplication, not only to index and compare a few short numbers instead of a few long string: those host names and email address

Normalization is important for deduplication, not only to index and compare a few short numbers instead of a few long string: those host names and email addresses are long and often repeated.

remram 5y ago
That's not what normalization is. You're thinking of deduplication or compression. This table is normalized as per usual database terminology.
- ghayes 5y ago
  But if it’s guaranteed to be 1:1, why? The two implementations (normalized and denormalized) in that case should be completely isomorphic, quirks of the DB engine aside.
  - remram 5y ago
    Why what? I don't understand what you are asking.