ADAPTIVE SELECTION OF A DISTRIBUTION METHOD DURING EXECUTION OF PARALLEL JOIN OPERATIONS
    1.
    发明申请
    ADAPTIVE SELECTION OF A DISTRIBUTION METHOD DURING EXECUTION OF PARALLEL JOIN OPERATIONS 有权
    并行执行期间自适应选择分配方法

    公开(公告)号:US20140280023A1

    公开(公告)日:2014-09-18

    申请号:US13839399

    申请日:2013-03-15

    IPC分类号: G06F17/30

    CPC分类号: G06F17/30466 G06F17/30498

    摘要: A method, system, and computer program product for high-performance database systems. The method commences by estimating, during a compile phase, a statically-calculated system cost of performing parallel join operations over two relations, then selecting, during the compile phase, a first distribution method to perform the parallel join operations. Instructions (e.g., table partitioning) are communicated to two or more execution units for execution of the parallel join operations, and during execution, various measurements are taken pertaining to the performance of a first portion of the parallel join operations using the selected first distribution method. Then, responsive to the measurements a second distribution method is selected and corresponding instructions are communicated to the two or more execution units. The parallel join operations continue, now using the second distribution method.

    摘要翻译: 用于高性能数据库系统的方法,系统和计算机程序产品。 该方法通过在编译阶段估计在两个关系上执行并行连接操作的静态计算的系统成本,然后在编译阶段期间选​​择执行并行连接操作的第一分发方法来开始。 将指令(例如,表分区)传送到两个或更多个执行单元以执行并行连接操作,并且在执行期间,使用所选择的第一分配方法对并行连接操作的第一部分的性能进行各种测量 。 然后,响应于测量,选择第二分配方法,并将相应的指令传送给两个或更多个执行单元。 并行连接操作继续,现在使用第二个分发方法。