Radial Control UI for Manufacturing Data Warehouse Configuration
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Configuring a Manufacturing Operation Management (MOM) data warehouse is a time-consuming and error-prone process due to the need for separate scripts and configuration workflows for each machine, and the complexity of managing vast amounts of data across different components and machines in manufacturing execution systems, requiring skilled resources and extensive analysis.
Innovation Solution
A method that maps data into a hierarchical model based on industry classification, displaying it in a radial control-based user interface (UI) with navigation actions, allowing automatic configuration of the MOM data warehouse structure, and adjusting segment size, position, and appearance for relevance, enabling efficient data management and representation.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Adaptability or versatility
If separate scripts and configuration workflows are created for each individual machine, then the system can accommodate specific machine configurations, but the configuration process becomes time-consuming and error-prone
Solution Approach 1:
The patent implements a universal configuration workflow that can be applied across multiple machines and components. Instead of creating separate configuration scripts for each machine, a single standardized workflow handles configuration for diverse machines, reducing configuration time while maintaining adaptability through the standardized process.
Solution Approach 2:
The configuration process is segmented into distinct, standardized steps that can be systematically applied to different machines. The workflow divides configuration into manageable segments (data source identification, data model mapping, transformation rules, loading parameters) that can be reused across multiple machines, reducing overall configuration time and errors.
2Adaptability or versatility
If each component is configured individually through respective set-up scripts, then customizability is achieved, but configuration complexity and time increase significantly
Solution Approach 1:
The patent merges individual component configuration scripts into a single integrated configuration workflow. This unified approach combines data source configuration, data model mapping, transformation rules, and loading parameters into one cohesive process, reducing configuration complexity while maintaining the ability to customize individual components through the standardized workflow.
3Manufacturing precision
If highly skilled SW architects perform manual database design steps, then the MOM data warehouse structure is optimized, but the process requires huge time and resources
Solution Approach 1:
The configuration workflow enables self-service automation where the system automatically performs data warehouse structure creation and optimization based on predefined rules and parameters. Instead of requiring highly skilled architects to manually design the database structure, the automated workflow handles these tasks independently, improving productivity while maintaining structure quality through systematic processing.
Solution Approach 2:
The patent implements preliminary action by pre-defining data models, transformation rules, and configuration parameters before the actual configuration process. This preparation allows the automated workflow to efficiently create optimized data warehouse structures without requiring manual intervention during execution, improving both productivity and structure quality.
4Loss of information
If comprehensive data collection from multiple MOM data sources is performed, then business decision support is enhanced, but data management complexity increases
Solution Approach 1:
The configuration workflow provides a universal approach to handling data from multiple MOM data sources. It systematically identifies data sources, maps data models, applies transformation rules, and configures loading parameters in a unified process, managing comprehensive data collection while reducing data management complexity through standardization.
Data Source
AI summary
A method for configuring a manufacturing operation management (MOM) data warehouse and providing a user interface (UI) to the MOM data warehouse configuration. The MOM data warehouse forms a database for the data handled within a manufacturing execution system. The method includes: a) mapping the data that has to be presented in the UI into a hierarchical data model being based on an industry classification of the manufacturing process controlled by the manufacturing execution system, the hierarchical data model having a number of levels; b) mapping the hierarchical data model into a radial control based UI; c) displaying in the radial control based UI at least two levels of the hierarchical data model; and d) providing navigation actions in order to scroll up and/or scroll down through the levels of the hierarchical data model.