Unified database insights platform for hybrid cloud

A system for generating queries in a heterogeneous cloud computing environment, the system comprising:

• a storage device that stores program instructions;
• one or more processors operably connected to the storage device and configured to execute the program instructions to cause the system to:
• transform disparate statistical formats into a unified representation to standardize statistical metadata between relational databases and NoSQL databases;
• integrate SQL-derived NoSQL statistics into a unified repository according to the unified representation;
• integrate mapped NoSQL statistics into relational database query optimizers;
• determine, according to the standardized statistical metadata, an optimal predicate pushdown strategy for a query across heterogeneous databases;
• determine, according to the standardized statistical metadata, an execution plan for the query across heterogeneous databases;
• and
• execute the query to the heterogeneous databases according to the relational database query optimizers and the optimal pushdown strategy and execution plan.

A computer program product for generating queries in a heterogeneous cloud computing environment, the computer program product comprising:

• a persistent storage medium having program instructions configured to cause one or more processors to:
• transform disparate statistical formats into a unified representation to standardize statistical metadata between relational databases and NoSQL databases;
• integrate SQL-derived NoSQL statistics into a unified repository according to the unified representation;
• integrate mapped NoSQL statistics into relational database query optimizers;
• determine, according to the standardized statistical metadata, an optimal predicate pushdown strategy for a query across heterogeneous databases;
• determine, according to the standardized statistical metadata, an execution plan for the query across heterogeneous databases;
• and
• execute the query to the heterogeneous databases according to the relational database query optimizers and the optimal pushdown strategy and execution plan.