CN103995549A - Temperature data collecting method based on centralized temperature control system - Google Patents

Abstract

Translated fromChinese

本发明涉及智能化集中式温控系统，尤其是基于集中温控系统的温度数据采集方法，其方法的具体步骤为：系统上位机按取样周期读取巡检仪存储器中某基表的实时温度值，该方法能将丢失的采集点的数据补充起来，使数据库中的数据完整并且绘制实时温度曲线使比较完整、连续和基本符合实际。

The invention relates to an intelligent centralized temperature control system, especially a method for collecting temperature data based on the centralized temperature control system. The specific steps of the method are: the upper computer of the system reads the real-time temperature of a certain base meter in the memory of the inspection instrument according to the sampling cycle Value, this method can supplement the data of the lost collection points, make the data in the database complete and draw the real-time temperature curve to make it more complete, continuous and basically in line with reality.

Description

Based on the temperature data acquisition method of concentrating temperature control system

Technical field

The present invention relates to intelligent centralized temperature control system, especially the temperature data acquisition method based on concentrating temperature control system.

Background technology

Centralized temperature control system, hardware system structure referring to Fig. 1, the superiors are called host computer, are the maincenters of system, all control inputs and output complete at this; Middle level is logging, can connect at most 80, and logging completes the issuing of temperature curve, base table data acquisition and base table control; Basecoat be base table (or claim temperature controller: comprise PID controller and temperature sensor thermopair), can connect at most 80, complete the functions such as intensification, cooling, constant temperature and warning.The advantage of this structure has; 1), system scale can expand flexibly; 2), host computer can shut down, the real-time data memory of base table is in logging; 3), can greatly simplify the design complexity of base table, greatly reduce system cost.

The temperature control point theoretical value that can connect due to centralized temperature control system is 80 × 80, and in system, the upper limit of logging is 80, and temperature control base table higher limit is also 80, like this upper limit 6400 of system base table number.By 1 millisecond, 10 milliseconds, 100 milliseconds and 1 second image data once, collection period higher limit is respectively 6.4 seconds, 64 seconds, 640 seconds and 6400 seconds logging.In the situation that accuracy of temperature control requirement is very not high, once, at this moment collection period higher limit is respectively 6.7 minutes and 67 minutes for 100 milliseconds of most employings and 1 second image data.Among actual industry, in such time period, temperature changes, and the data of collection will be discontinuous, and the temperature curve of drafting can be desultory.1), the data of issuing host computer due to situation loggings such as environmental interference are wrong while that is to say according to temperature control point theoretical maximum host computer image data, there will be the possibility of obliterated data:, host computer will be lost these data; 2), too much due to temperature control point, the collection period of host computer misses, and reads to cause loss of data less than data.

Summary of the invention

For solving above technical matters, the invention provides the temperature data acquisition method based on concentrating temperature control system, the method can be got up the data filling of the collection point of loss, makes the data integrity in database and draw real time temperature curve to make more complete, continuous and substantially realistic.

Technical scheme of the present invention is: based on the temperature data acquisition method of concentrating temperature control system, its difference is: it comprises the following steps:

Step 1), system host computer starts host computer serial ports and sends temperature control curve to logging;

Step 2), logging to temperature control base table by section send a temperature control curve;

Step 3), the host computer sample period according to the rules reads the real time temperature value of a certain base table in logging storer; Perform step 4 as do not collected temperature data in logging storer), as there being data further to judge whether this segment data sampling completes in logging storer, after the temperature data curve collecting being sent to database as completed, read again lower one piece of data, continue to read the real time temperature value of base table described in logging storer as do not completed host computer sample period according to the rules;

Step 4), taking logging j and base table number i as search index, whole historical datas of traversal retrieval base table judge and in host computer database, have or not the temperature data mating with missing data, temperature curve is calculated and supplemented to the temperature data curve equation that is used as lacking time point or section as not having with design temperature curve values formula one, then judge whether this section of temperature data sampling completes, after complete temperature curve that collect and supplementary being sent to host computer database as completed, read again lower one piece of data, continue to read the real time temperature value of base table described in logging storer by the sample period as do not completed host computer,

