Resolving database entity information

Patent metadata

Field	Value
Publication number	US-10733200-B2
Application number	US-201715811304-A
Country	US
Kind code	B2
Filing date	Nov 13, 2017
Priority date	Oct 18, 2007
Publication date	Aug 4, 2020
Grant date	Aug 4, 2020

Abstract

A method of matching a plurality of imported data entities to a plurality of existing data entities in a database is disclosed. The method comprises receiving imported data comprising imported data entities each having one or more properties each having one or more values; and causing presentation of a graphical user interface (GUI) that displays values for the one or more properties over the imported data and allows selection of a property having a certain value. The method further comprises receiving first input specifying first matching criteria that is based at least in part on a first subset of one or more properties of the imported data entities; and receiving second input specifying second matching criteria that is different from the first matching criteria and that is based at least in part on a second subset of the one or more properties of the imported data entities, wherein the second subset of the one or more properties is different than the first subset of one or more properties. The method also comprises receiving a first selection of a first of the one or more properties having a first value and a second selection of a second of the one or more properties having a second value through the GUI; and generating a first subset of the imported data entities based on the first selection and a second subset of the imported data entities based on the second selection. Finally, the method comprises matching the first subset of the imported data entities to a first subset of the existing data entities using the first matching criteria and using a first matching technique; and matching the second subset of the imported data entities to a second subset of the existing data entities using the second matching criteria and using a second matching technique, where the method is performed using one or more processors.

First claim

What is claimed is:

1. A method of matching a plurality of imported data entities to a plurality of existing data entities in a database, comprising:
receiving imported data comprising imported data entities each having one or more properties each having one or more values;
causing presentation of a graphical user interface (GUI) that displays a histogram for the values of the one or more properties over the imported data and allows selection of a property having a certain value from the histogram;
receiving, in response to the presentation of the GUI, a first selection of a first of the one or more properties having a first value and a second selection of a second of the one or more properties having a second value through the GUI;
generating a first subset of the imported data entities based on the first selection and a second subset of the imported data entities based on the second selection;
receiving first input specifying first matching criteria that is based at least in part on a first subset of one or more properties of the imported data entities;
receiving second input specifying second matching criteria that is different from the first matching criteria and that is based at least in part on a second subset of the one or more properties of the imported data entities, wherein the second subset of the one or more properties is different than the first subset of one or more properties;
matching the first subset of the imported data entities to a first subset of the plurality of existing data entities using the first matching criteria and using a matching technique;
matching the second subset of the imported data entities to a second subset of the plurality of existing data entities using the second matching criteria and using a matching technique,
wherein the method is performed using one or more processors.

2. The method of claim 1 , further comprising causing presentation of the GUI that lists each of the one or more properties of the imported data entities, the one or more values of the each of the one or more properties, and graphical indications of a number of times each of the one or more values is represented in the imported data, and that offers an option to show more, less, all, or none of data listed under each of the one or more properties of the imported data entities.

3. The method of claim 1 , generating the first subset of the imported data entities based on the first selection comprising including in the first subset the imported data entities that match the first selection.

4. The method of claim 1 , further comprising storing in a memory the first selection in association with the first input and the matching technique used in matching the first subset of the imported data entities to a first subset of the existing data entities as saved criteria for future retrieval.

5. The method of claim 1 , further comprising causing display of a first result of matching the first subset of the imported data entities to the first subset of the existing data entities.

6. The method of claim 1 , further comprising causing presentation of the GUI that further displays a histogram for values of at least one of the one or more properties over the first subset of the imported data entities that match the first subset of the existing data entities, and that allows selection of a property having a certain value from the histogram.

7. The method of claim 6 , further comprising:
receiving a third selection of one of the at least one properties having a third value;
determining a third subset of the imported data entities from the first subset of the imported data entities that match the first subset of the existing data entities based on the third selection.

8. The method of claim 7 , further comprising receiving a selection of one or more of the third subset of the imported data entities for consolidation into the existing data entities.

9. The method of claim 7 , further comprising receiving a selection of one or more of the third subset of the imported data entities for further resolution with the existing data entities.

10. One or more non-transitory computer-readable storage media comprising stored instructions which, when executed by one or more processors, cause performing a method of matching a plurality of imported data entities to a plurality of existing data entities in a database, the method comprising:
receiving imported data comprising imported data entities each having one or more properties each having one or more values;
causing presentation of a graphical user interface (GUI) that displays a histogram for the values of the one or more properties over the imported data and allows selection of a property having a certain value from the histogram;
receiving, in response to the presentation of the GUI, a first selection of a first of the one or more properties having a first value and a second selection of a second of the one or more properties having a second value through the GUI;
generating a first subset of the imported data entities based on the first selection and a second subset of the imported data entities based on the second selection;
receiving first input specifying first matching criteria that is based at least in part on a first subset of one or more properties of the imported data entities;
receiving second input specifying second matching criteria that is different from the first matching criteria and that is based at least in part on a second subset of the one or more properties of the imported data entities, wherein the second subset of the one or more properties is different than the first subset of one or more properties;
matching the first subset of the imported data entities to a first subset of the plurality of existing data entities using the first matching criteria and using a matching technique;
matching the second subset of the imported data entities to a second subset of the plurality of existing data entities using the second matching criteria and using a matching technique.

11. The one or more non-transitory computer-readable storage media of claim 10 , the method further comprising causing presentation of the GUI that lists each of the one or more properties of the imported data entities, the one or more values of the each of the one or more properties, and graphical indications of a number of times each of the one or more values is represented in the imported data, and that offers an option to show more, less, all, or none of data listed under each of the one or more properties of the imported data entities.

12. The one or more non-transitory computer-readable storage media of claim 10 , generating the first subset of the imported data entities based on the first selection comprising including in the first subset the imported data entities that match the first selection.

13. The one or more non-transitory computer-readable storage media of claim 10 , the method further comprising storing in a memory the first selection in association with the first input and the matching technique used in matching the first subset of the imported data entities to a first subset of the existing data entities as saved criteria for future retrieval.

14. The one or more non-transitory computer-readable storage media of claim 10 , the method further comprising causing display of a first result of matching the first subset of the imported data entities to the first subset of the existing data entities.

15. The one or more non-transitory computer-readable storage media of claim 10 , the method further comprising causing presentation of the GUI that further displays a histogram for val

Assignees

• Palantir Technologies Inc

Inventors

• Mcgrew Robert
• Cohen Stephen

Classifications

• G06F16/215 Primary

  Improving data quality; Data cleansing, e.g. de-duplication, removing invalid entries or correcting typographical errors · CPC title

• G06F16/258 Primary

  Data format conversion from or to a database · CPC title

• G06F16/24556

  Aggregation; Duplicate elimination · CPC title

• G06F16/2365

  Ensuring data consistency and integrity · CPC title

• G06F16/252

  between a Database Management System and a front-end application · CPC title