Patent ID: 8200614
Filing Date: 2012-06-12
Classification: G06F

Abstract:
1. A non-transitory computer readable storage medium, comprising executable instructions to: support the definition of an Extract Transform and Load (ETL) task, the ETL task extracting data from source tables of one or more sources, transforming the extracted data to a format compatible with a respective target of a plurality of targets, and loading the transformed data into a target table of the respective target; determine changes in the source tables by performing an evaluation of source table structures, source data change indicators, and target table structures, the source data change indicators being identified using a transaction log, the transaction log identifying changes made to a corresponding source table structure of the source tables; and convert the ETL task, based on the source data change indicators identified in the transaction log, to a delta load task in accordance with the evaluation, the delta load task automatically updating the target table of the respective target in accordance with the determined changes in the source tables, wherein the delta task is different from the ETL task and is selected, based on available system resources, from a plurality of delta load tasks that include at least one of the following: a target-based delta task, a timestamp-based delta task, a capture-data-change-based with primary key information only delta task, and a capture-data-change-based with full table structure information delta task.