Y=(y₂-y₁)/(x₂-x₁) X+ (y₁x₂-y₂x₁)/(x₂-x₁) (formula one)

If x is the time, the temperature value that y is base table, wherein x₁and x₂for the initial sum termination time of temperature curve section, y₁and y₂for the temperature value of this curve initial sum termination;

As there being the data of mating with missing data in database, judge again data precision requirement, the value Y calculating according to design temperature curve values formula one with same base table as data accuracy requirement Gao Ze_jideduct historical data V_jithe value of obtaining carries out square obtaining variance yields afterwards, get all over n historical data obtain a corresponding n variance yields, get minimum value in n variance yields, the corresponding historical data V of this minimum variance value_jifor losing temperature data value U_jicalculate and supplement the temperature data curve of disappearance time point or section with the method, then judge whether this section of temperature data sampling completes, as complete by collect and supplement after complete temperature curve is sent to host computer database and read again lower one piece of data, continue to read the real time temperature value of base table described in logging storer as do not completed host computer sample period according to the rules;

The temperature data curve equation that is used as lacking time point or section by formula two as low in data accuracy requirement is calculated and supplementary temperature curve, then judge whether this section of temperature data sampling completes, as complete by collect and supplement after complete temperature curve is sent to host computer database and read again lower one piece of data, continue to read the real time temperature value of base table described in logging storer as do not completed host computer sample period according to the rules;

U_ji=Σ V_ji/ n (formula two)

U_jifor losing temperature data value, V_jifor the logging j of identical numbering in database and same base table number i are at the temperature value of same design temperature curve, same temperature control section, synchronization; Σ V_jifor n historical data sum; Y_jithe value calculating according to design temperature curve values formula one for same base table.

The present invention gets up the data filling of the collection point of loss, this data filling is entered in database simultaneously, makes the data integrity in database and draw real time temperature change curve to make more complete, continuous and substantially realistic.

Brief description of the drawings

Fig. 1 is the structured flowchart that the embodiment of the present invention is concentrated temperature control system;

Fig. 2 is the schematic flow sheet of the temperature data acquisition method of the embodiment of the present invention based on concentrated temperature control system;

Fig. 3 is the concrete wiring schematic diagram of embodiment of the present invention temperature control base table place layer.

Embodiment

Referring to Fig. 1-Fig. 3, the temperature data acquisition method of the embodiment of the present invention based on concentrating temperature control system, its difference is: it comprises the following steps:

Step 1), system host computer starts host computer serial ports and sends temperature control curve to logging;

Step 2), logging to temperature control base table by section send a temperature control curve;

Step 3), the host computer sample period according to the rules reads the real time temperature value of a certain base table in logging storer; Perform step 4 as do not collected temperature data in logging storer), as there being data further to judge whether this segment data sampling completes in logging storer, after the temperature data curve collecting being sent to database as completed, read again lower one piece of data, continue to read the real time temperature value of base table described in logging storer as do not completed host computer sample period according to the rules;

Step 4), taking logging j and base table number i as search index, whole historical datas of traversal retrieval base table judge and in host computer database, have or not the temperature data mating with missing data, temperature curve is calculated and supplemented to the temperature data curve equation that is used as lacking time point or section as not having with design temperature curve values formula one, then judge whether this section of temperature data sampling completes, after complete temperature curve that collect and supplementary being sent to host computer database as completed, read again lower one piece of data, continue to read the real time temperature value of base table described in logging storer by the sample period as do not completed host computer,

Y=(y₂-y₁)/(x₂-x₁) X+ (y₁x₂-y₂x₁)/(x₂-x₁) (formula one)

If x is the time, the temperature value that y is base table, wherein x₁and x₂for the initial sum termination time of temperature curve section, y₁and y₂for the temperature value of this curve initial sum termination;

As there being the data of mating with missing data in database, judge again data precision requirement, the value Y calculating according to design temperature curve values formula one with same base table as data accuracy requirement Gao Ze_jideduct historical data V_jithe value of obtaining carries out square obtaining variance yields afterwards, get all over n historical data obtain a corresponding n variance yields, get minimum value in n variance yields, the corresponding historical data V of this minimum variance value_jifor losing temperature data value U_jicalculate and supplement the temperature data curve of disappearance time point or section with the method, then judge whether this section of temperature data sampling completes, as complete by collect and supplement after complete temperature curve is sent to host computer database and read again lower one piece of data, continue to read the real time temperature value of base table described in logging storer as do not completed host computer sample period according to the rules;

