Invention Grant
- Patent Title: Skew detection and handling in a parallel processing relational database system
-
Application No.: US15858489Application Date: 2017-12-29
-
Publication No.: US10678794B2Publication Date: 2020-06-09
- Inventor: Bhashyam Ramesh , Suresh Kumar Jami
- Applicant: Teradata US, Inc.
- Applicant Address: US CA San Diego
- Assignee: Teradata US, Inc.
- Current Assignee: Teradata US, Inc.
- Current Assignee Address: US CA San Diego
- Agent James Stover
- Main IPC: G06F16/30
- IPC: G06F16/30 ; G06F16/2455 ; G06F16/21 ; G06F16/215 ; G06F16/27 ; G06F16/28 ; G06F16/22 ; G06F16/901 ; G06F16/2453 ; G06F11/14 ; G06F9/38

Abstract:
A method for detecting and handling skew and spillover in in-memory hash join operations. To improve the detection of skew and spillover in parallel processing systems, a Poisson distribution of unique hash values to Units of Parallelism (UoPs) is employed to determine the number of rows per UoP and in turn, the potential of spillover at a UoP. Hash join plan options can be selected or adjusted to reduce the likelihood of spillover.
Public/Granted literature
- US20180121563A1 SKEW DETECTION AND HANDLING IN A PARALLEL PROCESSING RELATIONAL DATABASE SYSTEM Public/Granted day:2018-05-03
Information query