首页>
外国专利>
System and method for distributed SQL join processing in shared-nothing relational database clusters using self directed data streams
System and method for distributed SQL join processing in shared-nothing relational database clusters using self directed data streams
展开▼
机译:使用自指导数据流在无共享关系数据库集群中进行分布式SQL连接处理的系统和方法
展开▼
页面导航
摘要
著录项
相似文献
摘要
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.
展开▼