In-Memory Database for Variant Configuration Management
Find Innovative SolutionsGenerate 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
Engineering 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
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.
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.
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
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.
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.
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
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.
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.
Data Source
Figure 1
Figure 2
Figure 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.