US5960430A
Expired / Lapsed
US
⏱️ 0.0 years remaining
Generating rules for matching new customer records to existing customer records in a large database
Assignee: General Electric Co
•
Filing: 1998-07-10
•
Granted: 1999-09-28
•
Expires: 2018-07-10
Abstract
Abstract 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.
Inventors
- 👤 Ira Joseph Haimowitz
- 👤 Brian Terence Murren
- 👤 Henry Lander
- 👤 Barbara Ann Pierce
- 👤 Mary Clarkeson Phillips
Bibliographic Details
Application Number
—
Jurisdiction
US
Data Source
google_patents
Last Synchronized
2026-10-29 23:18
CPC Classifications
G; G06; G06F; G06F16/00; G06F16/90; G06F16/901; G06F16/9014; Y; Y10; Y10S; Y10S707/00; Y10S707/99931; Y10S707/99932; Y10S707/99933; Y10S707/99935; Y10S707/99936; Y10S707/99951; Y10S707/99952
Claims Analysis
Total Claims: 12
Claim 1
Independent Claim
123 words
A method for generating rules for matching data in a database containing a plurality of records each having a collection of fields, comprising the steps of: obtaining a sample of training data from the database; identifying pairs of records from the sample of training data that are similar; applying field matching functions to each of the corresponding fields in the similar pairs of records, each field matching function generating a score indicating a strength of a match between items in the field; generating an intermediate file of vectors containing matching scores for all of the fields from each of the similar pair of records; and converting the intermediate file of vectors into a plurality of matching rules for matching data in the database.
Claim 2
Independent Claim
123 words
A method for generating rules for matching data in a database containing a plurality of records each having a collection of fields, comprising the steps of: obtaining a sample of training data from the database; identifying pairs of records from the sample of training data that are similar; applying field matching functions to each of the corresponding fields in the similar pairs of records, each field matching function generating a score indicating a strength of a match between items in the field; generating an intermediate file of vectors containing matching scores for all of the fields from each of the similar pair of records; and converting the intermediate file of vectors into a plurality of matching rules for matching data in the database.
Claim 3
Dependent Claim
20 words
The method according to claim 1, wherein the field matching functions comprise exact matches, phonetic-based matches, and numeric string matches.
Claim 4
Dependent Claim
29 words
The method according to claim 1, wherein each vector comprises an overall matching score indicating whether each of the similar pair of records is a match or a non-match.
Claim 5
Dependent Claim
21 words
The method according to claim 1, wherein the plurality of matching rules indicate instances of matches, possible matches, and no matches.
Claim 6
Dependent Claim
49 words
The method according to claim 4, further comprising the step of using the plurality of matching rules for matching a new data set containing a record and a collection of fields to an existing data set in a database containing a plurality of records each having a collection fields.
Claim 7
Independent Claim
130 words
A system for generating rules for matching data in a database containing a plurality of records each having a collection of fields, comprising: means for obtaining a sample of training data from the database; means for identifying pairs of records from the sample of training data that are similar; means for applying field matching functions to each of the corresponding fields in the similar pairs of records, each field matching function generating a score indicating a strength of a match between items in the field; means for generating an intermediate file of vectors containing matching scores for all of the fields from each of the similar pair of records; and means for converting the intermediate file of vectors into a plurality of matching rules for matching data in the database.
Claim 8
Independent Claim
130 words
A system for generating rules for matching data in a database containing a plurality of records each having a collection of fields, comprising: means for obtaining a sample of training data from the database; means for identifying pairs of records from the sample of training data that are similar; means for applying field matching functions to each of the corresponding fields in the similar pairs of records, each field matching function generating a score indicating a strength of a match between items in the field; means for generating an intermediate file of vectors containing matching scores for all of the fields from each of the similar pair of records; and means for converting the intermediate file of vectors into a plurality of matching rules for matching data in the database.
Claim 9
Dependent Claim
20 words
The system according to claim 6, wherein the field matching functions comprise exact matches, phonetic-based matches, and numeric string matches.
Claim 10
Dependent Claim
29 words
The system according to claim 6, wherein each vector comprises an overall matching score indicating whether each of the similar pair of records is a match or a non-match.
Claim 11
Dependent Claim
21 words
The system according to claim 6, wherein the plurality of matching rules indicate instances of matches, possible matches, and no matches.
Claim 12
Dependent Claim
48 words
The system according to claim 9, further comprising means for using the plurality of matching rules for matching a new data set containing a record and a collection of fields to an existing data set in a database containing a plurality of records each having a collection fields.
References Cited (Backward Citations)
US4290105A
Cited
US5604910A
Cited
US5303149A
Cited
US5129082A
Cited
US5202982A
Cited
US5479654A
Cited
US5227970A
Cited
US5481704A
Cited
US5515534A
Cited
US5619709A
Cited
US5446888A
Cited
US5497486A
Cited
US5706497A
Cited
US5583778A
Cited
US5724593A
Cited
USPTO Annuity & Maintenance Windows
| Annuity Stage | Window Opens | Payment Deadline | Surcharge Period Until | Estimated Fee | Status |
|---|---|---|---|---|---|
| 3.5 Years (Year 4) | 2002-09-27 | 2003-03-29 | 2003-09-28 | $2000.00 | Window Closed / Lapsed |
| 7.5 Years (Year 8) | 2006-09-27 | 2007-03-29 | 2007-09-28 | $3760.00 | Window Closed / Lapsed |
| 11.5 Years (Year 12) | 2010-09-27 | 2011-03-29 | 2011-09-28 | $7700.00 | Window Closed / Lapsed |