VALIDATING COHERENCY BETWEEN MULTIPLE DATA SETS BETWEEN DATABASE TRANSFERS

• US 20160292206A1
• Filed: 03/31/2015
• Published: 10/06/2016
• Est. Priority Date: 03/31/2015
• Status: Active Grant

• Current Assignee: Oracle International Corporation (Oracle Corporation)
• Original Assignee: Oracle International Corporation (Oracle Corporation)
• Inventors: Ruiz Velazquez, Lesvia Elena, Juvara, Paolo, Villegas Medina, Benjamin, Davis, Ami, Nakata, Calvin, Zagni, Renzo
• Granted Patent: US 9,898,497 B2
• Time in Patent Office: Days
• US Class Current: 1/1
• CPC Class Codes: G06F 16/215 Improving data quality; Data cleansing, e.g. de-duplication, removing invalid entries or correcting typographical errors
• CPC Class Codes: G06F 16/2358 Change logging, detection, and notification replication G06F16/27
• CPC Class Codes: G06F 16/2365 Ensuring data consistency and integrity
• CPC Class Codes: G06F 16/252 between a Database Management System and a front-end application
• CPC Class Codes: G06F 16/258 Data format conversion from or to a database
• CPC Class Codes: G06F 16/955 using information identifiers, e.g. uniform resource locators [URL]
• CPC Class Codes: G06F 3/04842 Selection of displayed objects or displayed text elements G06F3/0482 takes precedence

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.

Claims

1. A method of generating a user interface for validating and finalizing data received from legacy computer systems, the method comprising:

receiving data records from a plurality of data sources that are associated with legacy computer systems;

extracting, from the validated data records, a first set of data that is sourced by a first legacy computer system;

generating a user interface that displays, together in the user interface, summary information sourced by the first legacy computer system among summary information of data sourced by legacy computer systems other than the first legacy computer system;

receiving, through the user interface, a selection that selects the summary information of the legacy computer system from among the summary information of the similar data for the other legacy computer systems;

causing the first set of data to be displayed through the user interface;

receiving commands to edit the first set of data through the user interface;

converting the first set of data into a new data format; and

exporting, through the user interface, the first set of data.

2. The method of claim 1, further comprising:

exporting the first set of data to a client device; and

importing the first set of data from the client device, wherein the first set of data has been edited on the client device.

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

4. The method of claim 1, further comprising:

receiving a command, through the user interface, to reload the first set of data;

accessing an interface table that comprises validated data records for the first set of data;

importing the validated data records;

comparing the validated data records with the first set of data; and

merging the validated data records with the first set of data.

5. The method of claim 4, further comprising:

generating a mapping table between the interface table and a table of the user interface, wherein the mapping table links columns in the interface table with columns in the table of the user interface.

6. The method of claim 4, wherein merging the validated data records with the first set of data comprises:

detecting data records that exist in the first set of data that no longer exist in the interface table;

detecting data records that exist in both the interface table and the first set of data with conflicting values; and

detecting data records that exist in the interface table but that no longer exist in the first set of data.

7. The method of claim 1, further comprising:

receiving a command, through the user interface, to export the first set of data to a form generation application, wherein the first set of data is stored in a first format;

transforming the first set of data from the first format into a second format, the second format being used by the form generation application; and

exporting the first set of data in the second format to the form generation application which generates a welcome letter from the first data set.

8. The method of claim 1, further comprising:

validating the data records received from the legacy computer systems by detecting missing values in the data records, detecting duplicate values in the data records, detecting orphaned records, and mapping records between the plurality of data sources

9. 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:

receiving data records from a plurality of data sources that are associated with legacy computer systems;

extracting, from the validated data records, a first set of data that is sourced by a first legacy computer system;

generating a user interface that displays, together in the user interface, summary information sourced by the first legacy computer system among summary information of data sourced by legacy computer systems other than the first legacy computer system;

receiving, through the user interface, a selection that selects the summary information of the legacy computer system from among the summary information of the similar data for the other legacy computer systems;

causing the first set of data to be displayed through the user interface;

receiving commands to edit the first set of data through the user interface;

converting the first set of data into a new data format; and

exporting, through the user interface, the first set of data.

10. The non-transitory computer-readable medium according to claim 9 wherein the instructions cause the one or more processors to perform additional operations comprising:

exporting the first set of data to a client device; and

importing the first set of data from the client device, wherein the first set of data has been edited on the client device.

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

12. The non-transitory computer-readable medium according to claim 9 wherein the instructions cause the one or more processors to perform additional operations comprising:

receiving a command, through the user interface, to reload the first set of data;

accessing an interface table that comprises validated data records for the first set of data;

importing the validated data records;

comparing the validated data records with the first set of data; and

merging the validated data records with the first set of data.

13. The non-transitory computer-readable medium according to claim 12 wherein the instructions cause the one or more processors to perform additional operations comprising:

generating a mapping table between the interface table and a table of the user interface, wherein the mapping table links columns in the interface table with columns in the table of the user interface.

14. The non-transitory computer-readable medium according to claim 12 wherein merging the validated data records with the first set of data comprises:

detecting data records that exist in the first set of data that no longer exist in the interface table;

detecting data records that exist in both the interface table and the first set of data with conflicting values; and

detecting data records that exist in the interface table but that no longer exist in the first set of data.

15. The non-transitory computer-readable medium according to claim 9 wherein the instructions cause the one or more processors to perform additional operations comprising:

receiving a command, through the user interface, to export the first set of data to a form generation application, wherein the first set of data is stored in a first format;

transforming the first set of data from the first format into a second format, the second format being used by the form generation application; and

exporting the first set of data in the second format to the form generation application which generates a welcome letter from the first data set.

16. A system comprising:

one or more processors; and

one or more memory devices comprising instructions which, when executed by the one or more processors, cause the one or more processors to perform operations comprising;

receiving data records from a plurality of data sources that are associated with legacy computer systems;

extracting, from the validated data records, a first set of data that is sourced by a first legacy computer system;

generating a user interface that displays, together in the user interface, summary information sourced by the first legacy computer system among summary information of data sourced by legacy computer systems other than the first legacy computer system;

receiving, through the user interface, a selection that selects the summary information of the legacy computer system from among the summary information of the similar data for the other legacy computer systems;

causing the first set of data to be displayed through the user interface;

receiving commands to edit the first set of data through the user interface;

converting the first set of data into a new data format; and

exporting, through the user interface, the first set of data.

17. The system of claim 16 wherein the instructions further cause the one or more processors to perform additional operations comprising:

exporting the first set of data to a client device; and

importing the first set of data from the client device, wherein the first set of data has been edited on the client device.

18. The system of claim 16 wherein the instructions further cause the one or more processors to perform additional operations comprising:

receiving a command, through the user interface, to reload the first set of data;

accessing an interface table that comprises validated data records for the first set of data;

importing the validated data records;

comparing the validated data records with the first set of data; and

merging the validated data records with the first set of data.

19. The system of claim 18 wherein the instructions further cause the one or more processors to perform additional operations comprising:

detecting data records that exist in the first set of data that no longer exist in the interface table;

detecting data records that exist in both the interface table and the first set of data with conflicting values; and

detecting data records that exist in the interface table but that no longer exist in the first set of data.

20. The system of claim 16 wherein the instructions further cause the one or more processors to perform additional operations comprising:

receiving a command, through the user interface, to export the first set of data to a form generation application, wherein the first set of data is stored in a first format;

transforming the first set of data from the first format into a second format, the second format being used by the form generation application; and

exporting the first set of data in the second format to the form generation application which generates a welcome letter from the first data set.