发明申请
US20130073515A1 COLUMN BASED DATA TRANSFER IN EXTRACT TRANSFORM AND LOAD (ETL) SYSTEMS
有权
提取变换和负载(ETL)系统中的基于数据的数据传输
- 专利标题: COLUMN BASED DATA TRANSFER IN EXTRACT TRANSFORM AND LOAD (ETL) SYSTEMS
- 专利标题(中): 提取变换和负载(ETL)系统中的基于数据的数据传输
-
申请号: US13238145申请日: 2011-09-21
-
公开(公告)号: US20130073515A1公开(公告)日: 2013-03-21
- 发明人: Manish A. Bhide , Krishna K. Bonagiri , Srinivas K. Mittapalli
- 申请人: Manish A. Bhide , Krishna K. Bonagiri , Srinivas K. Mittapalli
- 申请人地址: US NY Armonk
- 专利权人: INTERNATIONAL BUSINESS MACHINES CORPORATION
- 当前专利权人: INTERNATIONAL BUSINESS MACHINES CORPORATION
- 当前专利权人地址: US NY Armonk
- 主分类号: G06F17/30
- IPC分类号: G06F17/30
摘要:
Executing a plurality of transform stages in an extract, transform and load (ETL) job including, for each of the transform stages, receiving a plurality of input row identifiers (RIDs) corresponding to a first plurality of source database table rows in a source database table. Data is retrieved directly from a subset of the source database table columns in the first plurality of source database table rows based on the input RIDs and transform logic. Partial row data including data from the subset of the source database table columns is generated for each of the first plurality of source database table rows. Transformed data is generated based on the partial row data and to the transform logic. Output RIDs corresponding to a second plurality of rows in the source database table that include a least a subset of the transformed data are output to a downstream stage.
公开/授权文献
信息查询