Patent · US Active

Database independent detection of data changes

US10901977B2 · kind B2 · utility

0Cited by

6References

20Claims

0Family size

Assignee

SAP SE · DE

Inventors

Stephan Kessler · Linkenheim-Hochstetten, DE
Thomas Seufert · Oftersheim, DE
Kai Morich · Hockenheim, DE

Key dates

Filing date	May 14, 2018
Grant date	Jan 26, 2021
Priority date	—
Expiry date	Apr 5, 2039

Classification

Technology area (CPC G)Physics
CPC primaryG06F21/6254
WIPO fieldComputer technology
WIPO sectorElectrical engineering

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.

Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.