Control Device Time Series Data Collection and Storage
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Current control devices in factory automation lack an efficient system for posteriori analysis and interpretation of time series data, despite their ability to collect and store large amounts of data, as they do not facilitate easy data analysis and interpretation.
Innovation Solution
A control device equipped with a control operation unit, a manufacturing data acquisition unit, and a time series database that stores input, output, and operation data, along with manufacturing data, and outputs a dataset for external analysis, enabling posteriori analysis and interpretation by connecting to a manufacturing execution system and IoT services.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Quantity of substance
If a large amount of time series data is collected and stored in a database within the control device, then data availability for posteriori analysis is improved, but system complexity and difficulty of data analysis increase
Solution Approach 1:
The patent segments the stored data into distinct categories: input data from control targets, output data from control operations, operation data calculated during control execution, and manufacturing data from external systems. This segmentation is implemented through a structured database schema that organizes time series data by source and type, making complex datasets more manageable and easier to query for specific analysis purposes
Solution Approach 2:
The patent introduces an intermediary data processing layer that automatically associates manufacturing data with corresponding control data through time synchronization and identification matching. This intermediary function creates a unified dataset structure that links external manufacturing information with internal control operations, enabling easier posteriori analysis without increasing system complexity
2Loss of information
If multiple types of data (input, output, operation data) are stored together with manufacturing data, then data completeness for analysis is improved, but data management complexity increases
Solution Approach 1:
The patent merges multiple data sources and types into a unified time series database structure. Input data from control targets, output data from control operations, calculated operation data, and external manufacturing data are all stored together in a single database system with a unified schema that preserves the unique characteristics of each data type while enabling integrated analysis through common time-based and identification-based indexing
3Ease of operation
If data is stored in a structured format for easy analysis, then ease of posteriori analysis is improved, but storage flexibility may be reduced
Solution Approach 1:
The patent implements a dynamic database structure that combines structured storage with flexible data ingestion. The database schema provides structured organization of data by type and source with fixed fields for consistent querying, while the data ingestion layer accepts various data formats and automatically transforms them into the standardized structure, maintaining both analysis ease and storage flexibility
Data Source
AI summary
In a control device having functions of collecting and storing time series data, a system for facilitating posteriori analysis and interpretation is provided. The control device includes: a control operation unit acquiring input data from a control target and determines output data for the control target by executing a control operation based on the acquired input data; a manufacturing data acquisition unit acquiring manufacturing data from a manufacturing execution system associated with the control target; a time series database storing at least some of the input data, the output data, operation data calculated in the control operation according to the control operation unit, and the manufacturing data in a time series; and an outside output unit outputting a data set including observed values composed of at least some of the input data, the output data and the operation data and the manufacturing data corresponding thereto to the outside.