Patent · US Active

Joining remote tables by a federated server

US11681709B2 · kind B2 · utility

0Cited by

4References

18Claims

0Family size

Assignee

International Business Machines Corporation · US

Inventors

Chang Sheng Liu · Shanghai, CN
Ya Qiong Liu · Beijing, CN
Lei Cui · Shandong, CN

Key dates

Filing date	Feb 10, 2021
Grant date	Jun 20, 2023
Priority date	—
Expiry date	Feb 10, 2041

Classification

Technology area (CPC G)Physics
CPC primaryG06F16/256
WIPO fieldComputer technology
WIPO sectorElectrical engineering

Abstract

A system and method of joining remote tables by a federated server is provided. A method includes receiving a data join request from a client device; sending a first block fetch request to a first data source based on the data join request; receiving a first set of block data from the first data source; sending a second block fetch request to a second data source based on the data join request and a bind array containing the data of join column in the first data source; receiving a second set of block data from the second data source; and sending an output to the client device in response to the data join request in the form of rows from an outer table and an inner table.

Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.