公开(公告)号：US11354312B2

公开(公告)日：2022-06-07

申请号：US16554698

申请日：2019-08-29

Applicant: INTERNATIONAL BUSINESS MACHINES CORPORATION

Inventor： Chang Sheng Liu ,  Yan Li Xu ,  Hui Guo ,  Yao M. Wang ,  Hai Jun Shen ,  Ping Liu

IPC: G06F16/2453 ,  G06F16/2452 ,  G06F16/25

Abstract: A federated database-management system receives an SQL query or other type of data-access request. The federated system's host DBMS parses, rewrites, and optimizes the request into an optimal data-access plan, then determines which portions of the plan require access to data stored on the federated systems' remote databases. The federated host partitions the plan into subplans that each represent instructions of the original data-access request that were directed to a corresponding remote database of the federated DBMS. Each subplan is then transmitted to its corresponding remote database, which directly executes the subplan and returns results to the host. If necessary, a subplan is translated from an original generic access-plan format into a database-specific format required by its corresponding remote database.

公开(公告)号：US11947560B2

公开(公告)日：2024-04-02

申请号：US18080038

申请日：2022-12-13

Applicant: International Business Machines Corporation

Inventor： Ping Liu ,  Lei Cui

IPC: G06F16/25 ,  G06F9/54 ,  G06F16/22 ,  G06F16/2453

CPC classification number: G06F16/256 ,  G06F9/54 ,  G06F16/2219 ,  G06F16/24542 ,  G06F16/258

Abstract: Techniques are described with respect to processing a federated query. An associated computer-implemented method includes compiling a query received from a client computing system to generate a query statement and a query access plan. The query access plan incorporates a modified database access application programming interface (API) that supports data serialization. The method further includes executing the query access plan to transmit the query statement to a remote database system. The method further includes fetching a query result set from the remote database system including serialized binary large object (BLOB) data. The method further includes deserializing the serialized BLOB data of the query result set and populating an in-memory data structure with deserialized query results. In an embodiment, the method further includes transmitting the deserialized query results to the client computing system. In an additional embodiment, the method further includes generating query serialization capabilities for the remote database system.

公开(公告)号：US11550812B2

公开(公告)日：2023-01-10

申请号：US17181788

申请日：2021-02-22

Applicant: International Business Machines Corporation

Inventor： Ping Liu ,  Lei Cui

IPC: G06F16/25 ,  G06F16/2453 ,  G06F9/54 ,  G06F16/22

Abstract: Techniques are described with respect to processing a federated query. An associated computer-implemented method includes compiling a query received from a client computing system to generate a query statement and a query access plan. The query access plan incorporates a modified database access application programming interface (API) that supports data serialization. The method further includes executing the query access plan to transmit the query statement to a remote database system. The method further includes fetching a query result set from the remote database system including serialized binary large object (BLOB) data. The method further includes deserializing the serialized BLOB data of the query result set and populating an in-memory data structure with deserialized query results. In an embodiment, the method further includes transmitting the deserialized query results to the client computing system. In an additional embodiment, the method further includes generating query serialization capabilities for the remote database system.

公开(公告)号：US11243961B2

公开(公告)日：2022-02-08

申请号：US16693681

申请日：2019-11-25

Applicant: International Business Machines Corporation

Inventor： Ya Qiong Liu ,  Xue Huang ,  Ping Liu ,  Lei Cui ,  Ying Qi Pan

IPC: G06F16/24 ,  G06F16/2458 ,  G06F9/54 ,  G06F9/30 ,  G06F16/248

Abstract: Disclosed is a computer implemented method and related system to improve the efficiency of querying remote databases. The method includes receiving, from a host, a query, wherein the query is configured to retrieve a set of data from a remote database. The method also includes, generating an access plan, the access plan comprising a plurality of nodes wherein each node of the plurality of nodes includes a command. The method further includes determining capabilities of the remote database. The method includes executing the query and returning the set of data to the host.

公开(公告)号：US20210157810A1

公开(公告)日：2021-05-27

申请号：US16693681

申请日：2019-11-25

Applicant: International Business Machines Corporation

Inventor： Ya Qiong Liu ,  Xue Huang ,  Ping Liu ,  Lei Cui ,  Ying Qi Pan

IPC: G06F16/2458 ,  G06F16/248 ,  G06F9/30 ,  G06F9/54

Abstract: Disclosed is a computer implemented method and related system to improve the efficiency of querying remote databases. The method includes receiving, from a host, a query, wherein the query is configured to retrieve a set of data from a remote database. The method also includes, generating an access plan, the access plan comprising a plurality of nodes wherein each node of the plurality of nodes includes a command. The method further includes determining capabilities of the remote database. The method includes executing the query and returning the set of data to the host.

公开(公告)号：US20230116692A1

公开(公告)日：2023-04-13

申请号：US18080038

申请日：2022-12-13

Applicant: International Business Machines Corporation

Inventor： Ping Liu ,  Lei Cui

IPC: G06F16/25 ,  G06F16/2453 ,  G06F9/54 ,  G06F16/22

Abstract: Techniques are described with respect to processing a federated query. An associated computer-implemented method includes compiling a query received from a client computing system to generate a query statement and a query access plan. The query access plan incorporates a modified database access application programming interface (API) that supports data serialization. The method further includes executing the query access plan to transmit the query statement to a remote database system. The method further includes fetching a query result set from the remote database system including serialized binary large object (BLOB) data. The method further includes deserializing the serialized BLOB data of the query result set and populating an in-memory data structure with deserialized query results. In an embodiment, the method further includes transmitting the deserialized query results to the client computing system. In an additional embodiment, the method further includes generating query serialization capabilities for the remote database system.

公开(公告)号：US20220269691A1

公开(公告)日：2022-08-25

申请号：US17181788

申请日：2021-02-22

Applicant: International Business Machines Corporation

Inventor： Ping Liu ,  Lei Cui

IPC: G06F16/25 ,  G06F16/2453 ,  G06F16/22 ,  G06F9/54

Abstract: Techniques are described with respect to processing a federated query. An associated computer-implemented method includes compiling a query received from a client computing system to generate a query statement and a query access plan. The query access plan incorporates a modified database access application programming interface (API) that supports data serialization. The method further includes executing the query access plan to transmit the query statement to a remote database system. The method further includes fetching a query result set from the remote database system including serialized binary large object (BLOB) data. The method further includes deserializing the serialized BLOB data of the query result set and populating an in-memory data structure with deserialized query results. In an embodiment, the method further includes transmitting the deserialized query results to the client computing system. In an additional embodiment, the method further includes generating query serialization capabilities for the remote database system.

公开(公告)号：US20210064618A1

公开(公告)日：2021-03-04

申请号：US16554698

申请日：2019-08-29

Applicant: INTERNATIONAL BUSINESS MACHINES CORPORATION

Inventor： Chang Sheng Liu ,  Yan Li Xu ,  Hui Guo ,  Yao M. Wang ,  Hai Jun Shen ,  Ping Liu

IPC: G06F16/2453 ,  G06F16/25 ,  G06F16/2452

Abstract: A federated database-management system receives an SQL query or other type of data-access request. The federated system's host DBMS parses, rewrites, and optimizes the request into an optimal data-access plan, then determines which portions of the plan require access to data stored on the federated systems' remote databases. The federated host partitions the plan into subplans that each represent instructions of the original data-access request that were directed to a corresponding remote database of the federated DBMS. Each subplan is then transmitted to its corresponding remote database, which directly executes the subplan and returns results to the host. If necessary, a subplan is translated from an original generic access-plan format into a database-specific format required by its corresponding remote database.