Manufacturing Route Data Schema for Distributed Process Visibility

Resolve Bottlenecks,
Find Innovative Solutions
Generate Solutions

Solution Overview

Problem

Modern manufacturing systems face challenges due to compartmentalization of information across geographically distributed steps, leading to product failures and waste, which reduce yield and require effective solutions for data collection and analysis to extend product lifetime and improve efficiency.

Innovation Solution

Implementing a cloud-based multidimensional manufacturing data collection system that configures manufacturing routes into a single database schema, allowing real-time data collection and reporting across various manufacturing processes, enabling identification of issues before they cause waste or product failure, and facilitating corrective actions.

Engineering Contradictions & Design Principles

VSEngineering Contradiction Analysis

1Adaptability or versatility

If manufacturing systems are geographically distributed across multiple steps, then manufacturing flexibility and global economy participation are improved, but information compartmentalization occurs leading to product failures and waste

Engineering Contradiction:
Improvemanufacturing flexibilityVSAvoidinformation compartmentalization
Core Design Contradiction:
Adaptability or versatilityVSLoss of information

Solution Approach 1:

The patent merges information from multiple geographically distributed manufacturing steps into a single integrated database schema. The multidimensional manufacturing route data model consolidates process parameters, test results, and product information across different locations and manufacturing stages, eliminating information silos while preserving the distributed manufacturing structure.

Inventive Principle:
Principle #5Merging (Combining)

Solution Approach 2:

The patent introduces a cloud-based data collection system as an intermediary that receives and standardizes information from various manufacturing steps. This intermediary layer processes and normalizes data from different sources before storing it in the unified database, enabling seamless information integration across geographically distributed operations.

Inventive Principle:
Principle #24Intermediary (Mediator)

2Reliability

If real-time data collection is implemented across all manufacturing steps, then product quality and yield are improved, but system complexity and data processing requirements increase

Engineering Contradiction:
Improveproduct qualityVSAvoiddata collection system complexity
Core Design Contradiction:
ReliabilityVSDevice complexity

Solution Approach 1:

The patent segments the data collection system into modular components, with each manufacturing step having its own data collection module that feeds into the unified database. This segmentation allows independent implementation and maintenance of individual collection points while maintaining overall system integration through the standardized multidimensional data model.

Inventive Principle:
Principle #1Segmentation

3Productivity

If comprehensive manufacturing data is collected and analyzed, then waste reduction and yield improvement are achieved, but data processing time and computational resources increase

Engineering Contradiction:
Improvemanufacturing yieldVSAvoiddata processing time
Core Design Contradiction:
ProductivityVSLoss of time

Solution Approach 1:

The patent applies preliminary action by pre-defining the multidimensional data schema and data collection structure before manufacturing operations begin. This allows data to be organized and stored in an analysis-ready format from the outset, eliminating the need for complex post-processing and enabling immediate analytical insights when data is collected.

Inventive Principle:
Principle #10Preliminary action

Data Source

PatentUS11036212B1Route based manufacturing system analysis, apparatuses, systems, and methods
Publication Date: 2021.06.15 SCHEMAPORT LLC
  • US11036212B1 patent drawing
  • US11036212B1 patent drawing
  • US11036212B1 patent drawing

AI summary

Systems and methods are described to improve efficiency in the manufacturing of a product for a manufacturer. The system includes a manufacturing route. The manufacturing route specifies at least two dimensions, where a first dimension of the at least two dimensions is a client machine and a second dimension of the at least two dimensions is a process associated with the client machine. A data stream is responsive to the plurality of dimensions. A database is configured to receive the data stream. A processor is configured to provide data from the data stream that indicates a symptom of a problem which can occur within the manufacturing route.