Patents - 12019611

12,019,611 - Method and apparatus for comparing two database tables without regard to an original order of rows in either database table

A method and system are provided for comparing a first database table and a second database table with each other to produce a table of differences therebetween. The first database table and the second database table include one or more subsets of data that are intended to match each other, and the first database table and the second database table each include multiple rows. Indicia is generated for each of the multiple rows of the first database table, and each of the multiple rows of the second database table. The generated indicia for each of the multiple rows of the first database table are compared with the generated indicia for each of the multiple rows of the second database table, wherein the comparing occurs without regard to an order of the rows in either the first database table or the second database table. Any generated indicia for each of the multiple rows of the first database table that are not present in the generated indicia for each of the multiple rows of the second database table are identified as a first set of mismatched indicia. Any generated indicia for each of the multiple rows of the second database table that are not present in the generated indicia for each of the multiple rows of the first database table are identified as a second set of mismatched indicia. The table of differences is populated with the generated indicia.