The temperature data curve equation that is used as lacking time point or section by formula two as low in data accuracy requirement is calculated and supplementary temperature curve, then judge whether this section of temperature data sampling completes, as complete by collect and supplement after complete temperature curve is sent to host computer database and read again lower one piece of data, continue to read the real time temperature value of base table described in logging storer as do not completed host computer sample period according to the rules;

U_ji=Σ V_ji/ n (formula two)

U_jifor losing temperature data value, V_jifor the logging j of identical numbering in database and same base table number i are at the temperature value of same design temperature curve, same temperature control section, synchronization; Σ V_jifor n historical data sum; Y_jithe value calculating according to design temperature curve values formula one for same base table.

Data precision is the diversity factor of collecting temperature curve and temperature control curve, and diversity factor belongs to high precision within positive and negative 3%,

Outside positive and negative 3%, belong to low precision, data precision size can arrange, and is not limited to positive and negative 3%.

Referring to Fig. 3, the temperature control base table in the embodiment of the present invention can adopt humidostat, and the temperature control line of this humidostat is connected to electric thermo-couple test furnace.

Algorithm design principle summary agreement will be understood the temperature variation of a base table every 1 minute, be 6.7 minutes so in collection period higher limit, and each base table has just been lost respectively 6.7 data.The following formula of the employing of these 6.7 data is calculated.For simplifying, in arthmetic statement, the number of base table is got [60,6400] the interval upper limit or lower limit, and 60 or 6400.The number of base table is less than 60 system acquisition and there will not be loss of data, and the number of base table is greater than 6400 systems and cannot processes. arthmetic statement (Statistics Temperature Data Fitting Algorithm)

(1) the pseudo-C language description of benefit reward temperature control data acquisition algorithm is as follows:

(2) data sampling algorithm

The host computer that data sampling algorithm the refers to system sample period is according to the rules read the real time temperature value of certain base table in logging storer, calls STEDAFA algorithm when wrong according to the data that send or send when logging is countless.Its pseudo-C language codes is as follows:

Below further describe logging communication protocol.

(1) instruction that, host computer may send is as follows:

Position: the real time clock of proofreading and correct logging.(date Hour Minute Second)

Read base table parameter: read and specify the parameter value of specifying in base table.(base table address, parameter sequence number)

Amendment base table parameter: the parameter value of specifying in base table is specified in amendment.(base table address, parameter sequence number, parameter value)

Issue curve data: issue the current temperature control curve data of each base table to logging.(base table number, curve data)

Suspend/start: control and specify base table to suspend or start.(base table address, order)

Acquisition and recording: gather temperature detector record from the data-carrier store of logging.

(2), host computer sends order to logging

Host computer sends order bag to logging, and form is as follows:

Address, address radix-minus-one complement, 07,00, C1, year, month, day, time, point, second, check code L, check code H

After logging fill order, return response packet format is as follows:

Address, 01,00, result code, check code L, check code H.

(3), read base table parameter

Host computer sends order bag to logging, and form is as follows:

Address, address radix-minus-one complement, 03,00, C2, base table address, parameter number, check code L, check code H

Logging receives orders, and from specifying base table to read relevant parameter data, return response packet format is as follows:

Address, 0B, 00, result code, base table address, parameter number, PV[2], SV[2] and, MV, B, parameter value [2], check code L, check code H.

(4), amendment base table parameter

Host computer sends order bag to logging, and form is as follows:

Address, address radix-minus-one complement, 05,00, C3, base table address, parameter number, parameter value [2], check code L, check code H

Logging receives orders, to specify base table be incorporated into relevant parameter data after return response packet format as follows:

Address, 0B, 00, result code, base table address, parameter number, PV[2], SV[2] and, MV, B, parameter value [2], check code L, check code H.

(5), issue curve data

Host computer sends order bag to logging, and form is as follows:

