MatchVIP Dating Services has the largest active database of Gauteng singles, Cape Town singles and Durban singles (our database is kicking off for dating East London, dating Port Elizabeth, dating Mpumalanga and dating Bloemfontein, and growing daily), as well as the largest active database of singles dating in the UK, Australia and Africa. Data Matching Services. Data matching services help sales and marketing teams verify and update their customer databases. As time passes, customers might have moved their homes, changed jobs or even retired. So, their mailing information is bound to become inaccurate.

-->

Applies to: SQL Server (all supported versions)

The Data Quality Services (DQS) data matching process enables you to reduce data duplication and improve data accuracy in a data source. Matching analyzes the degree of duplication in all records of a single data source, returning weighted probabilities of a match between each set of records compared. You can then decide which records are matches and take the appropriate action on the source data.

The DQS matching process has the following benefits:

• Matching enables you to eliminate differences between data values that should be equal, determining the correct value and reducing the errors that data differences can cause. For example, names and addresses are often the identifying data for a data source, particularly customer data, but the data can become dirty and deteriorate over time. Performing matching to identify and correct these errors can make data use and maintenance much easier.

• Matching enables you to ensure that values that are equivalent, but were entered in a different format or style, are rendered uniform.

• Matching identifies exact and approximate matches, enabling you to remove duplicate data as you define it. You define the point at which an approximate match is in fact a match. You define which fields are assessed for matching, and which are not.

• DQS enables you to create a matching policy using a computer-assisted process, modify it interactively based upon matching results, and add it to a knowledge base that is reusable.

• You can re-index data copied from the source to the staging table, or not re-index, depending on the state of the matching policy and the source data. Not re-indexing can improve performance.

You can perform the matching process in conjunction with other data cleansing processes to improve overall data quality. You can also perform data de-duplication using DQS functionality built into Master Data Services. For more information, see Master Data Services Overview (MDS).

The following illustration displays how data matching is done in DQS:

How to Perform Data Matching

As with other data quality processes in DQS, you perform matching by building a knowledge base and executing a matching activity in a data quality project in the following steps:

1. Create a matching policy in the knowledge base

2. Perform a de-duplication process in a matching activity that is part of a data quality project.

Building a Matching Policy

You prepare the knowledge base for performing matching by creating a matching policy in the knowledge base to define how DQS assigns matching probability. A matching policy consists of one or more matching rules that identify which domains will be used when DQS assesses how well one record matches to another, and specify the weight that each domain value carries in the matching assessment. You specify in the rule whether domain values have to be an exact match or can just be similar, and to what degree of similarity. You also specify whether a domain match is a prerequisite.

The matching policy activity in the Knowledge Base Management wizard analyzes sample data by applying each matching rule to compare two records at a time throughout the range of records. Records whose matching scores are greater than a specified minimum are grouped in clusters in the matching results. These matching results are not added to the knowledge base; you use them to tune the matching rules. Creating a matching policy can be an iterative process in which you modify matching rules based on the matching results or profiling statistics.

You can specify for a domain that data strings will be normalized when you load data from the data source into the domain. This process consists of replacing special characters with a null or a space, which often removes the difference between two strings. This can increase matching accuracy, and can often enable a matching result to surpass the minimum matching threshold, when without normalization it would not pass.

Note

Null values in the corresponding fields of two records will be considered a match.

The matching policy is run on domains mapped to the sample data. You can specify whether data is copied from the data source into the staging table and re-indexed when you run the matching policy, or not. You can do so both when building the knowledge base and when running the matching project. Not re-indexing could result in improved performance. Re-indexing is not necessary if the following is true: the matching policy has not changed, and you have not updated the data source, remapped the policy, selected a new data source, or mapped one or more new domains.

Each matching rule is saved in the knowledge base when it is created. However, a knowledge base is available for use in a data quality project only when it is published. In addition, until the knowledge base is published, the matching rules in it cannot be changed by a user other than the person who created it.

Running a Matching Project

DQS performs data de-duplication by comparing each row in the source data to every other row, using the matching policy defined in the knowledge base, and producing a probability that the rows are a match. This is done in a data quality project with a type of Matching. Matching is one of the major steps in a data quality project. It is best performed after data cleansing, so that the data to be matched is free from error. Before running a matching process, you can export the results of the cleansing project into a data table or .csv file, and then create a matching project in which you map the cleansing results to domains in the matching project.

A data matching project consists of a computer-assisted process and an interactive process. The matching project applies the matching rules in the matching policy to the data source to be assessed. This process assesses the likelihood that any two rows are matches in a matching score. Only those records with a probability of a match greater than a value set by the data steward in the matching policy will be considered a match.

When DQS performs the matching analysis, it creates clusters of records that DQS considers matches. DQS randomly identifies one of the records in each cluster as the pivot, or leading, record. The data steward verifies the matching results, and rejects any record that is not an appropriate match for a cluster. The data steward then selects a survivorship rule that DQS will use to determine the record that will survive the matching process and replace the matching records. The survivorship rule can be 'Pivot record' (the default), 'most complete and longest record', 'most complete record', or 'longest record'. DQS determines the survivor (leading) record in each cluster based upon which record most closely matches the criteria or criterion in the survivorship rule. If multiple records in a given cluster comply with the survivorship rule, DQS selects one of those records randomly. DQS gives you the choice of displaying clusters that have records in common as a single cluster by selecting 'show non-overlapping clusters'. You must execute the matching process in order to display the results according to this setting.

