Invention Grant
- Patent Title: Hash-join in parallel computation environments
- Patent Title (中): 哈希加入并行计算环境
-
Application No.: US13742034Application Date: 2013-01-15
-
Publication No.: US09177025B2Publication Date: 2015-11-03
- Inventor: Christian Bensberg , Christian Mathis , Frederik Transier , Nico Bohnsack , Kai Stammerjohann
- Applicant: SAP SE
- Applicant Address: DE Walldorf
- Assignee: SAP SE
- Current Assignee: SAP SE
- Current Assignee Address: DE Walldorf
- Agency: Buckley, Maschoff & Talwalkar LLC
- Main IPC: G06F7/00
- IPC: G06F7/00 ; G06F17/30

Abstract:
According to some embodiments, a system and method for a parallel join of relational data tables may be provided by calculating, by a plurality of concurrently executing execution threads, hash values for join columns of a first input table and a second input table; storing the calculated hash values in a set of disjoint thread-local hash maps for each of the first input table and the second input table; merging the set of thread-local hash maps of the first input table, by a second plurality of execution threads operating concurrently, to produce a set of merged hash maps; comparing each entry of the merged hash maps to each entry of the set of thread-local hash maps for the second input table to determine whether there is a match, according to a join type; and generating an output table including matches as determined by the comparing.
Public/Granted literature
- US20130138628A1 HASH-JOIN IN PARALLEL COMPUTATION ENVIRONMENTS Public/Granted day:2013-05-30
Information query