1

I understand that "data sanitization" mainly deals with cleaning user-entered data to prevent harmful effects (e.g. SQL injection), but what about other forms of cleaning data? E.g., trimming whitespace from text or removing leading zeros from numbers. Do these also fall under "data sanitization"? If not, what is this type of data cleaning called?

2

Canonicalization

In computer science, canonicalization (sometimes standardization or normalization) is a process for converting data that has more than one possible representation into a "standard", "normal", or canonical form. This can be done to compare different representations for equivalence, to count the number of distinct data structures, to improve the efficiency of various algorithms by eliminating repeated calculations, or to make it possible to impose a meaningful sorting order.

  • Normalization is a word my colleagues will probably know as well. Perfect! :) – Protector one Dec 19 '14 at 13:37
  • Normalisation is the norm here too. – tom Dec 19 '14 at 13:47

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.