发明申请
- 专利标题： Apparatus and method for optimizing a union database query
- 专利标题（中）： 用于优化联合数据库查询的装置和方法
-
申请号： US10948775申请日： 2004-09-23
-
公开(公告)号： US20060064407A1公开(公告)日： 2006-03-23
- 发明人: John Santosuosso
- 申请人： John Santosuosso
- 申请人地址： US NY ARMONK
- 专利权人： INTERNATIONAL BUSINESS MACHINES CORPORATION
- 当前专利权人： INTERNATIONAL BUSINESS MACHINES CORPORATION
- 当前专利权人地址： US NY ARMONK
- 主分类号： G06F17/30
- IPC分类号： G06F17/30 ; G06F7/00
摘要：
An apparatus and method optimize a UNION-type query, where the query has common components on both sides of the UNION-type operator. The UNION-type expression is analyzed to determine if the expression can be optimized, and if so, common portions on both sides of the UNION-type expression are extracted and the expression is reformulated so the common portions on both sides of the union expression are only run one time.
公开/授权文献
- US07475064B2 Optimizing a union database query 公开/授权日：2009-01-06
信息查询
