Invention Grant
US09576026B2 System and method for distributed SQL join processing in shared-nothing relational database clusters using self directed data streams
有权
使用自定义数据流的无共享关系数据库集群中的分布式SQL连接处理的系统和方法
- Patent Title: System and method for distributed SQL join processing in shared-nothing relational database clusters using self directed data streams
- Patent Title (中): 使用自定义数据流的无共享关系数据库集群中的分布式SQL连接处理的系统和方法
-
Application No.: US13802023Application Date: 2013-03-13
-
Publication No.: US09576026B2Publication Date: 2017-02-21
- Inventor: Mohan Singamshetty , Yang Sun , Qingqing Zhou
- Applicant: FutureWei Technologies, Inc.
- Applicant Address: US TX Plano
- Assignee: Futurewei Technologies, Inc.
- Current Assignee: Futurewei Technologies, Inc.
- Current Assignee Address: US TX Plano
- Agency: Slater Matsil, LLP
- Main IPC: G06F17/30
- IPC: G06F17/30

Abstract:
System and method embodiments are provided for improving the performance of query processing in a massively parallel processing (MPP) database system by pushing down join query processing to data nodes recursively. An embodiment method includes receiving, at a coordinator process, a join query associated with a plurality of tables of the MPP database system, generating, at the coordinator process, an execution plan tree for the join query, and processing, at each of a plurality of data nodes communicating with the coordinator process, the execution plan tree to obtain join query results. The method further includes, upon detecting a next join operator below a top join operator in the execution plan tree at each of the data nodes, forwarding to the other data nodes a sub-tree for the next join operator, and receiving, at each of the data nodes from the other data nodes, sub-tree processing results.
Public/Granted literature
Information query