Difference determination in a database environment

A computer program product 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 program product comprising:

• a computer-readable storage medium having program code embodied therewith, the program code executable by one or more computer processors to:
• determine a first set of differences between the source table and the target table at a first point in time;
• determine 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;
• and
• determine, by operation of one or more computer processors when executing the program code, at least one of:
• (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.

A system 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 system comprising:

• one or more computer processors;
• a memory containing a program which, when executed by the one or more computer processors, is configured to perform an operation comprising:
• determining a first set of differences between the source table and the target table at a first point in time;
• 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;
• and
• determining at least one of:
• (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.