System and method for distributed query execution via query federation using semantic model query plans

A method for distributed query execution via query federation using semantic model query plans, comprising:

• providing, at a computer system including one or more processors, a cloud or data analytics environment provided thereon, said cloud or data analytics environment comprising a semantic layer that includes a semantic model of a customer's data, and a plurality of nodes operating as a federated query engine to serve analytical queries or requests from clients directed to data stored at a database;
• in response to a query associated with one or more semantic models, generating, by a node operating as a master query engine, a composite query execution plan that includes a selection of available nodes operating as query engines and having access to the one or more semantic models, so that the query is effectively partitioned and that portions of the query can be distributed to concurrently-running query engines;
• and
• distributing the portions of the query defined by the composite query execution plan to the concurrently-running query engines for parallel execution or processing.

A non-transitory computer readable storage medium, including instructions stored thereon which when read and executed by one or more computers cause the one or more computers to perform a method comprising:

• providing, at a computer system including one or more processors, a cloud or data analytics environment provided thereon, said cloud or data analytics environment comprising a semantic layer that includes a semantic model of a customer's data, and a plurality of nodes operating as a federated query engine to serve analytical queries or requests from clients directed to data stored at a database;
• in response to a query associated with one or more semantic models, generating, by a node operating as a master query engine, a composite query execution plan that includes a selection of available nodes operating as query engines and having access to the one or more semantic models, so that the query is effectively partitioned and that portions of the query can be distributed to concurrently-running query engines;
• and
• distributing the portions of the query defined by the composite query execution plan to the concurrently-running query engines for parallel execution or processing.