Address, address radix-minus-one complement, 53,00, C4, base table address, bag sequence number, curve data [80], check code L, check code H

Bag sequence number: 0～8. (if issue 90 sections of curves, be divided into 9 bag orders and issue)

Curve data: can send at most 10 sections of curve datas, every segment data accounts for 8 bytes at every turn, and structure is as follows:

Initial temperature [2], final temperature [2], working time [2], instruction character [1], mark [1]

After logging fill order, return response packet format is as follows:

Address, 01,00, result code, check code L, check code H.

(6), suspend/start and control

Host computer sends order bag to logging, and form is as follows:

Address, address radix-minus-one complement, 03,00, C5, base table address, control code, check code L, check code H

If base table address value FF, represents all base tables to control

Control code: 00=suspends, and 01=starts

After logging fill order, return response packet format is as follows:

Address, 01,00, result code, check code L, check code H.

(7), acquisition and recording

Host computer sends order bag to logging, and form is as follows:

Address, address radix-minus-one complement, 05,00, C6, bag sequence number [4], check code L, check code H

Bag sequence number: 0～xxxxxxx, (512 bytes/bag)

Logging return response packet format is as follows:

Address, 01,02, result code, data [512], check code L, check code H

Temperature detector records every and accounts for 16 bytes, and form is as follows:

Mark [1], base table address [1], temperature value [2], date Hour Minute Second [6], retains [6].

(8), logging " in real time " image data communication protocol:

Host computer sends querying command bag to logging, and form is as follows:

Address, address radix-minus-one complement, 02,00, C7,01, check code L, check code H

Logging return response packet format is as follows:

Address, 15,00, result code, data [20], check code L, check code H

Countless according to time, result code=00

While having data, result code=01

Data [20]: form is as follows:

In the time of result code=01, host computer must send data validation bag to logging again, notifies this record of logging to receive,

If not receiving to confirm to wrap, logging will reply same record always.Data validation packet format is as follows:

Address, address radix-minus-one complement, 02,00, C7,02, check code L, check code H

The nonreply of data validation bag.

Real-time Collection step is as follows: step 1), host computer are sent out querying command bag; Step 2), logging loopback should wrap; In step 3), response packet, countless certificates, get back to step 1); Step 4), host computer are sent out data validation bag, get back to step 1).

Claims (1)

Translated fromChinese

