Hash table structure for optimizing hash join operations in a relational database system
US11775523B2 · kind B2 · utility
0Cited by
2References
7Claims
0Family size
Assignee
Inventors
Key dates
| Filing date | Jun 23, 2017 |
| Grant date | Oct 3, 2023 |
| Priority date | — |
| Expiry date | Oct 15, 2039 |
Classification
- Technology area (CPC G)Physics
- CPC primaryG06F16/9014
- WIPO fieldComputer technology
- WIPO sectorElectrical engineering
Abstract
An improved hash table structure compatible with in-memory processing for increasing cache efficiency during hash join processing of a small and large table in a relational database system. The hash table, residing in processor memory, includes a first partition containing a join condition column providing best selectivity for joining the small table with the large table, at least one additional partition containing additional join condition columns for joining the small table with the large table; and an array of hash values, the array of hash values providing an index into the hash table partitions.
Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.