发明名称 Load balancing for complex database query plans
摘要 Methods, systems, and apparatuses for improving performance of parallel database query plans are described. An exchange operator is positioned in a query tree. A child operator of the exchange operator is parallelized into a plurality of parallel child operators, each of the parallel child operators coupled to the exchange operator in a respective branch of a plurality of parallel branches of the query tree. An output of each of the plurality of parallel child operators may be buffered at the exchange operator. Furthermore, child operators of the plurality of parallel child operators may also be parallelized. Query plans of any form and containing any number of operators may be parallelized in this manner. Any number of parallel branches may be used, independent of the number of operators in the original plan. The parallelized query plans achieve effective load balancing across all branches.
申请公布号 US2008147599(A1) 申请公布日期 2008.06.19
申请号 US20060640396 申请日期 2006.12.18
申请人 IANYWHERE SOLUTIONS, INC. 发明人 YOUNG-LAI MATTHEW
分类号 G06F7/06 主分类号 G06F7/06
代理机构 代理人
主权项
地址