1.基于集中温控系统的温度数据采集方法，其特征在于：其包括以下步骤：1. based on the temperature data acquisition method of centralized temperature control system, it is characterized in that: it may further comprise the steps:步骤1)、系统上位机启动上位机串口向巡检仪发送温控曲线；Step 1), the host computer of the system starts the serial port of the host computer to send the temperature control curve to the inspection instrument;步骤2）、巡检仪向温控基表按段发送温控曲线；Step 2), the inspection instrument sends the temperature control curve to the temperature control base meter by segment;步骤3)、上位机按照规定的取样周期读取巡检仪存储器中某一基表的实时温度值；如巡检仪存储器中没有采集到温度数据则执行步骤4），如巡检仪存储器中有数据则进一步判断该段数据采样是否完成，如完成则将采集到的温度数据曲线发送至数据库后再读取下一段数据，如没有完成则上位机按取样周期继续读取巡检仪存储器中所述基表的实时温度值；Step 3), the upper computer reads the real-time temperature value of a base table in the memory of the patrol instrument according to the specified sampling period; if no temperature data is collected in the memory of the patrol instrument, perform step 4). If there is data, it will further judge whether the data sampling of this section is completed. If it is completed, the collected temperature data curve will be sent to the database before reading the next section of data. The real-time temperature value of the base meter;步骤4）、以巡检仪号j和基表号i为查询索引，遍历检索基表的全部历史数据判断上位机数据库中有无与缺失数据匹配的温度数据，如没有则以设定温度曲线值公式一来作为缺失时间点或段的温度数据曲线公式计算并补充温度曲线，然后判断该段温度数据采样是否完成，如完成则将采集到的和补充完毕的温度曲线发送至上位机数据库后再读取下一段数据，如没有完成则上位机按照规定的取样周期继续读取巡检仪存储器中所述基表的实时温度值；Step 4), using the inspection instrument number j and the base table number i as the query index, traverse all the historical data of the base table to determine whether there is any temperature data matching the missing data in the host computer database, if not, use the set temperature curve Value formula 1 is used as the temperature data curve formula of the missing time point or segment to calculate and supplement the temperature curve, and then judge whether the temperature data sampling of this segment is completed. If it is completed, the collected and supplemented temperature curve will be sent to the host computer database. Then read the next piece of data, if it is not completed, the host computer will continue to read the real-time temperature value of the base table in the memory of the inspection instrument according to the specified sampling period;Y=(y₂-y₁)/(x₂-x₁)X+(y₁x₂-y₂x₁)/(x₂-x₁)    (公式一)Y=(y₂ -y₁ )/(x₂ -x₁ )X+(y₁ x₂ -y₂ x₁ )/(x₂ -x₁ ) (Formula 1)设x为时间，y为基表的温度值，其中x₁和x₂为温度曲线某段的起始和终止时间，y₁和y₂为该曲线起始和终止的温度值；Let x be the time, and y be the temperature value of the base table, where_x1 and_x2 are the start and end times of a certain section of the temperature curve, and_y1 and_y2 are the temperature values at the start and end of the curve;如数据库中有与缺失数据匹配的数据，则再判断数据精度要求，如数据精度要求高则以同一基表根据设定温度曲线值公式一计算得到的值Y_ji减去历史数据V_ji之后得到值进行平方取得方差值，取遍n个历史数据得到所对应n个方差值，取n个方差值中最小值，该最小方差值所对应历史数据V_ji为丢失温度数据值U_ji，以此方法来计算并补充缺失时间点或段的温度数据曲线，然后判断该段温度数据采样是否完成，如完成则将采集到的和补充完毕的温度曲线发送至上位机数据库后再读取下一段数据，如没有完成则上位机按照规定的取样周期继续读取巡检仪存储器中所述基表的实时温度值；If there is data matching the missing data in the database, then judge the data accuracy requirements. If the data accuracy requirements are high, use the same base table to calculate the value Y_ji according to the set temperature curve value formula 1 and subtract the historical data V_ji to get The value is squared to obtain the variance value, and n historical data are taken to obtain the corresponding n variance values, and the minimum value of the n variance values is taken, and the historical data V_ji corresponding to the minimum variance value is the lost temperature data value U_ji , use this method to calculate and supplement the temperature data curve of the missing time point or segment, and then judge whether the temperature data sampling of this segment is completed. If it is completed, send the collected and supplemented temperature curve to the host computer database for reading Take the next piece of data, if it is not completed, the host computer will continue to read the real-time temperature value of the base meter in the memory of the inspection instrument according to the specified sampling period;如数据精度要求低则按公式二来作为缺失时间点或段的温度数据曲线公式来计算并补充温度曲线，然后判断该段温度数据采样是否完成，如完成则将采集到的和补充完毕的温度曲线发送至上位机数据库后再读取下一段数据，如没有完成则上位机按照规定的取样周期继续读取巡检仪存储器中所述基表的实时温度值；If the data accuracy requirement is low, use formula 2 as the temperature data curve formula of the missing time point or segment to calculate and supplement the temperature curve, and then judge whether the temperature data sampling of this segment is completed. If it is completed, the collected and supplemented temperature After the curve is sent to the host computer database, the next piece of data is read. If it is not completed, the host computer continues to read the real-time temperature value of the base meter in the memory of the inspection instrument according to the specified sampling cycle;U_ji=ΣV_ji/n    (公式二)U_ji =ΣV_ji /n (Formula 2)U_ji为丢失温度数据值,V_ji为数据库中相同编号的巡检仪j和相同基表号i在同一设定温度曲线、同一温控段、同一时刻的温度值；ΣV_ji为n个历史数据之和；Y_ji为同一基表根据设定温度曲线值公式一计算得到的值。U_ji is the lost temperature data value, V_ji is the temperature value of the inspection instrument j with the same number and the same base meter number i in the database at the same set temperature curve, the same temperature control section, and the same time; ΣV_ji is n historical The sum of the data; Y_ji is the value calculated by the same base table according to formula 1 of the set temperature curve value.