Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

Even after reading on Data Scrubbing on Wikipedia, I am still not clear on what Data Scrubbing really is when the term is used for database.

Is it a formal engineering principal that there is a pre-defined way to perform data scrubbing? If so, what is the keyword I should research for?

-- or --

Is it a general or a loose term for simply cleaning inconsistent data in database?

What IS Data Scrubbing?

share|improve this question
up vote 5 down vote accepted

In a database context, it's correction of data which is consistent with the schema but erroneous on a higher level, e.g. invalid credit card numbers and SSNs, duplicate records, format mismatches, and so on.

It is a general, loose term that only acquires specific meaning in a particular case context.

share|improve this answer

I have created "Data Scrubbing" routines to periodically check and fix database problems that may not be practical to check in real-time (i.e. check for errors, inconsistencies, or duplicates as the data is entered). A scrubbing routine can fix specific types of errors such as checking that zip code entry matches the city/state or maybe look for variations of a customers name (duplicate customer), given the address.

Sometimes when a database is de-normalized (for performance reasons), a scrubbing routine can check the database during "off-peak" times to make sure the data remains consistent.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

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