In-Memory Database for Variant Configuration Management

Resolve Bottlenecks,
Find Innovative Solutions
Generate Solutions

Solution Overview

Problem

In 24/7 manufacturing environments, managing the complex list of materials needed for customized products is time-consuming and difficult due to the large number of possible product variants, leading to inefficiencies in information management and potential missed revenue opportunities.

Innovation Solution

A networked in-memory database system using a column-store database processes requests for customized products by translating Boolean expressions into manufacturing instructions in real-time, utilizing disjunctive or conjunctive normal form to efficiently identify and extract the required components and their specifications for assembly tools.

Engineering Contradictions & Design Principles

VSEngineering Contradiction Analysis

1Device complexity

If configurable lists of materials are used to describe required component parts for an entire product line as functions of specified product variant features, then the number of separate list of materials is reduced, but the functions become quite complicated for fully customized products with many user-selectable features

Engineering Contradiction:
Improvecomplexity of list of materials managementVSAvoidproduct customization capability
Core Design Contradiction:
Device complexityVSAdaptability or versatility

Solution Approach 1:

The patent segments the complex list of materials into hierarchical levels (product line level, product variant level, and component level). Each level has its own configuration rules and dependencies, allowing the system to manage complexity by dividing the overall BOM management into manageable segments that can be independently configured and evaluated.

Inventive Principle:
Principle #1Segmentation

Solution Approach 2:

The patent introduces a new dimension of configuration by adding explicit configuration rules and constraints that operate alongside the traditional product variant specifications. This creates a multi-dimensional configuration space where products can be defined not only by their features but also by their compliance with configuration rules, enabling complex customization while maintaining manageability.

Inventive Principle:
Principle #17Another dimension (Dimensionality change)

2Loss of information

If a database is used to manage the mapping of desired features that define the variant configuration and all the components that each variant requires, then the mapping capability is improved, but the evaluation of complex object dependencies during configuration and manufacturing becomes very time critical

Engineering Contradiction:
Improvemapping accuracy of features to componentsVSAvoidconfiguration and manufacturing time
Core Design Contradiction:
Loss of informationVSLoss of time

Solution Approach 1:

The patent performs preliminary configuration and dependency evaluation during product design and before manufacturing. Configuration rules and component mappings are established in advance, and the system pre-evaluates dependencies so that when a specific product variant is ordered, the configuration and BOM generation can be rapidly completed without time-critical complex evaluations during production.

Inventive Principle:
Principle #10Preliminary action

Solution Approach 2:

The patent replaces traditional sequential mechanical evaluation processes with a rule-based computational system that uses explicit configuration rules and constraints. This substitution enables parallel evaluation of multiple configuration rules and faster determination of component requirements, significantly reducing the time needed for configuration and BOM generation while maintaining accuracy.

Inventive Principle:
Principle #28Mechanics substitution (Replace mechanical system)

3Productivity

If the effective solution minimizes time interval between receiving a request to manufacture a customized product and execution of manufacturing, then productivity is improved, but the complexity of evaluating complex object dependencies increases

Engineering Contradiction:
Improvemanufacturing response timeVSAvoidcomplexity of dependency evaluation system
Core Design Contradiction:
ProductivityVSDevice complexity

Solution Approach 1:

The patent changes the parameters of the evaluation system by introducing explicit configuration rules with defined priorities and constraints. Instead of evaluating all possible dependencies equally, the system uses parameterized rules that specify evaluation order, mandatory requirements, and optional features, allowing rapid determination of component requirements even for complex products.

Inventive Principle:
Principle #35Parameter changes

Solution Approach 2:

The patent introduces configuration rules as an intermediary layer between product variant specifications and component requirements. These rules act as mediators that translate high-level product configurations into detailed BOMs by applying predefined logic and constraints, simplifying the overall evaluation process while maintaining the ability to handle complex dependencies.

Inventive Principle:
Principle #24Intermediary (Mediator)

Data Source

PatentEP2927861B1In-memory database system for the management of variant configuration of a product
Publication Date: 2019.05.08 SAP SE
  • EP2927861B1 patent drawingFigure 1
  • EP2927861B1 patent drawingFigure 2
  • EP2927861B1 patent drawingFigure 3

AI summary

A networked in-memory database system (1400) for real-time control of manufacturing processes of customized products using at least one assembly tool (1500) having real-time controlling unit (1501),a computer-implemented method for real-time control of manufacturing processes of customized products using the networked in-memory database system (1400) and at least one of the assembly tools (1500), and a computer readable medium having stored thereon a computer executable program code for execution by a computer processor controlling a computing device of the networked in-memory database system comprising, wherein execution of the instructions of the executable program code causes the computer processor controlling the computing device to perform the computer-implemented method. The networked in-memory database system comprises: a column-store database (1413), wherein specifications of the components usable for manufacturing of the customized products are stored in the column-store data-base, one or more first input-output ports (1412) for programming at least one of real-time controlling units of the assembly tools, the one or more first input-output ports being configured to support at least one real-time communication computer network protocol for communication with the real-time controlling units, one or more second input-output ports (1414) configured to support at least one secure messaging computer network protocol, a digital storage medium (1404) storing a processor-executable program code, and a computing device (1404) to execute the processor-executable program code in order to cause the computing device to execute the steps of the computer-implemented method.