Calculation Engine OLAP Join Compatibility Check

Resolve Bottlenecks,
Find Innovative SolutionsGenerate Solutions

Solution Overview

Problem

Database systems without an OLAP engine face processing errors and reduced performance when executing instruction sets configured for OLAP engines, due to incompatibility and differences in processing semantics, particularly with N:M joins.

Innovation Solution

A calculation engine detects a partitioning flag in the instruction set to determine if a join instruction should be skipped, adding flags during design time to simulate OLAP engine behavior, thereby avoiding processing errors and optimizing execution.

Engineering Contradictions & Design Principles

VSEngineering Contradiction Analysis

1Adaptability or versatility

If a calculation engine executes instruction sets configured for OLAP engines, then the system can process OLAP queries without an OLAP engine, but processing errors occur due to incompatibility with join instructions

Engineering Contradiction:

Improveability to execute OLAP instruction setsVSAvoidprocessing accuracy

Core Design Contradiction:

Adaptability or versatilityVSReliability

Solution Approach 1:

The system performs preliminary analysis of the instruction set to detect OLAP-specific features (such as N:M join instructions) before execution. By identifying these features in advance, the calculation engine can prepare appropriate handling strategies, such as skipping incompatible join operations or transforming them into equivalent calculations, thereby preventing processing errors while maintaining the ability to execute OLAP instruction sets

Inventive Principle:

Principle #10Preliminary action

Solution Approach 2:

The system extracts and identifies specific OLAP-compatible features from the instruction set, particularly detecting when join instructions should be skipped. By separating the identification of OLAP-specific operations from the general execution flow, the calculation engine can selectively handle incompatible instructions while executing the rest of the instruction set, thus resolving the contradiction between adaptability and reliability

Inventive Principle:

Principle #2Taking out (Extraction)

2Productivity

If a calculation engine executes join instructions in OLAP-configured instruction sets, then standard SQL processing is performed, but processing speed decreases and errors occur

Engineering Contradiction:

Improveprocessing speedVSAvoidprocessing accuracy

Core Design Contradiction:

ProductivityVSReliability

Solution Approach 1:

The system implements a mechanism to skip incompatible join instructions that would cause processing errors or performance degradation. By detecting OLAP-specific join patterns (such as N:M joins) and selectively bypassing them rather than executing them through standard SQL processing, the calculation engine maintains high processing speed while avoiding errors, thus resolving the contradiction between productivity and reliability

Inventive Principle:

Principle #21Skipping (Rushing through)

Data Source

PatentUS10452659B2Compatibility check for execution of joins

Publication Date: 2019.10.22 SAP SE

AI summary

Described herein includes processing various instruction sets configured for online analytics processing (OLAP) using a calculation engine. This allows OLAP configured instruction sets or calculation scenarios to be efficiently and effectively processed with the calculation engine during run time thereby preventing delays and errors during processing.