Optimizing a join operation
US11379478B2 · kind B2 · utility
Assignee
Inventors
Key dates
| Filing date | Apr 2, 2020 |
| Grant date | Jul 5, 2022 |
| Priority date | — |
| Expiry date | Apr 25, 2040 |
Classification
- Technology area (CPC G)Physics
- CPC primaryG06F16/283
- WIPO fieldComputer technology
- WIPO sectorElectrical engineering
Abstract
An approach is provided for optimizing a join operation that includes receiving, by one or more processors of a computer system, a join request associated with a fact table and a plurality of related dimension tables; identifying, by the one or more processors of the computer system, a join relationship from the fact table and the plurality of related dimension tables; matching, by the one or more processors of the computer system, different tables of the fact table and the plurality of related dimension tables; filtering, by the one or more processors of the computer system using data parallelism, the fact table and the plurality of related dimension tables, wherein the filtering occurs prior to performing the join request; and performing, by the one or more processors of the computer system, the join operation pursuant to the join request.
Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.