Method for performing in-memory hash join processing in relational database systems

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 utilizati...

Full description

Saved in:
Bibliographic Details
Main Authors Pakala, Sai Pavan Kumar, Chimanchode, Jaiprakash G, Ramesh, Bhashyam
Format Patent
LanguageEnglish
Published 07.07.2020
Subjects
CALCULATING
COMPUTING
COUNTING
ELECTRIC DIGITAL DATA PROCESSING
PHYSICS
Online AccessGet full text

Cover

More Information
Summary: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.
Bibliography:Application Number: US201715849881