# US 2018/0025042 A1 · Title: automatic delta query support for backend databases

> Agents: this data is available as JSON from the patentgrep API and MCP server — see https://patentgrep.com/llms.txt

- Number: US 2018/0025042 A1
- Document ID: US20180025042A1
- Status: Published application
- Kind: A1
- Application number: 15/214,692
- Filed: 2016-07-20
- Published: 2018-01-25
- Earliest claimed: 2016-07-20
- Assignees: Sap SE
- Applicants: Sap SE
- Inventors: Andre Fischer; Matthias De la Roche
- Web page: https://patentgrep.com/patent/US20180025042A1

## CPC

- G06F 40/169: Annotation, e.g. comment data or footnotes
- G06F 16/2455: Query execution
- G06F 16/24573: {using data annotations, e.g. user-defined metadata}
- G06F: ELECTRIC DIGITAL DATA PROCESSING (computer systems based on specific computational models G06N)

## Abstract

The present disclosure involves systems, software, and computer implemented methods for automatically providing delta query support for backend databases. One example method includes identifying annotations for a data set. The annotations indicate data fields of the data set to be used for a delta calculation. A request for a delta calculation is received for the data set. A set of delta calculation queries are automatically generated based on the annotations and a set of query templates in response to the request for the delta calculation. The set of delta calculation queries are executed to generate a delta calculation result. The automatically generated delta calculation result is provided in response to the request for the delta calculation.

## Claims

### Claim 1

A computer-implemented method, the method comprising:
identifying annotations for a data set, the annotations indicating data fields of the data set to be used for a delta calculation;
receiving a request for a delta calculation for the data set;
automatically generating a set of delta calculation queries based on the annotations and a set of query templates in response to the request for the delta calculation;
executing the set of delta calculation queries to generate a delta calculation result; and
providing the automatically generated delta calculation result in response to the request for the delta calculation.

### Claim 2 (depends on 1)

The method of claim 1, wherein the annotations indicate data fields that respectively include, for a given record of the data set, a creation time, a changed time, and a deletion indicator.

### Claim 3 (depends on 1)

The method of claim 1, wherein the request for the delta calculation includes a delta token.

### Claim 4 (depends on 1)

The method of claim 1, wherein the delta token is a timestamp that indicates a time at which a previous delta calculation was performed for the data set.

### Claim 5 (depends on 1)

The method of claim 1, wherein the delta calculation result includes data associated with records that have been added to, changed in, or deleted from the data set since a time represented by the delta token.

### Claim 6 (depends on 1)

The method of claim 1, wherein the data set is a database view.

### Claim 7 (depends on 1)

The method of claim 1, wherein the data set is a database table.

### Claim 8 (depends on 1)

The method of claim 1, further comprising automatically generating a second set of delta calculation queries based on the same set of query templates and second, different annotations identified for a second, different data set.

### Claim 9

A system comprising:
one or more computers associated with an enterprise portal; and
a computer-readable medium coupled to the one or more computers having instructions stored thereon which, when executed by the one or more computers, cause the one or more computers to perform operations comprising:
identifying annotations for a data set, the annotations indicating data fields of the data set to be used for a delta calculation;
receiving a request for a delta calculation for the data set;
automatically generating a set of delta calculation queries based on the annotations and a set of query templates in response to the request for the delta calculation;
executing the set of delta calculation queries to generate a delta calculation result; and
providing the automatically generated delta calculation result in response to the request for the delta calculation.

### Claim 10 (depends on 9)

The system of claim 9, wherein the annotations indicate data fields that respectively include, for a given record of the data set, a creation time, a changed time, and a deletion indicator.

### Claim 11 (depends on 9)

The system of claim 9, wherein the request for the delta calculation includes a delta token.

### Claim 12 (depends on 9)

The system of claim 9, wherein the delta token is a timestamp that indicates a time at which a previous delta calculation was performed for the data set.

### Claim 13 (depends on 9)

The system of claim 9, wherein the delta calculation result includes data associated with records that have been added to, changed in, or deleted from the data set since a time represented by the delta token.

### Claim 14 (depends on 9)

The system of claim 9, the operations further comprising automatically generating a second set of delta calculation queries based on the same set of query templates and second, different annotations identified for a second, different data set.

### Claim 15

A computer program product encoded on a non-transitory storage medium, the product comprising non-transitory, computer readable instructions for causing one or more processors to perform operations comprising:
identifying annotations for a data set, the annotations indicating data fields of the data set to be used for a delta calculation;
receiving a request for a delta calculation for the data set;
automatically generating a set of delta calculation queries based on the annotations and a set of query templates in response to the request for the delta calculation;
executing the set of delta calculation queries to generate a delta calculation result; and
providing the automatically generated delta calculation result in response to the request for the delta calculation.

### Claim 16 (depends on 15)

The computer program product of claim 15, wherein the annotations indicate data fields that respectively include, for a given record of the data set, a creation time, a changed time, and a deletion indicator.

### Claim 17 (depends on 15)

The computer program product of claim 15, wherein the request for the delta calculation includes a delta token.

### Claim 18 (depends on 15)

The computer program product of claim 15, wherein the delta token is a timestamp that indicates a time at which a previous delta calculation was performed for the data set.

### Claim 19 (depends on 15)

The computer program product of claim 15, wherein the delta calculation result includes data associated with records that have been added to, changed in, or deleted from the data set since a time represented by the delta token.

### Claim 20 (depends on 15)

The computer program product of claim 15, the operations further comprising automatically generating a second set of delta calculation queries based on the same set of query templates and second, different annotations identified for a second, different data set.
