Matching new customer records to existing customer records in a

Details Matching new customer records to existing customer records in a Matching new customer records to existing customer records in a

1996-08-23

1998-10-06

Black, Thomas G.

Data processing: database and file management or data structures

Database design

Data structure types

707 1, 707 5, G06F 1730

Patent

active

058192913

ABSTRACT:
In this invention there is a method and system for matching new customer records to existing customer records in a database. The new customer records are validated for quality and normalized into a standard form. A hash key is selected to generate a candidate set of records from the existing records in the database that likely matches the new customer records. The new customer records are then matched to each of the records in the candidate set. Once the matching has been performed, a decision is made on whether to create a new customer record, update an existing record, or save the new record in a pending file for resolution at a later time. In another embodiment, there is a methodology for learning matching rules for matching records in a database. The matching rules are then used for matching a new customer record to existing records in a database.

REFERENCES:
patent: 4290105 (1981-09-01), Cichelli et al.
patent: 5129082 (1992-07-01), Tirfing et al.
patent: 5202982 (1993-04-01), Gramlich et al.
patent: 5446888 (1995-08-01), Pyne
patent: 5479654 (1995-12-01), Squibb
patent: 5481704 (1996-01-01), Pellicano
patent: 5604910 (1997-02-01), Kojima et al.
SSA-Name An Introduction', Search Software America, Old Greenwich, CT, Version 1.6, pp. 1-24, Oct. 1, 1994.
"The Field Matching Problem: Algorithms And Applications" by AE Monge, Et Al, Second International Conference On Knowledge Discovery And Data Mining, Aug. 2, 1996, AAA1 Press, Menlo Park, Ca, pp. 267-270.
"The Merge/Purge Problem for Large Databases" by MA Hernandez, et al, Proceedings of the ACM SIGMOID International Conference on Management of Data (May 1995), pp. 1-35.

Affiliated with

Also associated with

Rating

Matching new customer records to existing customer records in a does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with Matching new customer records to existing customer records in a , we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Matching new customer records to existing customer records in a will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-93940