Resolving database entity information

Patent metadata

Field	Value
Publication number	US-9846731-B2
Application number	US-201615359287-A
Country	US
Kind code	B2
Filing date	Nov 22, 2016
Priority date	Oct 18, 2007
Publication date	Dec 19, 2017
Grant date	Dec 19, 2017

Abstract

Entity resolution in a database comprises receiving imported data comprising imported data entities each having properties each having values; receiving first user input that selects the imported data entities for resolution to existing data entities in a database; receiving second user input that specifies matching criteria for matching the imported data entities to the existing data entities, wherein each of the matching criteria comprises a matching technique; matching the imported data entities to the existing data entities using the matching criteria, resulting in creating and storing matched entity information, wherein the matched entity information is organized in matched entity data sets associated with subsets of the matching criteria that were matched; consolidating the imported data entities into the existing data entities; storing the first user input and second user input as a named criteria set for use in subsequent entity resolution operations.

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 first input specifying a 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 specifying a first matching technique to use as part of the first matching criteria;
receiving second input specifying a 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, and specifying a second matching technique that is different than the first matching technique and to use as part of the second matching criteria;
receiving third input specifying a particular one of the imported data entities and signaling a request to resolve that particular one of the imported data entities in relation to the existing data entities;
matching the particular one of the imported data entities to a first subset of the existing data entities using the first matching criteria and using the first matching technique;
matching the particular one of the imported data entities to a second subset of the existing data entities using the second matching criteria and using the second matching technique;
causing display of a first result of matching the particular one imported data entity to the first subset of the existing data entities and a second result of matching the particular one imported data entity to the second subset of the existing data entities;
receiving, in response to the display, a selection of one or more of continuing resolving the particular one imported data entity, resolving others of the imported data entities, and consolidating the particular one imported data entity into the existing data entities, the consolidating comprising adding at least one value from the particular one imported data entity to one of the first subset of the existing data entities or one of the second subset of the existing data entities;
performing further resolution or consolidation based on the selection,
wherein the method is performed by one or more computing devices.

2. The method of claim 1 , the selection being consolidating the particular one imported data entity into the existing data entities.

3. The method of claim 1 ,
wherein the first matching criteria checks for an exact match between the first subset of one or more properties and a first corresponding subset of one or more properties of the existing data entities, and
wherein the second matching criteria checks for an exact match between the second subset of one or more properties and a second corresponding subset of one or more properties of the existing data entities.

4. The method of claim 1 ,
wherein the first matching criteria does not allow any conflicts between the first subset of one or more properties and a first corresponding subset of one or more properties of the existing data entities, and
wherein the second matching criteria does allow at least some conflicts between the first subset of one or more properties of the imported data entities and the first corresponding subset of one or more properties of the existing data entities.

5. The method of claim 1 ,
wherein the first matching criteria does not allow missing information in the first subset of one or more properties, and
wherein the second matching criteria does allow missing information in the first subset of one or more properties.

6. The method of claim 1 , wherein the first subset and the second subset each have two or more properties.

7. The method of claim 1 , wherein the first matching criteria checks for an exact match, and wherein the second matching criteria checks for a fuzzy match.

8. The method of claim 1 , comprising storing the first matching criteria and the second matching criteria for use in subsequent entity resolution operations.

9. The method of claim 1 , comprising:
receiving input that specifies one or more names of stored matching criteria;
loading the stored matching criteria based at least in part on the input;
automatically matching imported data entities to existing data entities using the loaded matching criteria.

10. The method of claim 1 , comprising:
determining that the imported data entities comprise one or more unresolved data entities, and, in response:
matching the one or more unresolved data entities to a third subset of the existing data entities using at least a third matching criteria that is different from the first matching criteria and the second matching criteria;
consolidating a third selected matched entity from the one or more unresolved data entities with a third existing entity of the third subset of the existing data entities.

11. 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 comprising:
receiving first input specifying a 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 specifying a first matching technique to use as part of the first matching criteria;
receiving second input specifying a 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, and specifying a second matching technique that is different than the first matching technique and to use as part of the second matching criteria;
receiving third input specifying a particular one of the imported data entities and signaling a request to resolve that particular one of the imported data entities in relation to the existing data entities;
matching the particular one of the imported data entities to a first subset of the existing data entities using the first matching criteria and using the first matching technique;
matching the particular one of the imported data entities to a second subset of the existing data entities using the second matching criteria and using the second matching technique;
causing display of a first result of matching the particular one imported data entity to the first subset of the existing data entities and a second result of matching the particular one imported data entity to the second subset of the existing data entities;
receiving, in response to the display, a selection of one or more of continuing resolving the particular one imported data entity, resolving others of the imported data entities, and consolidating the particular one imported data entity into the existing data entities, the consolidating comprising adding at least one value from the particular one imported data entity to one of the first subset of the existing data entities or one of the second subset of the existing data entities;
performing further resolution or consolidation based on the selection.

12. The one or more non-transitory computer-readable storage media of claim 11 , the selection being consolidating the particular one imported data entity into the existing data entities.

13. The one or more non-transitory computer-readable storage media of claim 11 ,
comprising instructions which when executed

Assignees

• Palantir Technologies Inc

Inventors

• Mcgrew Robert
• Cohen Stephen

Classifications

• G06F17/3056

  Physics · mapped topic

• G06F17/30569 Primary

  Physics · mapped topic

• G06F17/30371

  Physics · mapped topic

• G06F17/30303

  Physics · mapped topic

• G06F17/30309

  Physics · mapped topic