Handling null values in processing join operations during query execution
US12353418B2 · kind B2 · utility
Assignee
Inventors
Key dates
| Filing date | May 31, 2023 |
| Grant date | Jul 8, 2025 |
| Priority date | — |
| Expiry date | Sep 19, 2043 |
Classification
- Technology area (CPC G)Physics
- CPC primaryG06F16/24544
- WIPO fieldComputer technology
- WIPO sectorElectrical engineering
Abstract
A database system is operable to determine a query that includes a join expression for execution. A set of input rows are dispersed for processing via a plurality of parallelized join processes in conjunction with executing the join expression based on identifying a first proper subset of the set of input rows based on a null-handling strategy. First rows in the first proper subset are dispersed for processing across the plurality of parallelized join processes in accordance with the null-handling strategy. second rows in a set difference between the set of input rows and the first proper subset are dispersed across the plurality of parallelized join processes in accordance with a join key-based assignment strategy. The set of input rows are processed via the plurality of parallelized join processes.
Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.