Patent ID: 9529881
Filing Date: 2016-12-27
CPC Classification: G06F

Claim Text:
1. A computer-implemented method to programmatically determine differences between a source table and a target table in a database environment, as being persistent or transient, and based on sets of differences from different points in time, the computer-implemented method comprising: determining a first set of differences between the source table and the target table at a first point in time, wherein the database environment comprises a replication environment; determining a second set of differences between the source table and the target table at a second point in time subsequent to the first point in time by at least a predefined interval; determining, by operation of one or more computer processors, without suspending application access to the source and target tables, and without any changing any schema of the source and target tables: (i) a set of persistent differences comprising a set intersection of the first and second sets of differences, wherein the set intersection is filtered based on matching non-key values of differences in the set intersection; and (ii) a set of transient differences comprising a relative complement of the second set of differences in the first set of differences; outputting an indication of each difference in the set of persistent differences as being persistent; and outputting an indication of each difference in the set of transient differences as being transient.