METHOD AND APPARATUS FOR RESOLVING DISPARATE VALUES FOR DATA ELEMENTS WITHIN A PLURALITY OF RELATED RECORDS

• US 20170270164A1
• Filed: 03/16/2016
• Published: 09/21/2017
• Est. Priority Date: 03/16/2016
• Status: Active Grant

• Current Assignee: Change Healthcare Holdings, LLC (UnitedHealth Group Incorporated)
• Original Assignee: Change Healthcare LLC (UnitedHealth Group Incorporated)
• Inventors: Berger, Elisabeth
• Granted Patent: US 11,163,772 B2
• Time in Patent Office: Days
• CPC Class Codes: G06F 16/215 Improving data quality; Data cleansing, e.g. de-duplication, removing invalid entries or correcting typographical errors
• CPC Class Codes: G06F 16/2365 Ensuring data consistency and integrity
• CPC Class Codes: G06F 16/24553 of query operations
• CPC Class Codes: G06F 40/205 Parsing

Abstract

A method, computing device and computer program product are provided to obtain information from a plurality of dissimilar records by estimating the most accurate value for each field of the plurality of records. A computing device may include processing circuitry configured to: receive a first record including two or more elements, where a first element of the first record has a first value; receive a second record comprising two or more elements, where a first element of the second record has a second value; receive a third record having two or more elements, where a first element of the third record has a third value; and determine a resultant value for the first element, where the resultant value for the first element is determined based on a frequency of occurrence of a value for the first element among the first value, the second value, and the third value.

Claims

1. A computing device comprising processing circuitry configured to:

receive a first record comprising two or more elements, wherein a first element of the first record has a first value;

receive a second record comprising two or more elements, wherein a first element of the second record has a second value;

receive a third record comprising two or more elements, wherein a first element of the third record has a third value; and

determine a resultant value for the first element, wherein the resultant value for the first element is determined based on a frequency of occurrence of a value for the first element among the first value, second value, and third value, wherein the highest frequency occurrence of a value is determined to be the resultant value for the first element.

2. The computing device of claim 1, further configured to:

receive a query, wherein the query is related to the first element;

identify the first record, the second record, and the third record as relevant to the query;

generate a new record in response to the query, wherein the new record comprises the resultant value for the first element.

3. The computing device of claim 1, wherein a second element of the first record has a first value, a second element of the second record has a second value, and a second element of the third record has a third value, the processing circuitry further configured to:

determine a resultant value for the second element, wherein the resultant value for the second element is determined based on a frequency of occurrence of a value for the second element among the first value, second value, and third value for the second element, wherein the highest frequency occurrence of a value is determined to be the resultant value for the second element.

4. The computing device of claim 3, wherein the resultant value for the first element corresponds with a value of the first element from one of the first record, the second record, or the third record, wherein the resultant value for the second element corresponds with a value of the second element from one of the first record, the second record, or the third record, and wherein the one of the first record, second record or third record corresponding with the resultant value for the first element is different from the one of the first record, second record, or third record corresponding with the resultant value for the second element.

5. The computing device of claim 4, the processing circuitry further configured to:

generate a new record comprising the resultant value of the first element and the resultant value of the second element.

6. The computing device of claim 5, the processing circuitry further configured to:

provide an indication for the first element of the new record that at least one of the first value of the first element, the second value of the first element, or the third value of the first element is different from the resultant value of the first element.

7. The computing device of claim 6, the processing circuitry further configured to:

provide access to the first record, the second record, or the third record, in response to a user selection of the resultant value of the first element of the new record; and

present the at least one of the first value of the first element, the second value of the first element, or the third value of the first element that is different from the resultant value of the first element.

8. The computing device of claim 7, wherein the new record comprises a medication list associated with a patient;

the first, second and third records, respectively, comprise records associated with the patient;

the first element is a first medication; and

the second element is a second medication.

9. The computing device of claim 1, wherein the second record is a revised version of the first record.

10. The computing device of claim 1, wherein the first record is associated with a first source, the second record is associated with a second source, and the third record is associated with a third source, wherein each of the first source, second source, and third source comprise a respective reliability value, and wherein the value of the first element from each respective record comprises a reliability weight based on the reliability value of the respective source.

11. The computing device of claim 1, wherein in response to a user selection of one of the first value of the first element, the second value of the first element, or the third value of the first element, increasing the reliability weight of the selected value.

12. A method comprising:

receiving a first record comprising two or more elements, wherein a first element of the first record has a first value;

receiving a second record comprising two or more elements, wherein a first element of the second record has a second value;

receiving a third record comprising two or more elements, wherein a first element of the third record has a third value; and

determining a resultant value for the first element, wherein the resultant value for the first element is determined based on a frequency of occurrence of a value for the first element from among the first value, second value, and third value of the first element, wherein the highest frequency occurrence of a value is determined to be the resultant value for the first element.

13. The method of claim 12, wherein a second element of the first record has a first value, a second element of the second record has a second value, and a second element of the third record has a third value, the method further comprising:

determining a resultant value for the second element, wherein the resultant value for the second element is determined based on a frequency of occurrence of a value for the second element from among the first value, the second value, and the third value of the second element, wherein the highest frequency occurrence of a value is determined to be the resultant value for the second element.

14. The method of claim 13, wherein the resultant value for the first element corresponds with a value of the first element from one of the first record, the second record, or the third record, wherein the resultant value for the second element corresponds with a value of the second element from one of the first record, the second record, or the third record, and wherein the one of the first record, second record or third record corresponding with the resultant value for the first element is different from the one of the first record, second record, or third record corresponding with the resultant value for the second element.

15. The method of claim 14, further comprising:

generating a new record comprising the resultant value of the first element and the resultant value of the second element.

16. The method of claim 15, further comprising:

providing an indication for the first element of the new record that at least one of the first value of the first element, the second value of the first element, or the third value of the first element is different from the resultant value of the first element.

17. The method of claim 16, further comprising:

providing access to the first record, the second record, or the third record, in response to a user selection of the resultant value of the first element of the new record; and

presenting the at least one of the first value of the first element, the second value of the first element, or the third value of the first element that is different from the resultant value of the first element.

18. The method of claim 17, wherein the new record comprises a medication list associated with a patient, the first, second, and third records, respectively comprise records associated with the patient;

the first element is a first medication; and

the second element is a second medication.

19. The method of claim 12, wherein the first record is associated with a first source, the second record is associated with a second source, and the third record is associated with a third source, wherein each of the first source, second source, and third source comprise a respective reliability value, and wherein the value of the first element from each respective record comprises a reliability weight based on the reliability value of the respective source.

20. A computer program product comprising a non-transitory computer readable storage medium having program code portions stored therein, the program code portions configured, upon execution, to:

receive a first record comprising two or more elements, wherein a first element of the first record has a first value;

receive a second record comprising two or more elements, wherein a first element of the second record has a second value;

receive a third record comprising two or more elements, wherein a first element of the third record has a third value; and

determine a resultant value for the first element, wherein the resultant value for the first element is determined based on a frequency of occurrence of a value for the first element from among the first value, the second value, and the third value of the first element, wherein the highest frequency occurrence of a value is determined to be the resultant value for the first element.