The Art of Data Matching

One of my specialties in Data Quality is Data Matching.

Data Matching is about linking – and eventually also splitting before linking – entities in or between databases, where these entities are not already linked with unique keys.

Matching is most often done with Master Data, but matching is also practiced with Transaction Data and by matching Transaction Data to Master Data. Here I like this definition:

  • Transaction data accurately identifies who, what, where and when and…
  • Master data accurately describes who, what and where

Matching party data – names and addresses – is the most common area where Data Matching is practiced and a lot of tools are available. Matching includes:

  • Deduplication
  • Match with external reference data and
  • Identity Resolution.

Please find more detailed information here:

Doing business directory matching has been a focus area of mine including making a solution for match with the D&B worldbase.

The sub disciplines of data matching are further described in posts about:

Product directory matching and deduplication is also widespread. An example is described in the post Matching Light Bulbs.

Besides these areas a lot of industry specific Data Matching is going on.

A 20 minutes free webinar on eLearningCurve explains it all here. Also, I was a guest on OCDQ Radio explaining the art of data matching.

Data Matching may be deployed in some different ways, where I have been involved in the ones described in the post Deploying Data Matching.

goalIf you are interested in Data Matching you may join the LinkedIn group on this matter – as the group manager I will be happy to approve your membership.  Click on the logo to the left.

Also Wikipedia has an article on Data Matching under the term Record Linkage.

Note: This page and underlying pages will be enhanced over time.

Bookmark and Share

2 Responses to The Art of Data Matching

  1. lydie says:

    Could you provide verification service on companies import product?

    I will explain the details of Product verification project.

    Requirements: Verify that the target company currently imported product name or category.

    Original data: company name, purchase products, contact information.

    Requirements: by phone, email, import and export agency surveys, market surveys conducted purchased product.
    We will provide you with these companies’ imported products previously as a reference, specific information about this article productEN and KW bar display. You need to make sure they are still doing such imports now or what products are being imported and recorded. If the firm is a manufacturer, confirm whether certain raw materials.

  2. [...] more into the rationale behind matching Henrik L. Sørensen recently writes on his well-trafficked blog that “matching party data – names and addresses – is the most common area where Data [...]

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Connecting to %s

Follow

Get every new post delivered to your Inbox.

Join 109 other followers