Method and apparatus for using set based structured query language (SQL) to implement extract, transform, and load (ETL) splitter operation
US8160999B2 · kind B2 · utility
49Cited by
50References
18Claims
0Family size
Assignee
Inventors
Key dates
| Filing date | Dec 13, 2006 |
| Grant date | Apr 17, 2012 |
| Priority date | — |
| Expiry date | May 31, 2030 |
Classification
- Technology area (CPC G)Physics
- CPC primaryG06F16/24537
- WIPO fieldComputer technology
- WIPO sectorElectrical engineering
Abstract
Methods and systems for implementing a splitter operation in an extract, transform, and load (ETL) process are provided. In one implementation, the method includes receiving a data flow including a splitter operation, and generating an execution plan graph based on the data flow. The execution plan graph includes structured query language (SQL) code for implementing the splitter operation, in which the structured query language (SQL) code is respectively executable among database servers associated with different vendors.
Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.