Remote datasource-based optimization of procedure-based multi-datasource queries

A system for optimizing multi-datasource queries in a networked computing environment, comprising:

• a memory medium comprising instructions;
• a
• bus coupled to the memory medium;
• and
• a processor coupled to the bus that when executing the instructions causes the system to perform a method, 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.

A computer program product embodied in a computer readable storage medium that implements a method for optimizing multi-datasource queries in a networked computing environment, the method 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.