|
Process Data Acquisition – PLC -- Detailed
analysis of quality manage&industrial big data sources |
||||
|
12 HDC - Hot
rolled high-frequency high-density Digital steel Coil |
||||
|
6 DCC - Digital Coil
Conversion and full process quality management |
||||
|
21 Research Form for PDA System Configuration in the
Steel Industry |
||||
|
11
HDP - High frequency density and speed Data Platform construction |
|
|||
5 DBU - Database
system and Upgrade tools
The database supports SQL statements and has good openness. The Database Upgrade tool upgrades the high-frequency data collected by PDA to a relational and sequential database, achieving the unity of PDA collection points and database table names, field names, and data. It supports offline and online methods. 5.1 PDA → SQLServer Realtime Data
dbUpgradeRt.ini configures the trigger conditions for real-time database writing and which variables are written to which database table. PDA can save the collected data to relational databases such as SQL Server/MySQL/Oracle in real-time according to the configured number of cycles through dbUpgradeRtA.exe, dbUpgradeRtB.exe~dbUpgradeRtJ.exe. There are seven triggering methods for data storage as shown in the following figure. During the first run, the database table is automatically created according to the configuration of dbUpgradeRtA.ini, dbUpgradeRtB.ini~dbUpgradeRtJ.ini. After the configuration changes, the table structure is manually modified according to the ini configuration.
Figure 5.1 Seven triggering methods for real-time database writing 5.2 PDA → SQLServer Historical Data
dbUpgrade.exe can upscale historical data to a relational database, and automatically create database tables by pressing Config.csv during the first run. It can be downscaled and upscaled.
Figure 5.2 PDA configuration upgrade to relational database 5.3 PDA → InfluxDB realtime data
dbUpgradeRtTS.ini configures the trigger conditions for real-time database writing and which variables are written to which database table. dbUpgradeRtTS.exe calls influx_Rt.exe writes the database table in real-time according to the configuration file dbUpgradeRtTS.ini when one of the seven triggering conditions is met, or unconditionally once per second, with the ability to write tens of thousands of points per second. It supports triggering frequency at the 0.1 second level, and the field name written to influx should be correctly configured in the FFS column of Config.csv. The IP and file path configuration is shown in the following figure. dbUpgradeRtTSSr.exe can update files that have not been uploaded in the past 7 days, scan every 12 hours, and automatically delete temporary files 10 days ago.
Figure 5.3 Configuration of InfluxDB IP and Collection Points in PDA 5.4 Automatic
report
The automatic reporting system is a big data analysis and statistical tool. Provide sufficient support for various reporting tools such as Microsoft Power BI and Fansoft through database and PDA underlying technology.
Figure 5.4 Power BI Report Example
Figure 5.5 Fansoft Report Example
Figure 5.6 Real time and statistical
reports for Grafana configuration |
|
|
|
|
|
Apparatus test&Fault diagnosis&Quality analysis |
Millisecond data sampling Real-time data compression Capture signal instantaneous mutation |
|
友情链接 百度 腾讯 新浪 网易 搜狐 凤凰 淘宝 京东 中国自动化网 中国工控网 西门子 罗克韦尔 华军软件园 天空软件站 非凡软件站 多多软件站 携程 知乎 中国五矿 中冶集团 中冶赛迪 中冶南方 中冶京诚 中冶华天 中冶长天 中冶北方 中冶焦耐 中国宝武 宝信 宝钢 武钢 鞍钢 河钢 首钢 沙钢 山钢 涟钢 鄂ICP备2025092850号 版权所有©Copyright:2025-2035. 经纬铭月科技（武汉）有限公司 |
|
Develop communication protocol, Customized
analysis function, Open data interface, Localization of XinChuang
PDAServer
PDAClient