Semantic Layer Augmentation via Dynamic Data Foundation Injection

Resolve Bottlenecks,
Find Innovative Solutions
Generate Solutions

Solution Overview

Problem

Existing enterprise software systems face challenges in dynamically enhancing and maintaining the integrity and security of semantic layer universes, which are critical for generating insights into business operations, as users often require frequent updates and enhancements that are not easily integrated into the existing authoring processes.

Innovation Solution

The solution involves creating semantic layer sets that can be consolidated with the universe to add technical features and enhancements, allowing users to dynamically extend the capabilities of the semantic layer universe at the consumption level, while maintaining security and integrity through a secured universe that restricts user access based on credentials.

Engineering Contradictions & Design Principles

VSEngineering Contradiction Analysis

1Reliability

If the semantic layer universe is constantly maintained for integrity and security, then security and integrity are improved, but adaptability and ease of enhancement are worsened

Engineering Contradiction:
Improveintegrity and securityVSAvoiddynamic enhancement capability
Core Design Contradiction:
ReliabilityVSAdaptability or versatility

Solution Approach 1:

The semantic layer universe is segmented into a base universe (maintained for integrity and security) and dynamic augmentations (added by users). This allows the core universe to remain stable while enabling flexible enhancements through separate augmentation components that can be added without affecting the base structure.

Inventive Principle:
Principle #1Segmentation

Solution Approach 2:

The patent implements a nested structure where augmentations are contained within the semantic layer universe framework. The augmentation player embeds user-defined augmentations into the existing universe model, allowing dynamic features to be nested within the secure base universe without compromising either layer.

Inventive Principle:
Principle #7Nested doll (Nesting)

2Adaptability or versatility

If users are allowed to dynamically enhance the semantic layer universe, then adaptability and versatility are improved, but device complexity and difficulty of maintenance are worsened

Engineering Contradiction:
Improvedynamic enhancement capabilityVSAvoidsystem complexity
Core Design Contradiction:
Adaptability or versatilityVSDevice complexity

Solution Approach 1:

The augmentation player serves as an intermediary component between users and the semantic layer universe. It provides a simplified interface for users to define augmentations while automatically handling the complex tasks of integrating these augmentations into the universe model, thus reducing the complexity burden on users.

Inventive Principle:
Principle #24Intermediary (Mediator)

Solution Approach 2:

The system enables self-service enhancement where users can independently define and apply augmentations to the semantic layer universe without requiring administrative intervention or complex manual integration processes. The augmentation player automatically handles the technical integration details.

Inventive Principle:
Principle #25Self-service

3Productivity

If frequent updates and enhancements are implemented, then productivity and adaptability are improved, but loss of time and complexity are worsened

Engineering Contradiction:
Improveupdate frequencyVSAvoidmaintenance time
Core Design Contradiction:
ProductivityVSLoss of time

Solution Approach 1:

The semantic layer universe is designed to be dynamic rather than static. The augmentation player enables real-time or near-real-time additions of new features and capabilities to the universe model without requiring time-consuming rewrites or reconfigurations of the base system, thus supporting frequent updates with minimal time loss.

Inventive Principle:
Principle #15Dynamics

Solution Approach 2:

The augmentation player prepares and validates augmentation definitions before they are applied to the semantic layer universe. This preliminary action ensures that augmentations are properly formatted and integrated in advance, preventing time-consuming errors or conflicts during the actual update process.

Inventive Principle:
Principle #10Preliminary action

Data Source

PatentUS11204908B2Augmentation playback
Publication Date: 2021.12.21 SAP SE
  • US11204908B2 patent drawing
  • US11204908B2 patent drawing
  • US11204908B2 patent drawing

AI summary

A system and method including receiving a request to perform an operation relying on sets-related tables of a semantic layer universe; injecting in response to the received request, persisted Data Foundation (DF) objects stored in a dedicated data structure of a first set container into the in-memory representation of the semantic layer universe, each of the DF objects being automatically created based on sets-related tables of the semantic layer universe; injecting, by the processor and in response to the received request, persisted business layer (BL) objects stored in a dedicated data structure of the first set container into the in-memory representation of the semantic layer universe, each of the BL objects being automatically created based on the sets-related tables of the semantic layer universe; and executing the operation on the augmented semantic universe, including using the injected DF objects and the injected BL objects.