Invention Grant
US08214324B2 Generating extract, transform, and load (ETL) jobs for loading data incrementally
失效
生成提取,变换和加载(ETL)作业以逐步加载数据
- Patent Title: Generating extract, transform, and load (ETL) jobs for loading data incrementally
- Patent Title (中): 生成提取,变换和加载(ETL)作业以逐步加载数据
-
Application No.: US12547326Application Date: 2009-08-25
-
Publication No.: US08214324B2Publication Date: 2012-07-03
- Inventor: Thomas Joerg , Albert Maier , Oliver Suhre
- Applicant: Thomas Joerg , Albert Maier , Oliver Suhre
- Applicant Address: US NY Armonk
- Assignee: International Business Machines Corporation
- Current Assignee: International Business Machines Corporation
- Current Assignee Address: US NY Armonk
- Agency: Patterson & Sheridan, LLP
- Main IPC: G06F7/00
- IPC: G06F7/00 ; G06F17/00

Abstract:
Systems, methods and articles of manufacture are disclosed for generating an incremental ETL job from an instance of an abstract ETL operator model representing an exhaustive ETL job for loading data from a source schema to a target schema. In one embodiment, the abstract operator model may be extended to include incremental variants of operators of the abstract ETL operator model. From the instance of the abstract ETL operator model and from the extended ETL operator model, a corresponding instance of the extended ETL operator model may be generated. An incremental ETL job may be deployed from the instance of the extended ETL operator model. The incremental ETL job may be executed to load data from the source schema to the target schema.
Public/Granted literature
- US20110055147A1 GENERATING EXTRACT, TRANSFORM, AND LOAD (ETL) JOBS FOR LOADING DATA INCREMENTALLY Public/Granted day:2011-03-03
Information query