MID - Missing in Data

DM Review, October, 2003 by David Loshin

We were recently asked to evaluate a large data set for data value anomalies as part of an overall data quality assessment that we hoped would establish the business case for senior management's investment in a data quality program. The particular data set we were examining contained a table with address information, and the model reflected a typical instantiation of an address table, with fields named AddrLn1, AddrLn2, City, State, ZipCode, ZipFour and Country. The client's data model had been purchased within the past 10 years.

This table was used to generate addresses for mail correspondence between my client and their customers. As can be expected, one of the more relevant anomalies focused on the difference between a mailing address that could have been composed from...

Read the full article with a Free Trial at MyWire.

Premium Content Partnership | MyWire provides an in-depth online archive library of reference works.