You can export the results of the matching process either to a SQL Server table or a .csv file. You can export matching results in two forms: first, the matched records and the unmatched records, or second, survivorship records that include only the survivor record for a cluster and the unmatched results. In the survivorship records, if the same record is identified as the survivor for multiple clusters, that record will only be exported once.

In This Section

You can perform the following tasks related to matching in DQS:

Task Description	Topic
Create and test matching rules in a matching policy	Create a Matching Policy
Run matching in a data quality project	Run a Matching Project

ENQUIRE ABOUT OUR MEMBERSHIP PACKAGES TODAY! T&Cs APPLY.

We find your love connection using a combination of ancient people and matchmaking skills – the human touch – and the most modern technology to communicate with you. We refine your search for who you wish to be connected with, as a personal choice, saving you all the time and trouble of futile and blind searching and unwanted attention. Professional Matchmaking is a personalised and bespoke introduction service to others who meet your criteria, and you theirs. MatchVIP is the most trusted Dating & Matchmaking Service since 2009. Dating by default or design?

In seeking a love match, serious singles believe that an online connection to other upmarket singles is all it takes!

This is a common myth as love can only find you when you meet the RIGHT singles who are better suited to YOU!

Hook-ups, Meet-ups and taking chances seldom works, as many professional singles are realising it pays to be introduced by a professional dating agency or matchmaker.

Dating in South Africa isn’t easy, especially if you have high standards, integrity and enjoy a quality lifestyle and find online dating a nightmare! It’s a problem many single professionals face when dating in Johannesburg, dating in Pretoria, dating in Cape Town and dating in Durban, dating in Port Elizabeth, dating in East London, dating in Bloemfontein or even dating in Mpumalanga.

We have now extended our personal service to Members in Africa, the UK and Australia. Two options are online dating or personal matchmaking.

Professional personal dating service

If you’re relationship oriented and searching for someone like-minded, then our Professional Dating Service may be just what you’re looking for. Have you researched your actual single’s social landscape? Where do you start ….??? You start with an enquiry HERE!!

MatchVIP Dating Services has the largest active database of Gauteng singles, Cape Town singles and Durban singles (our database is kicking off for dating East London, dating Port Elizabeth, dating Mpumalanga and dating Bloemfontein, and growing daily), as well as the largest active database of singles dating in the UK, Australia and Africa. MatchVIP has been operational since 2009, with a personalized and bespoke matchmaking service to likeminded and upmarket singles. We specialize in corporate dating, executive dating and matchmaking for singles who appreciate the human touch and old school introductions done with dignity – friend on friend! A stranger is just a friend you have not met!! Nobody is a stranger here as we are all friends, join the social club today! Not stumbling in the dark, but knowing where you are going ……

Some advantages of making use of our exclusive dating service:

Our demanding lifestyles consume most of our energy. We approach professionals such as personal trainers and investors to assist us with other aspects of our lives, so why not consult with a professional Matchmaker on the most important aspect of your life: finding a life partner?

• Multi-cultural
• Multi-denominational
• Packages to suit all budgets – assessed when we have our first discussion and orientation chat
• VIP status – for Platinum and Diamond clients only, by invitation

• Guaranteed Introductions: To like-minded singles whom we have personally screened and who we have accepted onto our Corporate Dating database after accurate profiling and will be introduced to compatible others with a high chance of success – no more hit and miss dating!
• Success: 67% of MatchVIP members leave our Matchmaker database having entered into a committed relationship because we are hands-on and guide you through each step, motivating and encouraging.
• Safety: We carefully screen all potential members as we get to know each member throughout the journey – although we are not invasive – at your side when and if you need us. We decline enquiries that do not meet our entry requirements, as your gate keepers. You are SAFE!
• Qualified Professionals: Your interview is conducted by a trained Life Coach and recruitment specialist. We take our time in getting to know you before you step out on your first date and make sure you are ‘date ready’ with an awesome presentation to attract YOUR kinda folk!
• Confidential: All information is treated as highly confidential – no member’s details are published anywhere, personal profiles are only offered to those you may wish to meet, by your personal matchmaker, by email, after you approve your profile. Your info is protected by a special software system.
• Personal Touch: We are in regular contact to review your Corporate Dating requirements
• Date and Relationship Coaching: If required we can help you identify and overcome any dating or relationship habits that may be holding you back. We have expert gurus on board for any situation.
• Time Efficient: We take the hard work out of Professional Dating. Our structured approach ensures a positive experience for all. We have tried and tested processes and protocols and a fully trained Team to expedite service, and we uphold communication at all times.
• Innovative: Rated as a leading matchmaking agency in SA, we keep abreast of all the dynamics of our single’s landscape, keeping a finger on the pulse of what is going on, what works best and how to do it smart! We are your advisors on what works and what does not.

Date Matching Services

Guarantee: In the unlikely event of us not delivering on our Matchmaker guarantee to you as per your package, we extend membership for free until we do. We also assess from time to time how we can improve outcomes, together, if we are not seeing results!

Does playing hard to get really work?

Data Matching Services

Are you blowing him off or are you playing hard to get? ‘Cause man, he just can’t tell. Our experts weigh in on the timeless trend of dating.