Invention Grant
- Patent Title: Adaptive selection of a distribution method during execution of parallel join operations
-
Application No.: US13839399Application Date: 2013-03-15
-
Publication No.: US10019481B2Publication Date: 2018-07-10
- Inventor: Unmesh Jagtap , Andrew Witkowski , Mohamed Zait , Allison Waingold Lee , Hari Sankar Sivarama Subramaniyan , Thierry Cruanes
- Applicant: ORACLE INTERNATIONAL CORPORATION
- Applicant Address: US CA Redwood Shores
- Assignee: Oracle International Corporation
- Current Assignee: Oracle International Corporation
- Current Assignee Address: US CA Redwood Shores
- Agency: Vista IP Law Group, LLP
- Main IPC: G06F17/30
- IPC: G06F17/30

Abstract:
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.
Public/Granted literature
- US20140280023A1 ADAPTIVE SELECTION OF A DISTRIBUTION METHOD DURING EXECUTION OF PARALLEL JOIN OPERATIONS Public/Granted day:2014-09-18
Information query