Cross-database join query
US12271379B2 · kind B2 · utility
Assignee
Inventors
Key dates
| Filing date | Jul 7, 2023 |
| Grant date | Apr 8, 2025 |
| Priority date | — |
| Expiry date | Jul 7, 2043 |
Classification
- Technology area (CPC G)Physics
- CPC primaryG06F2201/80
- WIPO fieldComputer technology
- WIPO sectorElectrical engineering
Abstract
A data virtualization layer (DV) receives a join query request related to a plurality of tables respectively stored in a plurality of distributed database servers. A plurality of candidate query plans for the join query request is generated where each of the plurality of candidate query plans indicates an order for transmitting the tables respectively stored in the database servers to the DV. For each of the plurality of candidate query plans, a query cost for the candidate query plan is calculated based on a data amount of the tables to be transmitted according to the candidate query plan. From the plurality of candidate query plans, a query plan is determined for the join query request which has a lowest query cost.
Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.