Patterson + Sheridan, LLP
Database table comparison
Techniques are disclosed for comparing database tables. In one embodiment, the database tables are partitioned. Queries are generated for retrieving each partition. For each generated query, a stored procedure is invoked, using the respective generated query as an input parameter to the stored procedure. The stored procedure is configured to generate a checksum based on the partition retrieved from executing the respective query. The application compares the generated checksums to determine if the partitions and/or tables are consistent.
INTERNATIONAL BUSINESS MACHINES CORPORATION
G
G06F
inventional
Marcel Serge Xiao Jonathan
Kutsch Bourbonnais Li Wierenga