The patent badge is an abbreviated version of the USPTO patent document. The patent badge does contain a link to the full patent document.
The patent badge is an abbreviated version of the USPTO patent document. The patent badge covers the following: Patent number, Date patent was issued, Date patent was filed, Title of the patent, Applicant, Inventor, Assignee, Attorney firm, Primary examiner, Assistant examiner, CPCs, and Abstract. The patent badge does contain a link to the full patent document (in Adobe Acrobat format, aka pdf). To download or print any patent click here.
Patent No.:
Date of Patent:
Jul. 07, 2020
Filed:
Dec. 21, 2017
Applicant:
Teradata Us, Inc., Dayton, OH (US);
Inventors:
Bhashyam Ramesh, West Marredpally, IN;
Sai Pavan Kumar Pakala, Andhra Pradesh, IN;
Jaiprakash G Chimanchode, Old Alwal, IN;
Assignee:
Teradata US, Inc., San Diego, CA (US);
Attorney:
Primary Examiner:
Int. Cl.
CPC ...
G06F 16/30 (2019.01); G06F 16/2455 (2019.01); G06F 16/21 (2019.01); G06F 16/215 (2019.01); G06F 16/27 (2019.01); G06F 16/28 (2019.01); G06F 16/22 (2019.01); G06F 16/901 (2019.01); G06F 16/2453 (2019.01); G06F 11/14 (2006.01); G06F 9/38 (2018.01);
U.S. Cl.
CPC ...
G06F 16/24552 (2019.01); G06F 11/1435 (2013.01); G06F 16/211 (2019.01); G06F 16/215 (2019.01); G06F 16/2255 (2019.01); G06F 16/2456 (2019.01); G06F 16/24537 (2019.01); G06F 16/24544 (2019.01); G06F 16/278 (2019.01); G06F 16/284 (2019.01); G06F 16/9014 (2019.01); G06F 9/3887 (2013.01);
Abstract
A method for performing in-memory hash join processing. This method utilizes bulk processing within the hash join steps, such as performing bulk reads of hash values from tables to be joined, and performing bulk probes of hash values in tables to be joined, thereby providing more efficient utilization of memory bandwidth and CPU throughput, reducing memory accesses in the execution path, and reducing CPU cycles per instruction. Data movement is reduced by reducing load-stores to memory and by performing more operations in CPU cache.