System and methods for quarantining suspect data from integrated data

Patent metadata

Field	Value
Publication number	US-11556944-B2
Application number	US-202117349137-A
Country	US
Kind code	B2
Filing date	Jun 16, 2021
Priority date	Sep 6, 2018
Publication date	Jan 17, 2023
Grant date	Jan 17, 2023

Abstract

A master data management (MDM) computing device may determine that a first composite data entity that includes a first transaction member record assigned with a first source identifier for a first user by a data source is linked with a second transaction member record assigned with the first source identifier for a second user by the data source. The MDM computing device may flag the second transaction member record as a suspect record for corrupting the first composite data entity when a comparison between first information contained in the first transaction member record and second information contained in the second transaction member record exceeds a predetermined threshold. The MDM computing device may create an overlay task for the second transaction member record, thereby preventing the second transaction member record from corrupting the first composite data entity.

First claim

What is claimed:

1. A computer-implemented method for enhancing data quality control carried out by a master data management (MDM) computing device, the method comprising:
determining, by one or more processors, that a first composite data entity that includes a first transaction member record assigned with a first source identifier for a first user by a data source is linked with a second transaction member record assigned with the first source identifier for a second user by the data source;
flagging, by the one or more processors, the second transaction member record as a suspect record for corrupting the first composite data entity when a comparison between first information contained in the first transaction member record and second information contained in the second transaction member record exceeds a predetermined threshold; and
creating, by the one or more processors, an overlay task for the second transaction member record by (i) unlinking the second transaction member record from the first composite data entity and (ii) storing the second transaction member record in a quarantine queue as a singleton record, thereby preventing the second transaction member record from corrupting the first composite data entity.

2. The method of claim 1 , wherein the overlay task prohibits the second transaction member record from being linked to a second composite data entity associated with at least one pre-existing transaction member record that at least partially overlaps with the second transaction member record.

3. The method of claim 1 , wherein flagging the second transaction member record comprises:
fetching a current image of the first composite data entity post-linkage with the second transaction member record;
fetching a prior image of the first composite data entity pre-linkage with the second transaction member record;
comparing the prior image and the current image; and
determining, based on the comparing, that the difference between the prior image and the current image exceeds the predetermined threshold.

4. The method of claim 3 , wherein the prior image comprises a time stamp that is a day earlier than that of the current image.

5. The method of claim 1 , wherein the second information comprises an update to at least one of name information, date of birth information, address information, phone information, email information, social security number information, or gender information contained within the first information.

6. The method of claim 5 , wherein the second information further comprises an update to pharmaceutical prescription information contained within the first information.

7. The method of claim 1 , further comprising:
creating a log file for the singleton, wherein the log file comprises the current image and the prior image; and
transmitting the log file to a data administration application configured to review the log file.

8. The method of claim 1 , further comprising:
publishing a message indicative of the singleton; and
transmitting the message to the data source.

9. A master data management (MDM) computing device for enhancing data quality control, comprising:
a memory configured to store non-transitory computer executable instructions; and
a processor configured to interface with the memory, wherein the processor is configured to execute the non-transitory computer executable instructions to cause the processor to:
determine that a first composite data entity that includes a first transaction member record assigned with a first source identifier for a first user by a data source is linked with a second transaction member record assigned with the first source identifier for a second user by the data source;
flag the second transaction member record as a suspect record for corrupting the first composite data entity when a comparison between first information contained in the first transaction member record and second information contained in the second transaction member record exceeds a predetermined threshold; and
create an overlay task for the second transaction member record by (i) unlinking the second transaction member record from the first composite data entity and (ii) storing the second transaction member record in a quarantine queue as a singleton record, thereby preventing the second transaction member record from corrupting the first composite data entity.

10. The MDM computing device of claim 9 , wherein the overlay task prohibits the second transaction member record from being linked to a second composite data entity associated with at least one pre-existing transaction member record that at least partially overlaps with the second transaction member record.

11. The MDM computing device of claim 9 , wherein the processor configured to flag the second transaction member record is configured to:
fetch a current image of the first composite data entity post-linkage with the second transaction member record;
fetch a prior image of the first composite data entity pre-linkage with the second transaction member record;
compare the prior image and the current image; and
determine, based on the comparing, that the difference between the prior image and the current image exceeds the predetermined threshold.

12. The MDM computing device of claim 11 , wherein the prior image comprises a time stamp that is a day earlier than that of the current image.

13. The MDM computing device of claim 9 , wherein the second information comprises an update to at least one of name information, date of birth information, address information, phone information, email information, social security number information, or gender information contained within the first information.

14. The MDM computing device of claim 12 , wherein the second information further comprises an update to pharmaceutical prescription information contained within the first information.

15. The MDM computing device of claim 9 , wherein the non-transitory computer executable instructions further cause the processor to:
create a log file for the singleton, wherein the log file comprises the current image and the prior image; and
transmit the log file to a data administration application configured to review the log file.

16. The MDM computing device of claim 9 , wherein the non-transitory computer executable instructions further cause the processor to:
publish a message indicative of the singleton; and
transmit the message to the data source.

17. A non-transitory computer readable medium containing a set of computer readable instructions for enhancing data quality control in a master data management (MDM) computing device, that when executed by a processor, configures the processor to:
determine that a first composite data entity that includes a first transaction member record assigned with a first source identifier for a first user by a data source is linked with a second transaction member record assigned with the first source identifier for a second user by the data source;
flag the second transaction member record as a suspect record for corrupting the first composite data entity when a comparison between first information contained in the first transaction member record and second information contained in the second transaction member record exceeds a predetermined threshold; and
create an overlay task for the second transaction member record by (i) unlinking the second transaction member record from the first composite data entity and (ii) storing the second transaction member record in a quarantine queue as a singleton record, thereby preventing the secon

Assignees

• Walgreen Co

Inventors

• Donohue Martin
• Chambers Keith

Classifications

• G06Q30/0201 Primary

  Market modelling; Market analysis; Collecting market data · CPC title

• G06F16/2365

  Ensuring data consistency and integrity · CPC title

• G06F16/215

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