Patent ID: 9152669
Filing Date: 2015-10-06
Classification: G06F

Abstract:
1. A method for query processing in a massively parallel processing (MPP) database system, the method comprising: receiving, at a coordinator process that runs on the MPP, a join query associated with a plurality of tables of the MPP database system; designating, from the tables to a plurality of processing nodes of the MPP, stationary tables and non-stationary tables, wherein the join query is processed by passing at least some information stored in the non-stationary tables between the processing nodes without passing any information stored in the stationary tables between the processing nodes; and executing, at each of the processing nodes, an execution plan to obtain query results, wherein executing the execution plan comprises passing at least some data stored in the non-stationary tables between the processing nodes without passing any information stored in the stationary tables between the processing nodes.