Advanced multiprovider optimization

A computer-implemented method, comprising:

• at least one hardware data processor;
• and
• at least one memory storing instructions which, when executed by the at least one hardware data processor, result in operations comprising:
• determining, by a calculation engine of a database management system, an incompatibility caused by a calculation scenario including operations on a multiprovider, the multiprovider including a first data source having at least one operation that is incompatible with a second data source, such that incompatibility causes the first data source and the second data source to use, at least in part, different approaches for optimization of the calculation scenario, wherein a first node corresponding to a first operation includes a filter and a hierarchy join that are incompatible with the second data source, and wherein the least one operation comprises the first operation;
• in response to the determining of the incompatibility, splitting, by the calculation engine, the multiprovider into at least the first node and a second node, the first node corresponding to the first operation performable using a first optimization strategy compatible with the first data source, and the second node corresponding to a second operation performable using a second optimization strategy compatible with the second data source;
• performing, by the calculation engine, the first operation at the first data source to produce a first result;
• performing, by the calculation engine, the second operation at the second data source to produce a second result;
• merging, by the calculation engine, the first result and the second result into a third operation;
• and
• performing the third operation at the first data source.

A non-transitory computer-readable medium storing instructions, which when executed by at least one data processor, result in operations comprising:

• determining, by a calculation engine of a database management system, an incompatibility caused by a calculation scenario including operations on a multiprovider, the multiprovider including a first data source having at least one operation that is incompatible with a second data source, such that incompatibility causes the first data source and the second data source to use, at least in part, different approaches for optimization of the calculation scenario, wherein a first node corresponding to a first operation includes a filter and a hierarchy join that are incompatible with the second data source, and wherein the least one operation comprises the first operation;
• in response to the determining of the incompatibility, splitting, by the calculation engine, the multiprovider into at least the first node and a second node, the first node corresponding to the first operation performable using a first optimization strategy compatible with the first data source, and the second node corresponding to a second operation performable using a second optimization strategy compatible with the second data source;
• performing, by the calculation engine, the first operation at the first data source to produce a first result;
• performing, by the calculation engine, the second operation at the second data source to produce a second result;
• merging, by the calculation engine, the first result and the second result into a third operation;
• and
• performing the third operation at the first data source.