# US 2010/0169348 A1 · Systems and Methods for Handling Multiple Records

> Agents: this data is available as JSON from the patentgrep API and MCP server — see https://patentgrep.com/llms.txt

- Number: US 2010/0169348 A1
- Document ID: US20100169348A1
- Status: Published application
- Kind: A1
- Application number: 12/347,627
- Filed: 2008-12-31
- Published: 2010-07-01
- Earliest claimed: 2008-12-31
- Assignees: Evrichart, Inc.
- Inventors: Anthony W. Maro; John B. King
- Web page: https://patentgrep.com/patent/US20100169348A1

## CPC

- G06F 16/24556: {Aggregation; Duplicate elimination}
- G06F: ELECTRIC DIGITAL DATA PROCESSING (computer systems based on specific computational models G06N)

## Abstract

Devices and methods are disclosed which relate to identifying ‘duplicate’ records in a database by finding similarities between records and applying a set of heuristic rules to determine a likelihood of being a duplicate record. The weighted results of the application of the heuristic rules identify possible duplicate records in the database. Embodiments of the present invention search records comprising fields of personal information. Matches are found between records and weighted according to the degree of similarity and uniqueness. By taking account of the different modes by which duplication errors typically originate in the database to which the method is applied, these heuristic rules identify a higher percentage of actual duplicate records in the database. The heuristic rules also produce a lower rate of ‘false positives’ than the methods for identifying duplicate records in databases now known in the art.

## Claims

### Claim 1

A method for identifying potential duplicate records among a plurality of records in a database of personal information, the personal information corresponding to a plurality of fields in each record, comprising:
finding one or more matches between fields from a pair of records;
assigning a weight to each match according to a plurality of heuristic rules; and
determining a likelihood that the pair of records is duplicate based on the matches;
wherein the likelihood is calculated from the weights assigned to each match.

### Claim 2 (depends on 1)

The method of claim 1, further comprising converting fields into a standard form.

### Claim 3 (depends on 2)

The method of claim 2, wherein converting an address field comprises comparing the address field with a postal service database and replacing the address field with a standard postal form.

### Claim 4 (depends on 2)

The method of claim 2, wherein converting a birth date field comprises replacing the birth date field with a standard numerical format.

### Claim 5 (depends on 1)

The method of claim 1, wherein finding a match comprises finding exact matches and inexact matches.

### Claim 6 (depends on 1)

The method of claim 1, wherein finding uses a phonetic matching algorithm on fields whose data are words.

### Claim 7 (depends on 1)

The method of claim 1, wherein assigning further comprises giving more weight to an exact match than an inexact match.

### Claim 8 (depends on 1)

The method of claim 1, wherein assigning further comprises giving less weight to a generic match than an inexact match.

### Claim 9

A system for identifying potential duplicate records in a database, comprising:
a database comprising a plurality of records;
a server in communication with the database;
a logic on the server; and
a means of output in communication with the server;
wherein the logic finds a plurality of matches in one or more duplication analysis passes through the database; applies a plurality of heuristic rules to determine a likelihood that any records in the database are duplicative; and outputs the likelihood.

### Claim 10

The system in claim B, wherein the database is an MPI and the plurality of records each include patient biographical information and the MRN assigned to the patient.

### Claim 11 (depends on 9)

The system in claim 9, wherein the means of output is one of a monitor, printer, and facsimile.

### Claim 12

A method for identifying potential duplicate records among a plurality of records, comprising:
finding a plurality of matches in one or more duplication analysis passes through the plurality of records;
applying a plurality of heuristic rules to determine a likelihood that any two records in the plurality of records are duplicative; and
outputting any records likely to be duplicate;
wherein the plurality of matches includes exact matches, inexact matches, and generic matches.

### Claim 13 (depends on 12)

The method of claim 12, further comprising converting the plurality of records into a standard form.

### Claim 14 (depends on 12)

The method of claim 12, wherein the outputting further comprises sorting by likelihood of being duplicative.