Relational Conversion of Multiprovider Operations in a Calculation Scenario for Executing a Query

A non-transitory computer program product storing instructions which, when executed by at least one hardware data processors, result in operations comprising:

• receiving, at a calculation engine of a database management system, a calculation scenario including one or more relational operations and one or more non-relational operations of a multiprovider, the multiprovider utilizing a plurality of database partitions;
• processing, by the calculation engine, the one or more non-relational operations via the multiprovider;
• and
• converting, by the calculation engine, after the processing, the one or more relational operations, the converting comprising:
• filtering first data from the plurality of partitions to form second data,
• forming third data by performing a union operation on the second data, and
• filtering the third data to form fourth data.

A system comprising:

• at least one hardware data processor;
• and
• at least one memory storing instructions which, when executed by the at least one data processor, result in operations comprising:
• receiving, at a calculation engine of a database management system, a calculation scenario including one or more relational operations and one or more non-relational operations of a multiprovider, the multiprovider utilizing a plurality of database partitions;
• processing, by the calculation engine, the one or more non-relational operations via the multiprovider;
• and
• converting, by the calculation engine, after the processing, the one or more relational operations, the converting comprising:
• filtering first data from the plurality of partitions to form second data,
• forming third data by performing a union operation on the second data, and
• filtering the third data to form fourth data.