Invention Grant
- Patent Title: Boomerang join: a network efficient, late-materialized, distributed join technique
-
Application No.: US15720442Application Date: 2017-09-29
-
Publication No.: US10397317B2Publication Date: 2019-08-27
- Inventor: Cagri Balkesen , Sam Idicula , Nipun Agarwal
- 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: Hickman Palermo Becker Bingham LLP
- Main IPC: H04L29/08
- IPC: H04L29/08 ; G06F16/27 ; H04L9/00 ; H04L9/06 ; G06F16/2455 ; G06F16/2458

Abstract:
Embodiments comprise a distributed join processing technique that reduces the data exchanged over the network. Embodiments first evaluate the join using a partitioned parallel join based on join tuples that represent the rows that are to be joined to produce join result tuples that represent matches between rows for the join result. Embodiments fetch, over the network, projected columns from the appropriate partitions of the tables among the nodes of the system using the record identifiers from the join result tuples. To further conserve network bandwidth, embodiments perform an additional record-identifier shuffling phase based on the respective sizes of the projected columns from the relations involved in the join operation. Specifically, the result tuples are shuffled such that transmitting projected columns from the join relation with the larger payload is avoided and the system need only exchange, over the network, projected columns from the join relation with the smaller payload.
Public/Granted literature
- US20190104175A1 BOOMERANG JOIN: A NETWORK EFFICIENT, LATE-MATERIALIZED, DISTRIBUTED JOIN TECHNIQUE Public/Granted day:2019-04-04
Information query