SAP SE
Database independent detection of data changes

Abstract:

Techniques are described for identifying changes to databases. In one example, a table associated with a data set is identified containing at least one entry, each entry associated with a sequence column value. The sequence column value for new entries is automatically incremented by one from a last max value. At time T1, a total entry count and a maximum sequence column value of the entries is calculated and stored in metadata. At time T2 later than T1, a total entry count and a maximum sequence column value in the table is calculated and compared to the previously stored values. If the values are the same, the table has not changed; if the values are different, then a change has been made. In response to a determined change, the calculated total entry count and the maximum sequence column value at T2 is stored in the metadata.