Method and apparatus for generating code for an extract, transform, and load (ETL) data flow
US8099725B2 · kind B2 · utility
16Cited by
29References
18Claims
0Family size
Assignee
Inventors
Key dates
| Filing date | Oct 11, 2006 |
| Grant date | Jan 17, 2012 |
| Priority date | — |
| Expiry date | Jun 11, 2030 |
Classification
- Technology area (CPC G)Physics
- CPC primaryG06F16/2433
- WIPO fieldComputer technology
- WIPO sectorElectrical engineering
Abstract
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.
Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.