Record Matching Made Easy with MatchUp Web Service

Blog Administrator | Data Governance, Data Integration, Data Management, Data Matching, Data Quality, Data Quality Components for SSIS, Data Steward, Data Warehouse, Duplicate Elimination, Fuzzy Matching, Golden Record, Householding, Identity Resolution, Record Linkage, SQL Server Integration Services, SSIS, Survivorship | , , , , , , ,

Melissa’s solution to identify and eliminate duplicate records, is now
available as a web service for batch processes, fulfilling one of most frequent
requests from our customers – accurate database matching without maintaining
and linking to libraries, or shelling out to the necessary locally-hosted data


you can integrate MatchUp into any aspect of your network that can communicate
with our secure servers using common protocols like XML, JSON, REST or SOAP.


a predefined matching strategy, map the table input columns necessary to
identify matches to the respective request elements, and submit the records for
processing. Duplicate rows can be identified by a combination of NAME, ADDRESS,


select list of matching strategies removes the complexity of configuring rules,
while still applying our fast and versatile fuzzy matching algorithms and
extensive datatype-specific knowledge base, ensuring the tough-to-identify
duplicates will be flagged by MatchUp. 


The output response returned by the service
can be used to update a database or create a unique marketing list by
evaluating each record’s result codes, group identifier and group count, and
using the record’s unique identifier to link back the original database record.


Melissa’s servers do the processing, there are no key files – the temporary
sorting files – to manage, freeing up valuable hardware resources on your local


can access the MatchUp
Web Service
license by obtaining a valid license from our sales team and
selecting the endpoint compatible to your development platform and necessary
request structures here.

How to Create a Golden Record

Blog Administrator | Data Cleansing, Golden Record | , ,

Some common goals in database administration include
maintaining clean and effective patient data. A step that is often overlooked
comes as the final step of the process and is importance for the purposes of
survivorship, it is known as the “Golden Record”. A Golden Record is the
creation of a single, accurate, and complete version of a patient record.

Here is how you can determine the most accurate data to use
in establishing the Golden Record:

Once you’ve gone through the matching process, you will most
likely end up with duplicated records bundled into duplicate groups that are
ready for consolidation. What comes this is where the unique or “winning”
Golden Record becomes the next logical step. The process of selecting the best
possible record as the surviving candidate can be tricky. However, techniques
can be applied to perform the selection of the record that will be selected for

How do you know which record you should keep? There are
three commonly used techniques to selecting the surviving record:

1.       1. The most recent methodology is based on
date-stamped records. Order them from most recent to least recent and then
consider the most recent eligible as the survivor.

2.      2.  The most frequent approach matches records that
contain the same information as an indication of their accuracy. When more than
one record obtains the information it is an indication of their correctedness.

3.       3. The most complete method considers field
completeness as its primary factor of correctness. The records that obtain the
most filled out fields are considered to be the best record for survivorship.

Golden Records should be the goal of for all databases.
Obtaining data quality is key to having the best connection and insight into
your database.

 By Natalia Crawford