Calculation Engine Optimizations for Join Operations Utilizing Automatic Detection of Forced Constraints

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 hierarchical join, the hierarchical join comprising a plurality of join operations defining an intersection between at least two nodes in the hierarchical join;
• determining, by the calculation engine, whether a cardinality of a first join of the plurality of join operations is above a threshold;
• optimizing, by the calculation engine, the first join in response to determining the cardinality of the first join is above the threshold, the optimizing comprising:
• determining whether an attribute, other than a join attribute, is requested from a first node of the first join or a second node of the first join, the at least two nodes comprising the first node and the second node,
• detecting whether a static filter is present for the first node or the second node, and
• pruning the first node and/or the second node from the hierarchical join when the attribute is not requested from the first node or the second node and/or when the static filter is not present for the first node or the second node.

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 hierarchical join, the hierarchical join comprising a plurality of join operations defining an intersection between at least two nodes in the hierarchical join;
• determining, by the calculation engine, whether a cardinality of a first join of the plurality of join operations is above a threshold;
• optimizing, by the calculation engine, the first join in response to determining the cardinality of the first join is above the threshold, the optimizing comprising:
• determining whether an attribute, other than a join attribute, is requested from a first node of the first join or a second node of the first join, the at least two nodes comprising the first node and the second node,
• detecting whether a static filter is present for the first node or the second node, and
• pruning the first node and/or the second node from the hierarchical join when the attribute is not requested from the first node or the second node and/or when the static filter is not present for the first node or the second node.