Invention Grant
US08160999B2 Method and apparatus for using set based structured query language (SQL) to implement extract, transform, and load (ETL) splitter operation
失效
使用基于集合的结构化查询语言（SQL）来实现提取，转换和加载（ETL）分离器操作的方法和装置
- Patent Title: Method and apparatus for using set based structured query language (SQL) to implement extract, transform, and load (ETL) splitter operation
- Patent Title (中): 使用基于集合的结构化查询语言（SQL）来实现提取，转换和加载（ETL）分离器操作的方法和装置
-
Application No.: US11610480Application Date: 2006-12-13
-
Publication No.: US08160999B2Publication Date: 2012-04-17
- Inventor: Qi Jin , Hui Liao , Sriram K. Padmanabhan , Lin Xu
- Applicant: Qi Jin , Hui Liao , Sriram K. Padmanabhan , Lin Xu
- 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
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.
Public/Granted literature
Information query
