US 11,960,459 B1Granted

Merging duplicate customer data

AssigneeAmazon Technologies, Inc.

InventorsJan Henrik Jonsson, Shadie Hijazi, Davor Golac, Kuangyou Yao, Yang Song, Shobhit Gupta, Ian James Boetius MacClancy, Lanxin Zhang, Hongtao Liu, Austin M Nevins, Amy Lee, Meng Xiao Wang, Blake Stephens

Life of this patent

Estimating the term…

patentgrep

Loading patent…

Abstract

Systems and methods are described for merging customer profiles, such as may be implemented by a computer-implemented contact center service. In some aspects, a subset of profiles may be determined that satisfy merging criteria, where individual profiles include a plurality of data fields. At least one value in a first data field that conflicts between at least two profiles may be identified. Next a merged value may be selected for the first data field based on data deduplication criteria, where the data deduplication criteria includes at least one indicator of accuracy of values of the plurality of data fields. As a result of a determination that at least the subset of profiles of the group of profiles meet the merging criteria, at least the subset of profiles may be combined into a combined profile using the merged value.

Claims22

Dependent claims

A computer-implemented method comprising:

identifying, by a computer-implemented contact center service, at least two profiles of a group of profiles as candidates for merging into a merged profile based on the at least two profiles meeting merging criteria, each of the at least two profiles of the group of profiles indicating an account associated with one of a plurality of disparate third party services and comprising a plurality of data fields;
determining, for the merged profile, a value for each of at least one individual data field from the plurality of data fields of the at least two profiles that conflict with one another by at least prioritizing the value in the at least one individual data field based on:
completeness of data across a number of data fields of the plurality of data fields of each profile of the plurality of profiles, wherein a first profile having data associated with a first number of data fields is prioritized over a second profile having data associated with a second number of data fields, wherein the second number is less than the first number, and at least one of:
a service associated with each of the at least two profiles, or
recency of an update to the individual data field;
and
as a result of the at least two profiles meeting the merging criteria, merging the group of profiles into the merged profile using the prioritized value in the at least one individual data field.

4 more elements

A system, comprising:

at least one processor;
and
memory that stores computer-executable instructions that, as a result of being executed by the at least one processor, cause the system to:
determine that at least a subset of profiles of a group of profiles satisfy merging criteria, wherein individual profiles of the group of profiles comprise a plurality of data fields;
identify at least one value in a first data field of the plurality of data fields that conflicts between at least two of the subset of profiles;
select a merged value for the first data field based on data deduplication criteria, wherein the data deduplication criteria comprises at least one indicator of accuracy of values of the plurality of data fields based on completeness of data across a number of data fields of the plurality of data fields of each profile of the group of profiles, wherein the at least one value of a first profile of the subset of profiles is determined to be more accurate than the at least one value of a second profile of the subset of profiles based on the first profile having data for a first number of data fields and the second profile having data for a second number of data fields, wherein the first number is greater than the second number;
and
as a result of a determination that at least the subset of profiles of the group of profiles meet the merging criteria, combine at least the subset of profiles into a combined profile using the merged value.

5 more elements

A non-transitory computer-readable storage medium storing thereon executable instructions that, as a result of being executed by one or more processors of a computer system, cause the computer system to at least:

determine that at least a subset of profiles of a set of profiles fulfills a merging condition, wherein individual profiles of the set of profiles comprise a plurality of data fields;
identify, from the plurality of data fields, values in a same data field that conflict between at least the subset of profiles;
select a merged value for the same data field based on:
which profile of at least the subset of profiles comprises data for a largest number of data fields, and at least one of:
trustworthiness of accuracy of a source associated with each profile of at least the subset of profiles,
or
a time associated with an update to the same data field for at least the subset of profiles;
and
based on determining that at least the subset of profiles of the set of profiles fulfills the merging condition, combine at least the subset of profiles into a combined profile using the merged value for the same data field.

6 more elements

Dependencies are inferred from the claim text.

Facts

Application: 17/490,939Filed 30 Sep 2021
Granted: 16 Apr 2024
Term ends: Not estimatedThe source records don’t support an estimate.

Classification8 codes

G06F 16/215
Design, administration or maintenance of databases: improving data quality; Data cleansing, e.g. de-duplication, removing invalid entries or…
G06F 16/21
Of structured data, e.g. relational data: design, administration or maintenance of databases
G06F 16/2358
Updating: change logging, detection, and notification
G06F 16/258
Integrating or interfacing systems involving database management systems: data format conversion from or to a database