- 专利标题: Sideways information passing
-
申请号: US13155232申请日: 2011-06-07
-
公开(公告)号: US10380269B2公开(公告)日: 2019-08-13
- 发明人: Chuck Bear , Lakshmikant Shrinivas , Andrew Lamb
- 申请人: Chuck Bear , Lakshmikant Shrinivas , Andrew Lamb
- 申请人地址: US CA Sunnyvale
- 专利权人: ENTIT SOFTWARE LLC
- 当前专利权人: ENTIT SOFTWARE LLC
- 当前专利权人地址: US CA Sunnyvale
- 主分类号: G06F17/30
- IPC分类号: G06F17/30
摘要:
Methods, systems and program products for query optimization using sideways information passing. In one implementation, a join clause in a query is identified that specifies an outer table of tuples to be joined with an inner table, the outer table having one or more attributes, and each of the attributes of the outer table having values stored in an attribute file that is distinct from attribute files in which the values of other attributes are stored. A plan for the query is created which, when executed, causes selection of a subset of tuples of the outer table to serve as input to the join clause in place of the outer table based on one or more predicates applied to the inner table.
公开/授权文献
- US20120317094A1 Sideways Information Passing 公开/授权日:2012-12-13
信息查询