Production Workflow Data Management With Current and Historical Tables
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
The large amount of data generated in industrial product production processes complicates effective management and analysis of product defects due to the need for managing different processes and personnel across various equipment.
Innovation Solution
A system comprising a production configuration module, data acquisition module, and data storage module that selects and connects process nodes, acquires product data, and stores it in current and historical data tables based on a preset strategy, optimizing data management and reducing the amount of data in current tables.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Ease of operation
If all product data is stored in a single current data table, then data retrieval is simple, but query efficiency deteriorates due to large data volume
Solution Approach 1:
The patent divides the data storage structure into multiple tables (current data table and historical data tables) to segment the large volume of product data. This segmentation allows the system to maintain simple storage operations while improving query efficiency by reducing the data volume in the current data table through periodic archiving to historical tables.
2Quantity of substance
If product data is archived to historical tables, then current data table size is reduced, but data retrieval complexity increases
Solution Approach 1:
The patent implements preliminary archiving of historical data to separate tables before they are needed for analysis. By pre-organizing historical data in dedicated tables with proper indexing, the system reduces current data table size while maintaining efficient retrieval capabilities through structured access patterns to historical tables.
3Reliability
If production process data is recorded in detail, then traceability is improved, but data management difficulty increases
Solution Approach 1:
The patent segments production process data into multiple tables (current data table for active production data and historical data tables for archived data). This segmentation maintains detailed traceability information while reducing data management complexity by organizing data temporally and thematically, making it easier to query and manage.
Data Source
AI summary
A system and a method for product production management, a server and a storage medium are disclosed. The system includes: a production configuration module, configured to select a plurality of process nodes according to a user's selection operations, establish a connection relationship of the plurality of process nodes according to the user's connection operations, and obtain and display configuration data of a production process flow; a data acquisition module, configured to acquire product data in the production process flow and output the product data to a data storage module; and the data storage module, configured to store the product data in a current data table and/or a historical data table according to a preset storage strategy when the product data matches the configuration data.