# US 2009/0276449 A1 · Apparatus and method to transform an extract transform and load (etl) task into a delta load task

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

- Number: US 2009/0276449 A1
- Document ID: US20090276449A1
- Status: Published application
- Kind: A1
- Application number: 12/113,177
- Filed: 2008-04-30
- Published: 2009-11-05
- Earliest claimed: 2008-04-30
- Assignees: Business Objects, S.A.
- Inventors: Awez SYED; Werner DAEHN
- Web page: https://patentgrep.com/patent/US20090276449A1

## CPC

- G06F 16/2453: Query optimisation
- G06F: ELECTRIC DIGITAL DATA PROCESSING (computer systems based on specific computational models G06N)

## Abstract

A computer readable storage medium includes executable instructions to support the definition of an Extract Transform and Load (ETL) task. An evaluation of source table structures, source data change indicators, and target table structures is performed. The ETL task is converted to a delta load task in accordance with the evaluation.

## Claims

### Claim 1

A computer readable storage medium, comprising executable instructions to:
support the definition of an Extract Transform and Load (ETL) task;
perform an evaluation of source table structures, source data change indicators, and target table structures; and
convert the ETL task to a delta load task in accordance with the evaluation.

### Claim 2 (depends on 1)

The computer readable storage medium of claim 1 wherein the evaluation identifies an absence of source data change indicators.

### Claim 3 (depends on 2)

The computer readable storage medium of claim 2 further comprising executable instructions to specify a delta load task to read all source tables, apply data transformations and perform a table comparison operation before loading data into a target table.

### Claim 4 (depends on 1)

The computer readable storage medium of claim 1 wherein the evaluation identifies a source data change indicators in the form of time stamps.

### Claim 5 (depends on 4)

The computer readable storage medium of claim 4 further comprising executable instructions to specify a delta load task to read sub-sets of source table entries, apply data transformations and perform a table comparison operation before loading data into a target table.

### Claim 6 (depends on 5)

The computer readable storage medium of claim 5 further comprising executable instructions to create joins between change records and source table entries.

### Claim 7 (depends on 6)

The computer readable storage medium of claim 6 further comprising executable instructions to make split data sets distinct.

### Claim 8 (depends on 6)

The computer readable storage medium of claim 6 further comprising executable instructions to create joins with time delimited where clauses.

### Claim 9 (depends on 1)

The computer readable storage medium of claim 1 wherein the evaluation identifies source data change indicators in the form of transaction log resources specifying data changes.

### Claim 10 (depends on 9)

The computer readable storage medium of claim 9 further comprising executable instructions to specify a delta load task to join selected rows of changed data.

### Claim 11 (depends on 9)

The computer readable storage medium of claim 9 further comprising executable instructions to roll up multiple data changes.

### Claim 12 (depends on 9)

The computer readable storage medium of claim 9 further comprising executable instructions to assess primary key and join clause information to identify table dependency.

### Claim 13 (depends on 1)

The computer readable storage medium of claim 1 wherein the evaluation identifies transaction log resources specifying complete source replication data.

### Claim 14 (depends on 13)

The computer readable storage medium of claim 13 further comprising executable instructions to specify a delta load task based solely upon transaction log resources.

### Claim 15 (depends on 1)

The computer readable storage medium of claim 1 further comprising executable instructions to process change records and source records to establish a mapping to a target.

### Claim 16 (depends on 1)

The computer readable storage medium of claim 1 further comprising executable instructions to identify all changes required in the target.

### Claim 17 (depends on 1)

The computer readable storage medium of claim 1 further comprising executable instructions to process cached segments of insert and update data.
