发明授权
US08160999B2 Method and apparatus for using set based structured query language (SQL) to implement extract, transform, and load (ETL) splitter operation
失效
使用基于集合的结构化查询语言（SQL）来实现提取，转换和加载（ETL）分离器操作的方法和装置
- 专利标题： Method and apparatus for using set based structured query language (SQL) to implement extract, transform, and load (ETL) splitter operation
- 专利标题（中）： 使用基于集合的结构化查询语言（SQL）来实现提取，转换和加载（ETL）分离器操作的方法和装置
-
申请号： US11610480申请日： 2006-12-13
-
公开(公告)号： US08160999B2公开(公告)日： 2012-04-17
- 发明人: Qi Jin , Hui Liao , Sriram K. Padmanabhan , Lin Xu
- 申请人： Qi Jin , Hui Liao , Sriram K. Padmanabhan , Lin Xu
- 申请人地址： US NY Armonk
- 专利权人： International Business Machines Corporation
- 当前专利权人： International Business Machines Corporation
- 当前专利权人地址： US NY Armonk
- 代理机构： Patterson & Sheridan, LLP
- 主分类号： G06F7/00
- IPC分类号： G06F7/00
摘要：
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.