Patent ID: 11687559

Abstract:
Computer system compares data across two data sources. Database connectivity drivers access the first and second data sources. RAM receives and stores data from each of the first and second data sources accessed by the drivers. The data from the first data source are stored in a first table in the RAM and data from the second data source are stored in a second table in the RAM. A processor compares data in the first and second tables. The processor is programmed to compare the data by identifying a set of primary keys across the first and second tables. The set of primary keys are a set of one or more columns in the both first and second tables that uniquely identify rows across both the first and second tables. The processor then compares the data in the first and second tables, which comparison can include: determining, based on the identified set of primary keys, a total number of mismatched cell values across the first and second tables; and computing a score for the comparison of the first and second tables, where the score is computed based on the total number of mismatched cell values. The computer system can then generate an electronic comparison report based on the comparing of the first table and second table.