Enhanced data comparison tool
First Claim
Patent Images
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.
1 Assignment
0 Petitions
Accused Products
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.
-
Citations
17 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. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8, 9, 10)
-
-
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. - View Dependent Claims (12, 13)
-
-
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. - View Dependent Claims (15, 16, 17)
-
Specification