HDS - open time series high frequency Historical database

Process Data Acquisition – PDA -- Detailed analysis of quality manage&industrial big data sources	高速数采方案 High speed data acquisition scheme		系统 System	Contact us
1 Background and significance		12 HDC - Hot rolled high-frequency high-density Digital steel Coil
2 PDA - data acquisition and analysis system		13 CDC - Cold rolled Digital steel Coil
3 LTA - Long historical Trend Analysis system		14 DSP - Digital Steel Plate
4 HDS - open time series high frequency Historical database		15 DTP - Digital Steel Pipe
5 DBU - Database system and Upgrade tools		16 CDS - Continuous casting Digital Slab
6 DCC - Digital Coil Conversion and full process quality management		17 TDA - Typical high-speed Data Acquisition scheme
7 CFS - Coil Fast Search and statistics system		18 QMS - Quality Manage and analysis System
8 DSO - Device diagnostic Synchronous Oversampling system		19 Common debugging tools and development board
9 RSA - Roll Spalling Alarm and Quick Stop System		20 Project performance and typical project application
10 RCM - Roller Current Monitoring system		21 Research Form for PDA System Configuration in the Steel Industry
11 HDP - High frequency density and speed Data Platform construction

4 HDS - open time series high frequency Historical database

The full name of a time series database is a time series database, which is mainly used to process data with time labels (changing in chronological order, i.e. time serialization). Data with time labels is also known as time series data.

Time series data is mainly collected and generated by various types of real-time monitoring, inspection, and analysis equipment in the metallurgical, power, chemical, meteorological, and geographic information industries. The typical characteristics of these industrial data are: fast generation frequency (each monitoring point can generate multiple pieces of data within one second), severe dependence on collection time (each piece of data requires a unique time) Multiple monitoring points have a large amount of information (conventional real-time monitoring systems have thousands of monitoring points, which generate data every second and tens of GB of data every day).

Commonly used temporal databases include InfluxDB, KDb+, Prometheus, Graphite, RRDtool, TimescaleDB, Apache Druid, Fauna, OpenTSDB, GridDB, DolphinDB, KairosDB, etc.

Open high frequency time series Historical Database Server stores PDA millisecond level high-frequency data into the temporal database and can access it through SQL statements.

Figure 4.1 InfluxDB Time Series Database System Files

dbUpgradeTSA.exe~dbUpgradeTSL.exe is located in the PDA or HDServer directory. It converts the data files collected by PDA to. csv files supported by InfluxDB at the original sampling frequency or frequency reduction losslessly, and imports them offline in bulk into InfluxDB. The table structure is identical to the configuration of Config.csv.

Figure 4.2 Upgrading PDA Configuration to InfluxDB

dbUpgradeTS has multiple processes, each converting several connections to ensure that the write timing database can keep up with the speed of PDA generating data files, Each process scans PDA data files every 2 minutes.

Figure 4.3 Batch Import of PDA Data to InfluxDB

Cancel the quick editing mode and insertion mode in the Console window of the influx service program to avoid input interference.

Figure 4.4 set influxd console mode

Apparatus test&Fault diagnosis&Quality analysis

Millisecond data sampling

Real-time data compression

Capture signal instantaneous mutation

友情链接百度腾讯新浪网易搜狐凤凰淘宝京东中国自动化网中国工控网西门子罗克韦尔华军软件园天空软件站非凡软件站多多软件站携程知乎

中国五矿中冶集团中冶赛迪中冶南方中冶京诚中冶华天中冶长天中冶北方中冶焦耐中国宝武宝信宝钢武钢鞍钢河钢首钢沙钢山钢涟钢

Develop communication protocol, Customized analysis function, Open data interface, XinChuang domestic obsession

PDAServer PDAClient