Integration of Relational Calculation Views into a Relational Engine

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 a plurality of calculation views, the plurality of calculation views comprising one or more relational operations;
• determining, by the calculation engine, whether a first calculation view includes a second calculation view configured as an operand of the one or more relational operations of the first calculation view, the plurality of calculation views comprising the first and second calculation views;
• determining, by the calculation engine, whether the second calculation view comprises a non-relational operation;
• converting, by the calculation engine, the plurality of calculation views into a relational calculation plan, the converting comprising:
• merging the first calculation view with the second calculation view, when the first calculation view is determined to include the second calculation view configured as the operand, and
• replacing the second calculation view with a view search operation, when the second calculation view is determined to comprise the non-relational operation.

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 a plurality of calculation views, the plurality of calculation views comprising one or more relational operations;
• determining, by the calculation engine, whether a first calculation view includes a second calculation view configured as an operand of the one or more relational operations of the first calculation view, the plurality of calculation views comprising the first and second calculation views;
• determining, by the calculation engine, whether the second calculation view comprises a non-relational operation;
• converting, by the calculation engine, the plurality of calculation views into a relational calculation plan, the converting comprising:
• merging the first calculation view with the second calculation view, when the first calculation view is determined to include the second calculation view configured as the operand, and
• replacing the second calculation view with a view search operation, when the second calculation view is determined to comprise the non-relational operation.