Structural Differences and Data Matching

Blog Administrator | Address Quality, Address Standardization, Data Cleansing, Data Enhancement, Data Enrichment, Data Governance, Data Integration, Data Management, Data Matching, Data Quality, Duplicate Elimination, Fuzzy Matching | , , ,

By David Loshin

Data matching is easy when the values are exact, but there are different types of variation that complicate matters. Let’s start at the foundation: structural differences in the ways that two data sets represent the same concepts. For example, early application systems used data files that were relatively “wide,” capturing a lot of information in each record, but with a lot of duplication.
Read More

In a Global Economy, a Global Solution is Vital

Melissa Team | Address Quality, Address Standardization, Address Validation, Data Integration, Data Management, Data Quality, International Address Verification | , , , , ,

By Patrick Bayne
Data Quality Tools Software Engineer

Heidelberglaan 8
3584 CS Utrecht

If you were given this address, how would you know it was valid? Is it formatted
correctly? How long will it take you to verify? For years businesses have
understood a need for address validating solutions, because clean, accurate data
is essential.… Read More

Address Quality – Take 2

Blog Administrator | Address Correction, Address Quality, Address Standardization, Analyzing Data, Data Cleansing, Data Management, Data Quality, Postal Address Standards, USPS | , , , , , , , , ,

By David Loshin

We have dealt with some of our core address quality concepts, but not this one:

The intended recipient must be associated with the deliverable address.

The problem here is no longer address quality but rather address
correctness
.

Read More

Postal Standards and Address Quality – Take 1

Blog Administrator | Address Correction, Address Quality, Address Standardization, Address Validation, Analyzing Data Quality, Data Quality, Postal Address Standards, USPS | , , , ,

By David Loshin

The USPS Postal Standard (Publication 28) provides at least some of the specifications we need for address quality. For example,

 “The Postal Service defines a complete address as one that has all the address elements necessary to allow an exact match with the current Postal Service ZIP+4 and City State files to obtain the finest level of ZIP+4 and delivery point codes for the delivery address.”

Read More

Where in the End-to-End Should Address Standardization and Correction Happen?

Blog Administrator | Address Standardization, Address Validation, Data Management, Data Quality | , , , , , ,

By David Loshin

In my last post, I shared a story about how rampant address validation actually can transform accurate (if not 100% standardized) addresses into inaccurate ones. My client actually noted that with some of the tools they have seen, addresses that have been submitted to the product and standardized are then re-submitted to the product, which then reports their own corrected address as being invalid!
Read More