METHOD AND APPARATUS FOR GENERATING CODE FOR AN EXTRACT, TRANSFORM, AND LOAD (ETL) DATA FLOW
Patent №
US 8,099,725
Granted
2012-01-17
Filed 2006
Owner
INTERNATIONAL BUSINESS MACHINES CORPORATION
Lab
AI components
1
hardware
Assignment
Recorded
Dataset
AIPD
2023_r1 edition
Application
11548659
Methods, computer program products, and system for generating code for an extract, transform, and load (ETL) data flow are provided. In one implementation, the method includes receiving an ETL data flow representing a logical transformation and flow of data, placing a staging table at a pre-determined location in the ETL data flow to reduce a total number of staging tables required by the transformation, and generating code for the transformation based on the ETL data flow including the staging table placed at the pre-determined location.
AI classification
Ownership
INTERNATIONAL BUSINESS MACHINES CORPORATION
assignment · 187730490
Assignors
JIN, QI, LIAO, HUI, XU, LIN
On an employer assignment, the assignors are typically the inventors.