US 11,947,560 B2
Processing a federated query via data serialization
Ping Liu, Beijing (CN); and Lei Cui, Beijing (CN)
Assigned to International Business Machines Corporation, Armonk, NY (US)
Filed by International Business Machines Corporation, Armonk, NY (US)
Filed on Dec. 13, 2022, as Appl. No. 18/080,038.
Application 18/080,038 is a continuation of application No. 17/181,788, filed on Feb. 22, 2021, granted, now 11,550,812.
Prior Publication US 2023/0116692 A1, Apr. 13, 2023
This patent is subject to a terminal disclaimer.
Int. Cl. G06F 16/25 (2019.01); G06F 9/54 (2006.01); G06F 16/22 (2019.01); G06F 16/2453 (2019.01)
CPC G06F 16/256 (2019.01) [G06F 9/54 (2013.01); G06F 16/2219 (2019.01); G06F 16/24542 (2019.01); G06F 16/258 (2019.01)] 20 Claims
OG exemplary drawing
 
1. A federation server system comprising:
at least one processor; and
a memory storing an application program, which, when executed on the at least one processor, performs and operation comprising:
compiling a query received from a client computing system to generate a query statement and a query access plan, wherein the query access plan incorporates a modified database access application programming interface (API) that supports data serialization;
executing the query access plan to transmit the query statement to a remote database of a federated server system by calling the modified database access API to send the query statement and a data type mapping, wherein the data type mapping includes at least one data conversion definition for adapting respective remote database system data type formats to corresponding respective federation server system data type formats;
fetching from the remote database system a query result set from the remote database system including serialized binary large object (BLOB) data compatible with the federation server system;
deserializing the serialized BLOB data and populating an in-memory data structure with deserialized query results; and
creating and distributing a serialization library based upon the generated metadata to the remote database system.