Creation of change-based data integration jobs

Patent metadata

Field	Value
Publication number	US-9305067-B2
Application number	US-201313946335-A
Country	US
Kind code	B2
Filing date	Jul 19, 2013
Priority date	Jul 19, 2013
Publication date	Apr 5, 2016
Grant date	Apr 5, 2016

Abstract

A computer software implemented method for transforming a first extract transform load (ETL) job having at least some unload transform load (UTL) portions. The method includes the following steps: (i) decomposing the first ETL job into an intermediate set of one or more jobs; and (ii) for each job of the intermediate set, transforming the job into a transactionally equivalent job to yield a final set of one or more jobs. The decomposing is performed so that each job of the intermediate jobs set is a Simple UTL job. The transforming is performed so that each job of the final set includes no UTL portions.

First claim

What is claimed is:

1. A method for transforming a first extract transform load (ETL) job having at least one unload transform load (UTL) portion, the method comprising:
decomposing the first ETL job into an intermediate set of one or more Simple UTL jobs;
for each Simple UTL job of the intermediate set, transforming the job into a transformationally equivalent job to yield a final set of one or more jobs that are a set of change-based transform load (CTL) job(s);
wherein:
t…

Assignees

• IBM

Inventors

• Gorelik Alexander
• Padmanabhan Sriram K
• Spyker James D

Classifications

• G06F16/2358

  Physics · mapped topic

• G06F16/27

  Physics · mapped topic

• G06F16/00

  Physics · mapped topic

• G06F9/5005

  Physics · mapped topic

• G06F9/4881

  Physics · mapped topic