Enhanced data comparison tool

• US 8,819,042 B2
• Filed: 04/23/2010
• Issued: 08/26/2014
• Est. Priority Date: 04/23/2010
• Status: Active Grant

• Current Assignee: Bank of America Corp.
• Original Assignee: Bank of America Corp.
• Inventors: Samudrala, Subasree, Kuchipudi, Satish Vvn
• Primary Examiner(s): VU, BAI DUC
• Application Number:
  US12/766,699
• Publication Number:
  US 20110264625A1
• Time in Patent Office: 1,586 Days
• Field of Search: None
• US Class Current: 707/758
• CPC Class Codes: G06F 16/25 Integrating or interfacing systems involving database management systems

Abstract

Systems and methods are illustrated for transitioning data from one data store to another data store. The transition may occur according to comparison information received through a graphical user interface. For example, the comparison information may map data or columns in a source data store to data or columns in a target data store. A score may also be generated based on a comparison of the source and target. A report may indicate a successful or failed data transition based on the score.

Claims

1. A computer-readable storage medium storing computer-executable instructions that when executed cause a system to perform steps comprising:

receiving a source identifier of a source data store;

receiving a target identifier of a target data store;

displaying a graphical user interface configured to receive comparison information, wherein the comparison information comprises a first identifier and a second identifier of the source data store, a first identifier of the target data store, and a mapping among the identifiers, wherein the first identifier of the source data store identifies customer data in the source data store, and wherein the second identifier of the source data store identifies a last-updated date in the source data store;

transitioning the customer data identified by the first identifier of the source data store from the source data store to the target data store according to the comparison information, wherein the transitioning is based on a determination that the last-updated date is more recent than a predetermined date;

comparing the customer data identified by the first identifier of the source data store to data identified by the first identifier of the target data store;

based on the comparing, generating a score based on a difference between the customer data identified by the first identifier of the source data store and the data identified by the first identifier of the target data store;

determining whether the score meets a predetermined comparison parameter; and

generating a success report when the score meets the predetermined comparison parameter.

2. The computer-readable storage medium of claim 1, wherein the target data store is a part of a database system.

3. The computer-readable storage medium of claim 1, wherein the data identified by the first identifier of the target data store is a function of the customer data identified by the first identifier of the source data store.

4. The computer-readable storage medium of claim 1, wherein the predetermined comparison parameter is a threshold value, and wherein determining whether the score meets the predetermined comparison parameter comprises determining whether the score is less than the threshold value.

5. The computer-readable storage medium of claim 4, wherein generating the success report further comprises:

if the score is less than the threshold value, displaying an indication that a record has changed; and

if the score is more than the threshold value, displaying an indication that the record has not changed.

6. The computer-readable storage medium of claim 1, wherein the predetermined comparison parameter is a percentage of change value, and wherein determining whether the score meets the predetermined comparison parameter comprises determining whether the score is less than the percentage of change value.

7. The computer-readable storage medium of claim 1, wherein the comparison information comprises a second identifier of the target data store, and wherein the first identifier and the second identifier of the target data store correspond to different relational tables of the target data store.

8. The computer-readable storage medium of claim 1, wherein:

comparing the customer data identified by the first identifier of the source data store to the data identified by the first identifier of the target data store further comprises;

determining a first value of the customer data identified by the first identifier of the source data store; and

determining a second value of the data identified by the first identifier of the target data store; and

generating the score based on the difference further comprises;

generating a difference between the first value and the second value, wherein the score is the generated difference.

9. The computer-readable storage medium of claim 8, wherein:

determining whether the score meets the predetermined comparison parameter further comprises;

determining that the generated difference is less than the predetermined comparison parameter; and

the success report is generated in response to determining that the generated difference is less than the predetermined comparison parameter.

10. The computer-readable storage medium of claim 1, wherein the comparing the customer data identified by the first identifier of the source data store to the data identified by the first identifier of the target data store further comprises:

copying the customer data identified by the first identifier of the source data store to a local data store;

copying the data identified by the first identifier of the target data store to the local data store; and

comparing the copied data identified by the first identifier of the source data store to the copied data identified by the first identifier of the target data store.

11. A method comprising:

connecting to a source database system;

connecting to a target database system;

using comparison information to identify a mapping of a first identifier of the source database system to a first identifier of the target database system, wherein the first identifier of the source database system identifies customer data in the source database system, and wherein a second identifier of the source database system identifies a last-updated date in the source database system;

transitioning the customer data identified by the first identifier of the source database system from the source database system to the target database system according to the comparison information, wherein the transitioning is based on a determination that the last-updated date is more recent than a predetermined date;

retrieving the customer data from the source database system and data from the target database system to a local data store, according to the comparison information;

comparing the customer data retrieved from the source database system to the data retrieved from the target database system;

based on the comparing, generating, using an electronic processor, a score based on a difference between the customer data retrieved from the source database system and the data retrieved from the target database system;

determining whether the score meets a predetermined comparison threshold value; and

generating, using the processor, a failure report when the score fails to meet the predetermined comparison threshold value.

12. The method of claim 11, wherein the transitioning step comprises:

applying a function to the customer data identified by the first identifier of the source database system; and

copying the data resulting from the applying step to the target database system.

13. The method of claim 12, wherein the function comprises a conversion from a first currency to a second currency.

14. A system comprising at least a processor and a memory storing computer-executable instructions that when executed by the processor, cause the system to perform steps comprising:

connecting to a source database system;

connecting to a target database system;

transitioning customer data identified by a first identifier of the source database system from the source database system to the target database system according to a mapping of the first identifier of the source database system to a first identifier of the target database system, wherein the transitioning is based on a determination that a last-updated date identified by a second identifier of the source database system is more recent than a predetermined date;

comparing the customer data identified by the first identifier of the source database system to data identified by the first identifier of the target database system;

based on the comparing, generating, using the processor, a score based on a difference between the customer data identified by the first identifier of the source database system and the data identified by the first identifier of the target database system after the transitioning;

determining whether the score meets a predetermined comparison parameter; and

generating, using the processor, a successful report when the score meets the predetermined comparison parameter.

15. The system of claim 14, wherein the predetermined comparison parameter is a threshold value.

16. The system of claim 14, wherein the predetermined comparison parameter is a percentage of change value.

17. The system of claim 14, wherein the transitioning comprises:

applying a function to the customer data from the source database system; and

copying the data resulting from the applying to the target database system,

wherein the function is a conversion from a first currency to a second currency.