Validating coherency between multiple data sets between database transfers

Patent metadata

Field	Value
Publication number	US-9898497-B2
Application number	US-201514675068-A
Country	US
Kind code	B2
Filing date	Mar 31, 2015
Priority date	Mar 31, 2015
Publication date	Feb 20, 2018
Grant date	Feb 20, 2018

Abstract

A user interface may be designed to receive conflicting data from multiple data sources during a merger of legacy computer systems. The interface automatically validates the conflicting data against each other to generate a final data set for review. Summary information for each data set can be displayed in a single interface such that the summary data sets are individually selectable and provide an overview of the data merger process for each data set. By drilling down through the summary data, the user interface can display individual data sets where data conflicts can be resolved, missing data can be provided, and duplicate data can be eliminated. When the merger process is complete, the interface can translate the data set into a standardized format that can be exported to form generation modules to generate, for example, a welcome letter based on the translated data set.

First claim

What is claimed is:

1. A method of generating a user interface for validating and finalizing data received from legacy computer systems, the method comprising:
creating a link to an interface table, wherein the interface table stores a first set of data records at a first legacy computer system for a first company in a plurality of companies;
generating an internal table to store contact records for the first company;
generating a mapping table between the interface table at the first legacy computer system and the internal table, wherein rows in the mapping table link columns in the interface table to columns in the internal table;
generating a set of contact records in the internal table based on the first set of data records from the interface table at the first legacy computer system using the link and the mapping table;
validating the set of contact records by detecting missing values in the set of contact records, detecting duplicate values in the set of contact records, and detecting orphaned records;
generating a user interface that displays summary information for the set of contact records together with summary information for sets of contact records sourced by legacy computer systems for companies other than the first company;
receiving, through the user interface, a selection of the summary information for the set of contact records from among the summary information for the sets of contact records;
causing individual fields in the set of contact records to be displayed through the user interface;
receiving commands to edit the individual fields in the set of contact records through the user interface; and
uploading at least a portion of the set of contact records to a system where one or more documents are generated for one or more contacts in the set of contact records.

2. The method of claim 1 , further comprising:
exporting the set of contact records to a client device; and
importing the set of contact records from the client device, wherein the set of contact records has been edited on the client device.

3. The method of claim 2 , further comprising translating the set of contact records into a datasheet format prior to exporting the set of contact records to the client device.

4. The method of claim 1 , further comprising:
receiving a command, through the user interface, to reload the set of contact records;
re-generating the set of contact records in the internal table based on the first set of data records from the interface table at the first legacy computer system using the link and the mapping table;
comparing the re-generated set of contact records with the set of contact records; and
merging the re-generated set of contact records with the set of contact records.

5. The method of claim 4 , wherein merging the re-generated set of contact records with the set of contact records comprises:
detecting contact records that exist in the set of contact records that no longer exist in the interface table;
detecting contact records that exist in both the interface table and the set of contact records with conflicting values; and
detecting contact records that exist in the interface table but that no longer exist in the set of contact records.

6. The method of claim 1 , further comprising:
receiving a command, through the user interface, to export the set of contact records to a form generation application, wherein the set of contact records is stored in a first format;
transforming the set of contact records from the first format into a second format, the second format being used by the form generation application; and
exporting the set of contact records in the second format to the form generation application which generates a welcome letter from the set of contact records.

7. A non-transitory computer-readable medium comprising instructions which, when executed by one or more processors, causes the one or more processors to perform operations comprising:
creating a link to an interface table, wherein the interface table stores a first set of data records at a first legacy computer system for a first company in a plurality of companies;
generating an internal table to store contact records for the first company;
generating a mapping table between the interface table at the first legacy computer system and the internal table, wherein rows in the mapping table link columns in the interface table to columns in the internal table;
generating a set of contact records in the internal table based on the first set of data records from the interface table at the first legacy computer system using the link and the mapping table;
validating the set of contact records by detecting missing values in the set of contact records, detecting duplicate values in the set of contact records, and detecting orphaned records;
generating a user interface that displays summary information for the set of contact records together with summary information for sets of contact records sourced by legacy computer systems for companies other than the first company;
receiving, through the user interface, a selection of the summary information for the set of contact records from among the summary information for the sets of contact records;
causing individual fields in the set of contact records to be displayed through the user interface;
receiving commands to edit the individual fields in the set of contact records through the user interface; and
uploading at least a portion of the set of contact records to a system where one or more documents are generated for one or more contacts in the set of contact records.

8. The non-transitory computer-readable medium according to claim 7 wherein the instructions cause the one or more processors to perform additional operations comprising:
exporting the set of contact records to a client device; and
importing the set of contact records from the client device, wherein the set of contact records has been edited on the client device.

9. The non-transitory computer-readable medium according to claim 8 wherein the instructions cause the one or more processors to perform additional operations comprising translating the set of contact records into a datasheet format prior to exporting the set of contact records to the client device.

10. The non-transitory computer-readable medium according to claim 7 wherein the instructions cause the one or more processors to perform additional operations comprising:
receiving a command, through the user interface, to reload the set of contact records;
re-generating the set of contact records in the internal table based on the first set of data records from the interface table at the first legacy computer system using the link and the mapping table;
comparing the re-generated set of contact records with the set of contact records; and
merging the re-generated set of contact records with the set of contact records.

11. The non-transitory computer-readable medium according to claim 10 wherein merging the re-generated set of contact records with the set of contact records comprises:
detecting contact records that exist in the set of contact records that no longer exist in the interface table;
detecting contact records that exist in both the interface table and the set of contact records with conflicting values; and
detecting contact records that exist in the interface table but that no longer exist in the set of contact records.

12. The non-transitory computer-readable medium according to claim 7 wherein the instructions cause the one or more processors to perform additional operations comprising:
receiving a command, through the user interface, to export the se

Assignees

• Oracle Int Corp

Inventors

• Ruiz Velazquez Lesvia Elena
• Juvara Paolo
• Zagni Renzo
• Villegas Medina Benjamin
• Davis Ami
• Nakata Calvin

Classifications

• G06F17/30371 Primary

  Physics · mapped topic

• G06F17/30876

  Physics · mapped topic

• G06F17/3056

  Physics · mapped topic

• G06F17/30569

  Physics · mapped topic

• G06F17/30368

  Physics · mapped topic