I am not a royalist, but anyway: Today 16th April 2010 is the 70 years birthday of Queen Margrethe II of Denmark. Congratulations Your Majesty.
Having a queen (or king) and a royal family is a good example of that there are always exceptions. As a matter related to data quality: I would say that every person in our country has a first (given) name and a last (family) name. But the royal family hasn’t a last name – only they have some first names like those of Her Majesty being Margrethe Alexandrine Þórhildur Ingrid. (By the way: The third name is actually Icelandic; I guess that explains the ash cloud sent as a greeting from there.)
There are always exceptions. We may define data quality validation rules from here to doomsday – there will always be exceptions. We may write down business rules from now to eternity – tomorrow you will encounter the first exception. Data quality (and democracy) is never perfect – but it’s worth striving for.
Nice crest – Please say Happy Birthday to Margrethe for me!
Seriously though, you make an excellent point – there will always be exceptions – to every process, not just data quality validation.
We need to include process controls to proactively deal with exceptions (rather than simply ignore them).
For “known” exceptions, we can build exception processing. For the unknown, or unanticipated exceptions, we should flag them, investigate them, and if necessary build exception processing for them.
I agree, we must prepare for exceptions. And we must handle them smoothly and not use all resources on very low frequent events.
To paraphrase Winston Churchill:
“Many forms of Data Governance have been tried and will be tried in this world of defective data and woeful information. No one pretends that Data Quality is perfect or all-wise. Indeed, it has been said that Data Quality is the worst form of Data Governance except all those other forms that have been tried from time to time.”
Great post, Henrik.
Happy Birthday, Queen Margrethe II.
Unmatched paraphrasing from you as ever.