DATA COMPARISON SYSTEM
First Claim
1. A computer-implemented method for performing a tolerance based comparison between a legacy data store and a new data store, the method comprising:
- (a) receiving, by a processor from a device of a user, a compare data structure comprising of a plurality of data item pairs, each data item pair identifying a legacy data item of a legacy dataset and a new data item of a new dataset, wherein each data item pair comprises a data type of a table data type, a flat structure data type, a deep structure data type, or a field data type, further wherein the table data type, the flat structure data type and the deep structure data type each comprise a plurality of records;
(b) receiving, by the processor from the device of the user, a plurality of tolerances, each tolerance being associated with one of the data item pairs;
(c) calling, by the processor, a compare data subroutine to compare each data item pair of the plurality of data item pairs;
(d) determining, by the processor, whether the data type of each data item pair comprises the table data type, the flat structure data type, or the field data type;
(e) comparing, by the processor, each legacy data item and each new data item of each data item pair in accordance with the associated tolerance if the data type of each data item pair comprises the field data type; and
(f) otherwise, repeating, by the processor, steps (c)-(e) for each record of each data item pair until the data type of each data item pair comprises the field data type, and then comparing each legacy data item and each new data item of each data item pair in accordance with the associated tolerance.
2 Assignments
0 Petitions
Accused Products
Abstract
A data comparison system is described. The system may include a memory, an interface, and a processor. The memory may store a compare data structure containing multiple data item pairs, each pair including a legacy data item of a legacy dataset and a corresponding new data item of a new dataset, and a tolerance associated with each data item pair. The processor may receive the compare data structure and the associated tolerances. The processor may call a compare data subroutine to compare each data item pair in accordance with the associated tolerance if the data items are fields. Otherwise, the processor may recursively call the compare data subroutine for each record the data items until the data item are fields. The processor may then compare data items in accordance with the associated tolerance.
40 Citations
34 Claims
-
1. A computer-implemented method for performing a tolerance based comparison between a legacy data store and a new data store, the method comprising:
-
(a) receiving, by a processor from a device of a user, a compare data structure comprising of a plurality of data item pairs, each data item pair identifying a legacy data item of a legacy dataset and a new data item of a new dataset, wherein each data item pair comprises a data type of a table data type, a flat structure data type, a deep structure data type, or a field data type, further wherein the table data type, the flat structure data type and the deep structure data type each comprise a plurality of records; (b) receiving, by the processor from the device of the user, a plurality of tolerances, each tolerance being associated with one of the data item pairs; (c) calling, by the processor, a compare data subroutine to compare each data item pair of the plurality of data item pairs; (d) determining, by the processor, whether the data type of each data item pair comprises the table data type, the flat structure data type, or the field data type; (e) comparing, by the processor, each legacy data item and each new data item of each data item pair in accordance with the associated tolerance if the data type of each data item pair comprises the field data type; and (f) otherwise, repeating, by the processor, steps (c)-(e) for each record of each data item pair until the data type of each data item pair comprises the field data type, and then comparing each legacy data item and each new data item of each data item pair in accordance with the associated tolerance. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13)
-
-
14. A computer-implemented method for performing a tolerance based comparison between a legacy data store and a new data store, the method comprising:
-
receiving, by a processor from a device of a user, a compare data structure, wherein the compare data structure describes a plurality of mappings between a first plurality of data items of a first dataset and a second plurality of data items of a second dataset, wherein the data items comprise at least one of a table, a field, a deep structure, or a flat structure; populating, by the processor, the compare data structure with a first plurality of data items from the first dataset and the second plurality of data items from the second dataset; receiving, by the processor, a plurality of tolerances, each tolerance being associated with one of the mappings between the first plurality of data items and the second plurality of data items wherein each tolerance describes an acceptable variance for each mapping of the plurality of mappings; comparing, by the processor, the first plurality of data items in the compare data structure with the second plurality of data items in the compare structure in accordance with the plurality of mappings and the plurality of tolerances, wherein the first plurality of data items and the second plurality of data items are compared recursively if the first plurality of data items and the second plurality of data items comprise the table, the flat structure, or the deep structure; transforming, by the processor, a result of the comparing into a report, wherein the report describes a percentage of the first and second data items which were an exact match, a percentage of the first and second data items which were within the associated tolerances, and a percentage of the first and second data items which were outside the associated tolerances; and providing, by the processor to the device of the user, the report. - View Dependent Claims (15, 16, 17, 18, 19, 20, 21)
-
-
22. A data comparison system, the system comprising:
-
a memory to store a compare data structure comprising of a plurality of data item pairs, each data item pair identifying a legacy data item of a legacy dataset and a new data item of a new dataset, wherein each data item pair comprises a data type of a field data type, a table data type, a flat structure data type, or a deep structure data type, further wherein the table data type, the flat structure data type and the deep structure data type each comprise a plurality of records, and a plurality of tolerances, each tolerance being associated with one of the data item pairs; an interface operatively connected to the memory, the interface operative to communicate with a device of a user; and a processor operatively connected to the memory and the interface, the processor operative to receive, from the device of the user via the interface, the compare data structure and the plurality of tolerances, call a compare data subroutine to compare each legacy data item and each new data item identified by each data item pair, determine whether the data type of each data item pair comprises field data type, the table data type, the flat structure data type or the deep structure data type, compare each legacy data item and each new data item in accordance with the associated tolerance if the data type of each data item pair comprises the field data type, and otherwise recursively call the compare data subroutine for each record of each data item pair until the data type of each data item pair comprises the field data type, and then compare the legacy data item and the new data item of each data item pair in accordance with the associated tolerance. - View Dependent Claims (23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 33, 34)
-
Specification