US 12,222,942 B2
Remote datasource-based optimization of procedure-based multi-datasource queries
Hai Jun Shen, Tianjin (CN); Chang Sheng Liu, Beijing (CN); Lei Cui, Beijing (CN); and Ya Qiong Liu, Beijing (CN)
Assigned to International Business Machines Corporation, Armonk, NY (US)
Filed by International Business Machines Corporation, Armonk, NY (US)
Filed on Sep. 24, 2021, as Appl. No. 17/483,976.
Prior Publication US 2023/0100587 A1, Mar. 30, 2023
Int. Cl. G06F 16/2453 (2019.01)
CPC G06F 16/24542 (2019.01) [G06F 16/24537 (2019.01)] 20 Claims
OG exemplary drawing
 
1. A method for optimizing multi-datasource queries in a networked computing environment, comprising:
obtaining a procedure comprising a plurality of placeholder values, that contains a set of queries designed to access a specific set of data from a plurality of datasources in a virtualized hybrid storage environment;
creating, at a data virtualization layer, a set of mapped store procedures for the set of datasources referenced in the procedure for mapping from the plurality of placeholder values based on translation of each query of the set of queries to the specific set of data, each mapped store procedure comprising a subset of queries that are applicable to a corresponding datasource from the set of queries in the procedure;
forwarding, from the data virtualization layer, each mapped store procedure of the set of mapped store procedures to the corresponding datasource for storage on the corresponding datasource; and
commencing, in response to a running of the procedure, an execution on each of the corresponding datasources of the mapped store procedure stored thereon.