CREATION OF CHANGE-BASED DATA INTEGRATION JOBS
First Claim
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; and
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 not UTL jobs;
wherein;
each Simple UTL job of the intermediate set jobs meets the following criteria;
a single input action retrieves the contents of a single table, or view on a single table, in a database,contains no actions that operate on the entirety of data for a job,contains no actions that rely on ordering of data, andat least one output stage operates on a database.
1 Assignment
0 Petitions
Accused Products
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.
-
Citations
20 Claims
-
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; and 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 not UTL jobs; wherein; each Simple UTL job of the intermediate set jobs meets the following criteria; a single input action retrieves the contents of a single table, or view on a single table, in a database, contains no actions that operate on the entirety of data for a job, contains no actions that rely on ordering of data, and at least one output stage operates on a database. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8)
-
-
9. A computer program product method for transforming a first extract transform load (ETL) job having at least one unload transform load (UTL) portion, the computer program product comprising software stored on a software storage device, the software comprising:
-
first program instructions programmed to decompose the first ETL job into an intermediate set of one or more Simple UTL jobs; and second program instructions programmed to, for each Simple UTL job of the intermediate set, transform the job into a transformationally equivalent job to yield a final set of one or more jobs that are not UTL jobs; wherein; each Simple UTL job of the intermediate set jobs meets the following criteria; a single input action retrieves the contents of a single table, or view on a single table, in a database, contains no actions that operate on the entirety of data for a job, contains no actions that rely on ordering of data, and at least one output stage operates on a database; and the software is stored on a software storage device in a manner less transitory than a signal in transit. - View Dependent Claims (10, 11, 12, 13, 14, 15, 16)
-
-
17. A computer system for transforming a first extract transform load (ETL) job having at least one unload transform load (UTL) portion, the computer system comprising:
-
a processor(s) set; and a software storage device; wherein; the processor set is structured, located, connected and/or programmed to run software stored on the software storage device; and the software comprises; first program instructions programmed to decompose the first ETL job into an intermediate set of one or more Simple UTL jobs, and second program instructions programmed to, for each Simple UTL job of the intermediate set, transform the job into a transformationally equivalent job to yield a final set of one or more jobs that are not UTL jobs; wherein; each Simple UTL job of the intermediate set jobs meets the following criteria; a single input action retrieves the contents of a single table, or view on a single table, in a database, contains no actions that operate on the entirety of data for a job, contains no actions that rely on ordering of data, and at least one output stage operates on a database. - View Dependent Claims (18, 19, 20)
-
Specification