JP6131735B2 - Data management apparatus, data management method, and data management program - Google Patents

Description

  The present invention relates to a data management apparatus, a data management method, and a data management program for managing storage of measurement data of a sensor that performs measurement processing at a constant cycle in a database.

  Conventionally, the measurement value of multiple sensors arranged for management of temperature, humidity, etc. is sent to the central management device via the network, and the management device stores it in the database and performs management and control in a batch Is used. In such a technique, since all the measurement data of each sensor that performs measurement at a constant cycle is transmitted to the management device, the data transmission to the management device is concentrated and the communication load to the management device increases. In addition, there is a problem that the load of reception processing in the management apparatus increases.

  Therefore, in recent years, when the measurement value of the sensor does not change, instead of transmitting the measurement value every time, the previously transmitted measurement value includes the fact that the value matches and the number of times of coincidence indicating the number of times of coincidence. A technique has been proposed in which coincidence information is transmitted and the number of times of data transmission to the management apparatus is thinned out (see, for example, Patent Document 1). The management device that has received the match information writes the same value as the previously transmitted measurement value as many times as the number of matches in the sensor measurement data indicated by the match information among the measurement data stored in the database. The measurement value of the measurement time when data transmission was not performed is complemented.

JP 2013-3837 A

  However, in the case of the technique described in Patent Document 1, since all the measurement values of each sensor are stored in the database, there is a problem that the amount of data held in the database becomes very large.

  The present invention has been made in view of the above, and provides a data management device, a data management method, and a data management program capable of reducing the amount of sensor measurement data stored in a database. With the goal.

In order to solve the above-described problems and achieve the object, a data management device according to the present invention is a data management device that manages the storage of measurement data of a sensor that performs measurement processing at a constant cycle in a database, In the first measurement value measured by the sensor, the absolute value of the difference between the first measurement value and the second measurement value measured one time before the first measurement value is greater than or equal to a predetermined value. In some cases, data selection means for selecting measurement data including the first measurement value and the measurement date and time of the first measurement value as measurement data to be stored in the database; and the data selection means stores the data. Data storage processing means for storing the measurement data selected as the measurement data to be stored in the database, and data output instruction information for indicating the date and time when the measurement data of the sensor should be output are input. And when the data output instruction information is input by the input means, the measurement data corresponding to the date and time to be output can be searched from the measurement data stored in the database, and the measurement data of the date and time to be output can be searched. If not, output data creation means for creating the measurement data of the date and time to be output based on the measurement data measured on the date and time closest to the date and time of output from the measurement data of the database, It is characterized by that.

  Further, in the data management device according to the present invention, when the output data creation means cannot retrieve the measurement data of the date and time to be output, from the date and time of output from the measurement data stored in the database. The measurement value of the measurement data having the closest date and time is extracted, and the measurement value of the extracted measurement data is employed as the measurement value of the date and time to be output.

  The data management apparatus according to the present invention further comprises storage means for storing a data selection date and time that is a date and time when the data selection means has selected measurement data to be stored in the database, and the data selection means includes the storage Each time measurement data to be selected is selected, the data selection date and time stored in the storage means is updated to the latest date and time, and the absolute value of the difference between the first measurement value and the second measurement value is the predetermined value. If it is above, there is a change indicating that the first measurement value has changed with respect to the second measurement value in addition to the first measurement value and the measurement date and time of the first measurement value. When the measurement data including information is selected as the measurement data to be stored, and the absolute value of the difference between the first measurement value and the second measurement value is less than the predetermined value, the first data Select the measured value of In the case where the judgment timing for declining exceeds a predetermined storage duty period from the data selection date and time stored in the storage means, in addition to the first measurement value and the measurement date and time of the first measurement value, Measurement data including no-change information indicating that the measurement value of 1 has not changed with respect to the second measurement value is selected as the measurement data to be stored.

  In the data management device according to the present invention, when the output data creation means cannot retrieve the measurement data of the date and time to be output, the output data creation means is the most suitable for the date and time of output from the measurement data stored in the database. Extracting measurement data measured at a close date and time, when the extracted measurement data includes the no-change information, adopt the measurement value of the extracted measurement data as the measurement value of the date and time to be output and extract the data When the measurement data includes the information with change, the measurement data of the closest date and time is extracted from the measurement data stored in the database before the date and time to be output and extracted. The measurement value of the measurement data of the closest date and time before the date and time of output is adopted as the measurement value of the date and time of output To.

  In the data management device according to the present invention, the data selection means may be configured such that when the absolute value of the difference between the first measurement value and the second measurement value is greater than or equal to the predetermined value, Measurement data including the measurement value and the measurement date and time of the first measurement value and the previous difference value obtained by subtracting the second measurement value from the first measurement value is to be stored in the database If the measurement data of the date and time to be output cannot be retrieved, the output data creation means selects the measurement value of the measurement data measured at the date and time closest to the date and time of output and the previous measurement data. The measurement data of the date and time to be output is created based on the difference value.

  Further, in the data management device according to the present invention, when the output data creation means cannot retrieve the measurement data of the date and time to be output, from the date and time of output from the measurement data stored in the database. And the measurement data measured at the nearest date and time are extracted, and from the measurement value of the measurement data measured at the nearest date and time after the extracted date and time to be output A value obtained by subtracting the previous difference value of the measurement data is adopted as the measurement value of the date and time to be output.

The data management apparatus according to the present invention further comprises storage means for storing a data selection date and time that is a date and time when the data selection means has selected measurement data, and the data selection means includes the measurement data to be stored. The data selection date and time stored in the storage means is updated to the latest date and time, and the absolute value of the difference between the first measurement value and the second measurement value is less than the predetermined value When the selection date and time for the first measurement value exceeds a predetermined storage duty period from the data selection date and time stored in the storage means, the first measurement value and the first measurement In addition to the measurement date and time of the value, measurement data with the previous difference value set to 0 is selected as the measurement data to be stored.

  In the data management device according to the present invention, when the output data creation means cannot retrieve the measurement data of the date and time to be output, the output data creation means is the most suitable for the date and time of output from the measurement data stored in the database. When near measurement data is extracted and the measurement date and time of the extracted measurement data is earlier than the date and time of output, the measurement value of the extracted measurement data is adopted as the measurement value of the date and time of output and the extraction When the measurement date / time of the measured data is later than the output date / time, the measured value of the date / time to output the value obtained by subtracting the previous difference value of the extracted measurement data from the measured value of the extracted measurement data It is adopted as a feature.

  The data management apparatus according to the present invention is characterized in that the data selection means and the data storage processing means are connected via a network.

  Further, the data management method according to the present invention is a data management method performed by a data management device that manages measurement data of a sensor that performs measurement processing at a constant cycle. In the first measurement value measured by the sensor, When the absolute value of the difference between the first measurement value and the second measurement value measured one time before the first measurement value is greater than or equal to a predetermined value, the first measurement value and the first measurement value A data selection step for selecting measurement data including the measurement date and time of one measurement value as measurement data to be stored in the database, and the measurement data selected as the measurement data to be stored in the data selection step in the database When the data storage processing step to store and the data output instruction information indicating the date and time when the measurement data of the sensor should be output are input, the database If the measurement data corresponding to the date and time to be output is searched from the stored measurement data and the measurement data of the date and time to be output cannot be searched, the measurement data in the database is the most suitable for the date and time to be output. An output data creation step of creating measurement data of the date and time to be output based on measurement data measured at a near date and time.

  In addition, the data management program according to the present invention provides a data management apparatus that manages measurement data of a sensor that performs measurement processing at a constant period, and uses the first measurement value measured by the sensor. When the absolute value of the difference between the first measurement value and the second measurement value measured once before the value is greater than or equal to a predetermined value, the first measurement value and the first measurement value A data selection procedure for selecting measurement data including measurement date and time as measurement data to be stored in the database, and a data storage process for storing the measurement data selected as measurement data to be stored in the data selection procedure in the database If the procedure and the data output instruction information indicating the date and time when the measurement data of the sensor should be output are input, whether the measurement data is stored in the database. If the measurement data corresponding to the date and time to be output is searched, and the measurement data of the date and time to be output cannot be searched, the measurement data measured at the date and time closest to the date and time to be output from the measurement data of the database And an output data creation procedure for creating measurement data of the date and time to be output based on the above.

According to the present invention, not all measurement data of measurement processing by each sensor, but measurement data including measurement values that have a difference of a predetermined value or more with respect to the previous measurement value is selected from each measurement value in the database. Since the data is stored, it is possible to reduce the amount of measurement data by the sensor stored in the database.

FIG. 1 is a block diagram of the configuration of the data management apparatus according to the first embodiment. FIG. 2 is a flowchart showing a processing procedure of measurement data selection processing to be stored by the data selection unit shown in FIG. FIG. 3 is a diagram illustrating a table illustrating the contents of the measurement data for management stored in the database illustrated in FIG. FIG. 4 is a flowchart showing a processing procedure of output data creation processing in the output data creation unit shown in FIG. FIG. 5 is a diagram illustrating an example of output measurement data created by the output data creation unit illustrated in FIG. 1. FIG. 6 is a diagram illustrating a table illustrating the contents of measurement data stored in a database according to the related art. FIG. 7 is a flowchart illustrating a processing procedure of measurement data selection processing to be stored in the first modification of the first embodiment. FIG. 8 is a diagram showing another example of the table showing the contents of the management measurement data shown in FIG. FIG. 9 is a flowchart illustrating a processing procedure of output data creation processing according to the second modification of the first embodiment. FIG. 10 is a block diagram of the configuration of the data management system according to the second embodiment. FIG. 11 is a flowchart showing a processing procedure for selecting measurement data to be stored in the data selection unit shown in FIG. FIG. 12 is a block diagram of the configuration of the data management apparatus according to the third embodiment. FIG. 13 is a flowchart showing a processing procedure for selecting measurement data to be stored in the data selection unit shown in FIG. FIG. 14 is a diagram illustrating a table illustrating the contents of the management measurement data illustrated in FIG. FIG. 15 is a flowchart showing a processing procedure of output data creation processing in the output data creation unit shown in FIG. FIG. 16 is a diagram illustrating an example of output measurement data created by the output data creation unit illustrated in FIG. 12. FIG. 17 is a flowchart illustrating a processing procedure of measurement data selection processing to be stored in the first modification of the third embodiment. FIG. 18 is a diagram showing another example of a table showing the contents of the management measurement data shown in FIG. FIG. 19 is a flowchart illustrating a processing procedure of output data creation processing according to the second modification of the third embodiment. FIG. 20 is a block diagram of the configuration of the data management system according to the fourth embodiment. FIG. 21 is a flowchart showing a processing procedure for selecting measurement data to be stored in the data selection unit shown in FIG.

Hereinafter, as an example of an embodiment according to the present invention, a data management apparatus that manages storage of measurement data of a sensor that performs measurement processing at a constant period in a database will be described. Note that the present invention is not limited to the embodiments. In the description of the drawings, the same parts are denoted by the same reference numerals.

(Embodiment 1)
FIG. 1 is a block diagram of the configuration of the data management apparatus according to the first embodiment. As shown in FIG. 1, the data management apparatus 1 according to the first embodiment includes an input unit 10, a control unit 20, a sensor group 30, a data collection unit 40, a data selection unit 50, a data storage processing unit 60, and each sensor. Data for processing in the database 70, the output data creation unit 80, the output unit 90, and the data collection unit 40 and the data selection unit 50 storing the management measurement data 71 in which the measurement values are written are temporarily stored. A memory 100 is provided.

  The input unit 10 includes input devices such as a keyboard, various buttons, and various switches, and pointing devices such as a mouse and a touch panel, and inputs instruction signals corresponding to user operations on these devices to the control unit 20. The input unit 10 inputs data output instruction information for instructing a sensor that is a data output target and a period during which measurement data from the sensor is to be output.

  The control unit 20 executes various programs and parameters to control each process and each operation of each component of the data management device 1. The control unit 20 performs input / output control on data input / output to / from each component of the data management apparatus 1 and causes each component to perform predetermined processing on the data.

  The sensor group 30 includes a plurality of sensors including a first sensor 31 and a second sensor 32. The first sensor 31 and the second sensor 32 are temperature sensors, each installed in a predetermined management area, and performing measurement processing for measuring the temperature of the corresponding management area at a constant period. 1 illustrates the sensor group 30 including the first sensor 31 and the second sensor 32 that are temperature sensors, but various parameters such as humidity, pH value, weight, and brightness are measured in addition to the temperature. It may be a sensor group consisting of sensors. Further, FIG. 1 illustrates an example in which there are a plurality of sensors, but of course, a single sensor may be provided.

  The data collection unit 40 is connected to each sensor of the sensor group 30, collects measurement values measured by each sensor of the sensor group 30 including the first sensor 31 and the second sensor 32, collects the measurement values, and this The identification information of the sensor that has performed the measurement is attached to the measurement date and time of the measurement value, and is output to the data selection unit 50.

  The data selection unit 50 selects measurement data to be stored in the database 70 from the data output from the data collection unit 40. Each time data is input from the data collection unit 40, the data selection unit 50 determines whether this data is measurement data to be stored in the database 70, and determines that this data is measurement data to be stored in the database 70. In this case, this data is selected as measurement data to be stored in the database 70. The memory 100 temporarily holds a data selection date and time that is the date and time when the data selection unit 50 selected measurement data to be stored in the database 70, and the data selection unit 50 selects the measurement data to be stored each time. The data selection date and time stored in the memory 100 is updated to the latest one. The data selection unit 50 selects measurement data for each sensor in the sensor group 30. With this selection, the data selection date and time stored in the memory 100 is also stored corresponding to each sensor of the sensor group 30. The measurement data selection process in the data selection unit 50 is performed immediately after the measurement data is collected by the data collection unit 40. The measurement process of the sensors in the sensor group 30, the collection process of the measurement data by the data collection unit 40, And the selection process of measurement data in the data selection part 50 is performed substantially in real time.

  When the measured value measured by the sensor is equal to or greater than a predetermined value, the absolute value of the difference between the measured value and the previous measured value measured once before the measured value is selected by the data selection unit 50. Measurement data including the measurement value and the measurement date and time of the measurement value is selected as measurement data to be stored in the database 70. In this case, the data selection unit 50 includes, as the measurement data to be stored, change information indicating that the measurement value has changed with respect to the previous measurement value, in addition to the selected measurement value and the measurement date and time. The data is output to the data storage processing unit 60. The data selection unit 50 is a case where the absolute value of the difference between the measurement value to be determined and the previous measurement value is less than a predetermined value, and the determination processing timing for this measurement value is determined from the data selection date and time stored in the memory 100. If the specified storage duty period has been exceeded, in addition to this measurement value and the measurement date and time of this measurement value, no change information indicating that this measurement value has not changed from the previous measurement value. The included measurement data is selected as measurement data to be stored. Note that the previous measurement value is held in the memory 100 for each sensor, and when the determination process for one measurement value is completed, the measurement value is rewritten to the measurement value for which the determination process is completed. In addition, the predetermined value, which is a criterion for determining whether or not there is a change from the previous measurement value, is set for each sensor according to the management area where the sensor is installed, the type of parameter measured by the sensor, and the like. Moreover, not only when one value is set for one sensor, the measurable range of the sensor may be divided into a plurality of values, and a value may be set for each divided range. Further, the storage duty period is set for each sensor according to the management area where the sensor is installed, the type of parameter measured by the sensor, and the like.

  The data storage processing unit 60 stores the measurement data selected as the measurement data to be stored by the data selection unit 50 in the database 70. The data storage processing unit 60 stores, in the database 70, the association of the measurement date / time, the sensor type, the measurement value, and the change presence / absence information indicating the presence / absence of change with respect to the previous measurement value in the selected measurement data. New measurement data 71 is written.

  When the data output instruction information is input from the input unit 10, the output data creation unit 80 outputs the data output from the sensor instructed by the data output instruction information based on the management measurement data 71 stored in the database 70. Output measurement data is created by associating the date and time of each measurement process measured during the period indicated by the instruction information with the measurement value. When the output of the measurement data of the sensor that performs measurement every hour is instructed, data in which the measurement value is expressed by the hour is generated in the instructed period.

  The output data creation unit 80 can retrieve the measurement data from the database 70 when all the measurement data of the measurement processing measured by the instruction target sensor cannot be retrieved during the period designated by the data output instruction information. For the measurement data of the date and time that did not exist, the measurement data for the period that is before this date and time, and the output is complemented with the measurement value of the measurement data measured at the closest date and time to output Create

  The output unit 90 includes a printer, a display such as a liquid crystal display or an organic electroluminescence display, and the like. The output unit 90 outputs a paper surface on which the measurement data created by the output data creation unit 80 is printed. The output unit 90 displays the measurement data created by the output data creation unit 80 on the display. The measurement data output by the output unit 90 corresponds to the date and time of the measurement process measured by the sensor instructed to output by the data output instruction information in the period instructed to output the measurement data and the measurement value at each date and time. It will be attached.

Next, the measurement data selection process to be stored by the data selection unit 50 will be described. FIG. 2 is a flowchart showing a processing procedure of measurement data selection processing to be stored by the data selection unit 50.

  As shown in FIG. 2, first, the data selection unit 50 acquires a measurement value of a sensor that is a target of data storage determination (step S1). Subsequently, the data selection unit 50 determines whether or not the absolute value of the difference between the acquired measurement value and the previous measurement value at the measurement timing one time before the measurement timing of the measurement value is greater than or equal to a predetermined value. (Step S2).

  When the data selection unit 50 determines that the absolute value of the difference between the acquired measurement value and the previous measurement value is greater than or equal to a predetermined value (step S2: Yes), it indicates that there is a change with respect to the previous measurement value. Information “changed” is added to the measurement data (step S3), and the measurement data corresponding to the measurement value is selected as measurement data to be stored in the database 70 (step S4).

  On the other hand, when the data selection unit 50 determines that the absolute value of the difference between the acquired measurement value and the previous measurement value is not equal to or greater than a predetermined value (step S2: No), the date and time of the timing at which this determination process is actually performed. The difference between a certain current date and time and the data selection date and time of the memory 100 is calculated (step S5). The data selection unit 50 determines whether or not the calculated difference is equal to or longer than a predetermined storage duty period (step S6).

  When the data selection unit 50 determines that the calculated difference is not equal to or longer than the predetermined storage duty period (step S6: No), the measurement data corresponding to the measurement value is not the measurement data to be stored in the database 70. For this measurement value, the selection determination process ends, the process proceeds to step S1, and the measurement value of the sensor to be determined next is acquired. Accordingly, a measurement value that has not changed by a predetermined value or more from the previous measurement value and is within a certain storage duty period from the previous data selection date and time is not selected by the data selection unit 50 and is not stored in the database 70.

  When the data selection unit 50 determines that the calculated difference is equal to or greater than the predetermined storage duty period (step S6: Yes), information “no change” indicating that there was no change with respect to the previous measurement value is used as measurement data. The measurement data corresponding to the measurement value is selected as measurement data to be stored in the database 70 (step S4). Therefore, the data selection unit 50 stores the measurement data so that the measurement data is stored in the database 70 for each fixed storage duty period even when the measurement value that does not change by more than the predetermined value continues from the previous measurement value. A selection is made so that the presence / absence of an abnormality of the sensor can also be determined.

  After step S4 ends, the data selection unit 50 updates the data selection date and time stored in the memory 100 to the latest date and time, that is, the current date and time when the current processing is performed (step S8), and proceeds to step S1. The measured value of the sensor to be determined next is acquired.

  Only the measurement data selected as the measurement data to be stored by the data selection unit 50 in step S4 shown in FIG. 2 is stored in the database 70 by the data storage processing unit 60. FIG. 3 is a diagram illustrating a table illustrating the contents of the management measurement data 71 stored in the database 70. As shown in the table T1 of FIG. 3, the management measurement data 71 includes, in order from the left in the drawing, a change presence / absence indicating whether there is a change with respect to the previous measurement value in addition to the measurement date / time field L1, the sensor type field L2, and the measurement value L3 A column L4 is provided side by side, and for each measurement process, the measurement date and time, sensor type, measurement value, and change presence / absence information are sequentially written in each cell so as to be arranged in a horizontal row.

For example, a case where the first sensor 31 performs measurement processing every hour and is required to store measurement data in the database 70 in three hours from the previous storage will be described as an example. First, when the measurement value of 0:00 on January 2 of the first sensor 31 does not change from the previous measurement value but is data when 3 hours or more have elapsed since the previous storage, the table T1
To the row R10 of “January 2 0:00” as the measurement date, “first sensor” indicating the sensor type, “20.0” as the measurement value, and the data selection unit 50. “None” indicating no change information is written. If the measurement value measured by the first sensor 31 at 1:00 on January 2 and 2:00 on January 2 does not change from the previous measurement, January 2 of the previous storage is stored. Since the data is less than 3 hours from 0:00, it is not selected by the data selection unit 50 and is not written in the table T1.

  The next measurement value measured by the first sensor 31 at 3:00 on January 2 corresponds to the value that has passed 3 hours from 0:00 on January 2 stored in the previous time. Selected. In this example, since there is no change from the previous measurement value, the data selection unit 50 adds the no-change information and selects the storage target. As a result, the row R13 of the table T1 indicates “January 2 3:00” as the measurement date, “first sensor” as the sensor type, “20.0” as the measurement value, and no change information. “None” is written. If the measurement data measured by the first sensor 31 at 4:00:00 on January 2 does not change from the previous measurement, it will be 3 hours from the previous storage as with 12:00 on January 2. Since it is less than the data, it is not selected by the data selector 50 and is not written to the table T1.

  When the measurement data measured by the first sensor 31 at 5:00:00 on January 2 has changed by a predetermined value or more from the previous measurement value, the data selection unit 50 adds the change presence information and stores the data. Selected as. As a result, the row R15 of the table T1 indicates “January 2 5:00” as the measurement date, “first sensor” as the sensor type, “30.0” as the measurement value, and information with change. “Yes” is written. If the measurement data measured by the first sensor 31 at 6:00:00 on January 2 does not change from the previous measurement value, it will be 3 Since the data is less than the time, it is not written in the table T1. When the measurement data measured by the first sensor 31 at 7:00 on January 2 has changed from the previous measurement value, as in the case of 5:00 on January 2, the table T1 In row R17, “January 2 7:00” as the measurement date, “first sensor” as the sensor type, “40.0” as the measurement value, and “present” as the change information are written. .

  Therefore, there is no change from the previous measurement value, and furthermore, the storage duty period has not elapsed since the previous storage, 2:00 on January 2, 2:00 on January 2, 4:00 on January 2, and The table T1 from which the measurement data at 6:00:00 on January 2 is missing becomes the management measurement data 71. When the data output instruction information is input, the output data creation unit 80 sets the measurement value of the measurement data missing from the management measurement data 71 in this way before the measurement date and time of the missing measurement data. In addition, by complementing based on the measurement values of the measurement data of the nearest date and time, the measurement values of all the measurement processes performed by the output instruction target sensor during the output instruction period are in order of measurement date and time. Create arrayed output measurement data.

  The output measurement data creation process performed by the output data creation unit 80 will be described with reference to FIG. FIG. 4 is a flowchart showing a processing procedure of output data creation processing in the output data creation unit 80.

As shown in FIG. 4, when the output data creation unit 80 receives an instruction to output measurement data from the data output instruction information by the input unit 10 (step S11), the data output instruction information is obtained from the management measurement data 71 in the database 70. The measurement data from the start date and the end date of the period instructed to be output is extracted (step S12). Then, the output data creation unit 80 creates each measurement date and time in order to create measurement data for output in which the measurement values of all the measurement processes performed by this sensor during the period in which the output is instructed are arranged in order of the measurement date and time. The process which acquires each measured value is performed. For this reason, the output data creation unit 80 first searches for the measurement data corresponding to the start date and time of the output instruction period from the extracted measurement data (step S13), and starts the search target in the extracted measurement data. It is determined whether there is date and time measurement data (step S14).

  When the output data creation unit 80 determines that there is measurement data of the start date / time to be searched (step S14: Yes), the measurement value of the measurement data of the start date / time found by searching is directly adopted as the measurement value of the start date / time. (Step S15).

  On the other hand, when the output data creation unit 80 determines that there is no measurement data of the start date / time of the search target (step S14: No), the measurement data of the start date / time of the search target is not stored in the database 70. In this case, it corresponds to a value that has not changed from the previously measured value. For this reason, the output data creation unit 80 extracts from the management measurement data 71 the measurement data of the closest date and time before the search target date and time (step S16), and this extracted measurement. The measured value of data is adopted as the measured value of the acquisition target date and time (step S17).

  Whether or not the output data creation unit 80 has completed the search of the measurement data until the end date and time of the period indicated by the data output instruction information after acquiring the measurement value of the acquisition date and time in the process of step S15 or step S17. Is determined (step S18).

  When the output data creation unit 80 determines that the search of the measurement data is not finished until the end time (step S18: No), the output data creation unit 80 outputs the measurement value for the date and time when this sensor performed the next measurement process. From the extracted measurement data corresponding to the instruction period, the measurement data of the date and time when the next measurement process to be acquired is performed is searched (step S19), and the process performed for acquiring the measurement value of the start date and time is performed. The process after step S14 is performed.

  On the other hand, when the output data creation unit 80 determines that the search of the measurement data has been completed until the end time (step S18: Yes), all the measurement values of all the measurement processes in the output instruction period can be acquired. Output measurement data in which measurement values of all measurement processes in the period instructed to be output are arranged in order of measurement date and time is created and output (step S20), and the output measurement data creation process is terminated.

  With reference to FIG. 3 and FIG. 5, the process of creating output measurement data in FIG. 4 will be specifically described. FIG. 5 is a diagram illustrating an example of output measurement data created by the output data creation unit 80. Here, a case where the first sensor 31 is instructed to output measurement data from January 2, 0:00 to January 2, 7:00 will be described as an example. As shown in the table T2 of FIG. 5, the measurement data for output includes a measurement date / time column L1, a sensor type column L2, and a measurement value L3 in order from the left in the drawing.

  First, the output data creation unit 80 retrieves data on January 2, 00:00, which is the start date and time, from the table T1 in FIG. Since the data of 0:00 on January 2 corresponds to the data in the row R10 of the table T1, when the output data creation unit 80 finds the data in the row R10, the measured value “20.0 in the row R10 is obtained. "Is used as it is as the measured value at 00:00 on January 2. As a result, in the table T2 of FIG. 5, a row R10-1 associated with the measurement value “20.0” of the “first sensor” 31 at 0:00 on January 2 is arranged.

Subsequently, the output data creation unit 80 searches for data at 1:00 on January 2 on which the next measurement process was performed. Since the data of 0:00 on January 2 is not included in the table T1, the output data creation unit 80 is earlier than 10:00 on January 2 in the table T1, and Then, the data of the row R10 closest to 02:00 on January 2 is extracted, and the measured value “20.0” of the extracted row R10 is adopted as the measured value of 12:00 on January 2. As a result, as indicated by the arrow Y1, the measurement value “20.0” at 0:00 on January 2 as the measurement value of the row R11-1 corresponding to 1:00 on January 2 in the table T2. Is complemented. Similarly, since the next data of 2:00 on Jan. 2 is not included in the table T1, the output data creation unit 80 selects the data from the table T1 before 2:00 on Jan. 2. In addition, the closest data at 00:00 on January 2 is extracted, and the measured value “20.0” at 00:00 on January 2 is 1 in the row R12-1, as indicated by the arrow Y2. It is supplemented as a measurement value at 2:00 on March 2.

  Since the next data of 3:00:00 on January 2 corresponds to the extracted data of the row R13, the output data creation unit 80 sets the measured value “20.0” of the row R13 to the row R13− of the table T2. 1 is used as it is as a measurement value at 3 o'clock on January 2nd. Since the next data of 4:00:00 on January 2 is not included in the table T1, the output data creation unit 80 is before 4:00:00 on January 2 in the table T1. And, the data of the row R13 of January 2 3:00 is extracted, and the measurement value “20.0” of January 2 3:00 is the row R14-1 as indicated by the arrow Y3. It is supplemented as a measured value at 4:00:00 on January 2. Since the next data of 5:00 on January 2 corresponds to the data in the row R15 of the table T1, the output data creation unit 80, as shown in the row R15-1 of the table T2, The measurement value “30.0” of R15 is directly adopted as the measurement value at 5:00:00 on January 2. Since the next data on January 2 at 6:00:00 is not included in the table T1, the output data creation unit 80 is in the table T1 before 6:00:00 on January 2. And the nearest data of 5:00 on January 2nd is extracted, and the measured value “30.0” on January 2nd at 5:00:00 is taken as January 2 of row R16-1 as indicated by arrow Y4. It is supplemented as a measurement value at 6:00 on the day. Further, since the next data of 7:00 on January 2 corresponds to the data of the row R17 of the table T1, as shown in the row R17-1 of the table T2, the measured value “40.0” of the row R17 is displayed. "Is adopted as it is as a measurement value at 7:00 on January 2nd.

  As a result, in the data management device 1, as shown in the table T2 of FIG. 5, the first sensor 31 is set to 1 during the period from 0:00 on January 2 to 7:00 on January 2 when the output is instructed. Output measurement data that is arranged in order of measurement date and time is created and output without missing all the measured values measured every time. In this table T2, the measurement date and time “January 2 5:00” on line R15 and the measurement date and time “January 2 7:00 on January 2” in which the measurement values in table T1 in FIG. ”Shows a measurement value that has changed by a predetermined value or more from the measurement value of the previous measurement date and time, so that it can be confirmed that the measurement data is accurate corresponding to the measurement value of the actual measurement process. As shown in FIG. 5, the output data creation unit 80 outputs the case where the period in which the data output is instructed by the data output instruction information is a period including a plurality of measurement processes by the first sensor 31 as an example. The case of creating measurement data for use has been explained, but when the measurement process is performed only once, or when the data output instruction information designates one date and time to instruct the output of measurement data Also, the output data creation unit 80 creates measurement data by performing each process shown in FIG.

  Here, conventionally, all measurement data of measurement processing by each sensor is stored in a database. Specifically, as shown in a table T10 of FIG. 6, data in which all measured values measured by the first sensor 31 every hour are sequentially expressed in time units was stored. Therefore, in the past, for all the sensors installed in large numbers, all the measured values measured for each sensor measurement cycle are stored in the database as they are, so the amount of data stored in the database is very large. There was a problem of becoming.

On the other hand, in the first embodiment, instead of storing all the measurement data of the measurement processing by each sensor in the database 70, a measurement value that has changed from the previous measurement value by a predetermined value or more is selected from each measurement value. Selection is made as measurement data to be stored in the database 70, and only a part of the selected measurement data is stored in the database 70. In the example shown in FIG. 3, only four measurement values of the measurement values actually measured eight times from 2:00 on January 2 to 7:00 on January 2 are stored in the database 70. As described above, in the first embodiment, since only a part of the measurement data of each sensor is stored in the database 70, the sensor stored in the database 70 is compared with the case of storing all the measurement data. The amount of measurement data can be reduced.

  Further, in the first embodiment, the measurement values that are not stored in the database 70 remain from the measurement values measured before this measurement value to a change less than a predetermined value. For this reason, in the first embodiment, even when output is required for a measurement value that is not stored in the database 70, this output is before the measurement date and time of the instructed measurement value. And since it can complement using the measured value measured at the nearest date and time, the measurement data by the sensor can be reproduced accurately. Moreover, in Embodiment 1, since the measured value of several date is supplemented from the value of the measured data of one date, it can process efficiently.

  Further, in the first embodiment, measurement data is stored in the database 70 at a constant cycle for each storage duty period even if there is no change of a predetermined value or more from the previous measurement value among the measurement values. Since the measurement data is selected, whether or not there is an abnormality in the sensor can be determined based on the presence or absence of the measurement value stored at this fixed period.

(Modification 1 of Embodiment 1)
Next, Modification 1 of Embodiment 1 will be described. In the first modification of the first embodiment, the measurement data selection process is performed so that the data amount of the sensor measurement data stored in the database 70 is reduced as compared with the first embodiment. FIG. 7 is a flowchart illustrating a processing procedure of measurement data selection processing to be stored in the first modification of the first embodiment.

  As shown in FIG. 7, steps S21 to S24 correspond to steps S1 to S4 in FIG. On the other hand, when the data selection unit 50 determines that the absolute value of the difference between the acquired measurement value and the previous measurement value is not equal to or greater than a predetermined value (step S22: No), the measurement date and time of the measurement value is a predetermined storage reference time. Is determined (step S25). The storage reference time is set for each sensor according to the management area where the sensor is installed, the type of parameter measured by the sensor, and the like. When the data selection unit 50 determines that the measurement date / time of the measurement value is not the predetermined storage reference time (step S25: No), the process of selecting and determining the measurement value is terminated, and the process proceeds to step S21. The measured value of the sensor to be determined is acquired.

  When the data selection unit 50 determines that the measurement date / time of the measurement value is the predetermined storage reference time (step S25: Yes), the fact that there has been no change with respect to the previous measurement value is the same as in step S7 shown in FIG. “No change” information is added (step S26). Accordingly, when there is no change of a predetermined value or more from the previous measurement value, data other than measurement data at a fixed storage reference time is not stored in the database 70. For example, when the storage reference time is set to 0:00, as illustrated in the table T3 of FIG. 8, measurement data that does not change more than a predetermined value from the previous measurement value in the data on January 2 Is stored in the database in a state in which “nothing” indicating no change information is written, only the measurement data at 00:00 on January 2 of the storage reference time. Therefore, the table T3 in FIG. 8 is obtained by deleting the row R13 from the table T1 in FIG. The subsequent step S27 in FIG. 7 corresponds to step S8 shown in FIG. In the first modification of the first embodiment, the output data creation unit 80 creates output measurement data by performing each processing procedure shown in FIG.

As described above, in the first modification of the first embodiment, when the measurement value does not change more than the predetermined value, the measurement value other than the predetermined storage reference time is not selected as the storage target. It is possible to reduce the amount of sensor measurement data stored in the database 70 rather than 1. Further, in the first modification of the first embodiment, the measurement data at the storage reference time is stored even when the measurement value does not change by a predetermined value or more. Also, the determination can be made based on the presence or absence of the measurement value stored at the storage reference time.

(Modification 2 of Embodiment 1)
Next, a second modification of the first embodiment will be described. In the second modification of the first embodiment, output data is created by using change presence / absence information attached to each measurement value included in the management measurement data 71. FIG. 9 is a flowchart illustrating a processing procedure of output data creation processing according to the second modification of the first embodiment.

  Steps S31 to S35 shown in FIG. 9 correspond to steps S11 to S15 shown in FIG. When the output data creation unit 80 determines that there is no measurement data of the start date / time of the search target (step S34: No), the measurement data of the start date / time of the search target is not stored in the database 70, This corresponds to the case where there is no change from the previously measured value. Therefore, the output data creation unit 80 extracts the measurement data having the date and time closest to the search target date and time from the management measurement data 71 (step S36), and the extracted change date / time information of the measurement data having the closest date and time is obtained. It is determined whether or not “no change” (step S37).

  When the output data creation unit 80 determines that the extracted information on whether or not there is a change at the nearest date and time is “no change” (step S37: Yes), the extracted data is extracted in the same manner as the measurement value of the date and time to be searched. The measurement value at the date and time closest to the search target date and time also corresponds to the measurement value that has not changed from the measurement value measured before that. Therefore, in this case, even if the measurement date / time of the extracted measurement data is either before or after the search target date / time, the measurement value of the search target date / time and the date / time closest to the search target date / time The measured value corresponds to a case where there is no change from the previously measured value. For this reason, the output data creation unit 80 employs the measurement value of the extracted measurement data of the nearest date and time as the measurement value of the start date and time that is the acquisition target (step S38).

  On the other hand, when the output data creation unit 80 determines that the change presence / absence information of the extracted measurement data at the nearest date and time is not “no change” (step S37: No), that is, when it is determined that there is “change”. When the closest date / time is after the date / time to be searched, the extracted measured value of the closest date / time is different from the measured value of the date / time to be searched. For this reason, the output data creation unit 80 determines whether or not the date and time of the measurement data extracted as the measurement data having the closest date and time is before the date and time to be searched (step S39). If the output data creation unit 80 determines that the date and time of the extracted measurement data is earlier than the date and time of search (step S39: Yes), the process proceeds to step S38, and the extracted measurement data of the nearest date and time is extracted. Is used as the measurement value of the start date and time that is the acquisition target.

  On the other hand, when the output data creation unit 80 determines that the date and time of the extracted measurement data is after the search target (step S39: No), the output data creation unit 80 determines the date and time of the search target. The measurement data of the nearest date and time is extracted again (step S40), and the measurement value of the extracted measurement data is adopted as the measurement value of the acquisition date and time (step S41). Steps S42 to S44 in FIG. 9 correspond to steps S18 to S20 in FIG.

  In this way, when the output data is created using the change presence / absence information attached to each measurement value included in the management measurement data 71, the period in which the output is instructed as in the first embodiment. It is possible to create output measurement data that is shown without missing all measured values.

(Embodiment 2)
Next, a second embodiment will be described. FIG. 10 is a block diagram of the configuration of the data management system according to the second embodiment.

  As shown in FIG. 10, the data management system 1A according to the second embodiment includes a data collection device 2A having a data selection unit 150, a data storage processing unit 60, a database 70, and an output data creation unit 80. The apparatus 3 </ b> A has a configuration connected via the network N.

  The data collection device 2A executes various programs and parameters to control the processing operation of each component of the data collection device 2A, and data to collect measurement data of each sensor of the sensor group 30 for each component A data selection unit 150 that selects measurement data to be stored in the database 70 of the data management apparatus 3A, a memory 102A in which the data selection date and time by the data selection unit 150 is temporarily stored, and a data selection unit A data transmission processing unit 112A that transmits the measurement data selected by 150 to the data management device 3A via the network N; The data transmission processing unit 112A, as measurement data selected by the data selection unit 150, data D1 in a format in which measurement date / time, sensor type, measurement value, and change presence / absence information indicating presence / absence of change with respect to the previous measurement value are associated with each other. Send. The data transmission processing unit 112A transmits the data as it is every time the data selection unit 150 selects the data to be transmitted, and collects the data transmission amount to the data management device 3A at a time when the transmission load is low and the transmission load is low. A plurality of data may be transmitted.

  The data management device 3A is transmitted from the data collection device 2A via the input unit 10, a control unit 23A that executes various programs and parameters to control processing operations of each component of the data management device 3A, and the network N. The data reception processing unit 113A that receives the measured data, the data storage processing unit 60 that stores the measurement data received by the data reception processing unit 113A in the database 70, the database 70, the output data creation unit 80, and the output unit 90 And have.

  Next, processing for selecting measurement data to be stored in the data selection unit 150 shown in FIG. 10 will be described. FIG. 11 is a flowchart illustrating a processing procedure for selecting and transmitting measurement data to be stored in the data collection device 202A.

  Steps S51 to S53 shown in FIG. 11 correspond to steps S1 to S3 shown in FIG. Step S55 shown in FIG. 11 corresponds to step S5 shown in FIG. The data selection unit 150 determines whether or not the acquired measurement value is a difference between the current date and time and the data selection date and time of the memory 102A equal to or greater than a predetermined transmission cycle (step S56). The transmission cycle is set for each sensor according to the management area in which the sensor is installed, the type of parameter measured by the sensor, and the like. When the data selection unit 150 determines that the calculated difference is not equal to or greater than the predetermined transmission cycle (step S56: No), the measurement data corresponding to the measurement value is not measurement data to be transmitted to the data management device 3A. Then, the selection determination process is finished for this measured value.

On the other hand, when the data selection unit 150 determines that the calculated difference is equal to or greater than the predetermined transmission cycle (step S56: Yes), the information “No change” is added to the measurement data as in step S7 shown in FIG. (Step S57). After step S53 or step S57 is completed, the data selection unit 150 selects the measurement data of the acquired measurement value as measurement data to be transmitted to the data management device 3A in order to store it in the database 70 in the data management device 3A. (Step S54). Subsequently, the data transmission processing unit 112A transmits the measurement data selected by the data selection unit 150 to the data management device 3A via the network N (step S58). Step S59 shown in FIG. 11 corresponds to step S8 shown in FIG. The data selection unit 150 performs the processing of steps S54 and S58 in FIG. 11 after performing steps S21 to 23, S25, and S26 shown in FIG. 7, and selects measurement data to be transmitted to the data management device 3A. May be. Further, the output data creation unit 80 creates measurement data for output by performing the processing procedure shown in FIG. 4 or FIG.

  In the second embodiment, even in the case where the data collection device 2A having the data collection unit data selection unit 150 and the data management device 3A having the data storage processing unit 60 are connected via the network N, each sensor Only the measurement data corresponding to the measurement value that has changed by a predetermined value or more with respect to the previous measurement value from the measurement values is selected as the measurement data to be stored in the database 70 and transmitted to the data management device 3A. For this reason, the second embodiment does not transmit all the measurement data of each sensor to the data management device 3A, but transmits only a part of the measurement data, so that data transmission to the management device reduces concentration. The communication load to the management apparatus can be suppressed, and a further effect that the load of reception processing in the management apparatus can be reduced can be achieved.

(Embodiment 3)
Next, Embodiment 3 will be described. In the third embodiment, not the change presence / absence information but the difference value with the previous measurement value is stored in the database in association with the measurement date / time, sensor type, and measurement value.

  FIG. 12 is a block diagram of the configuration of the data management apparatus according to the third embodiment. As illustrated in FIG. 12, the data management apparatus 201 according to the third embodiment includes a data selection unit 250 and an output data creation unit 280 instead of the data selection unit 50 and the output data creation unit 80 illustrated in FIG. 1. Further, like the control unit 20, the control unit 220 of the data management device 201 has a function of executing various programs and parameters to control each process and each operation of each component of the data management device 201.

  When the measurement value measured by the sensor has a difference of a predetermined value or more with respect to the previous measurement value of the measurement value, the data selection unit 250 measures the measurement value that is the determination target and the measurement value. Along with the date and time, measurement data including the previous difference value obtained by subtracting the previous measurement value from the measurement value is selected as measurement data to be stored in the database 70.

  The date and time when the output data creation unit 280 could not be searched when all the measurement data of the measurement processing measured by the instruction target sensor could not be searched from the database 70 during the period specified by the data output instruction information. For the measurement data, the measurement value is complemented based on the measurement value of the measurement data measured on the date and time closest to this date and the previous difference value, and measurement data for the specified period is created.

  Next, a measurement data selection process to be stored by the data selection unit 250 shown in FIG. 12 will be described. FIG. 13 is a flowchart showing a processing procedure for selecting measurement data to be stored in the data selection unit 250.

  Step S61 to step S62 shown in FIG. 13 correspond to step S1 and step S2 shown in FIG. When the data selection unit 250 determines that the absolute value of the difference between the acquired measurement value and the previous measurement value is greater than or equal to a predetermined value (step S62: Yes), the value obtained by subtracting the previous measurement value from the acquired measurement value Is set to the previous difference value of the measurement data (step S63), and the measurement data corresponding to the measurement value is selected as the measurement data to be stored in the database 70 (step S64).

On the other hand, when the data selection unit 250 determines that the absolute value of the difference between the acquired measurement value and the previous measurement value is not equal to or greater than the predetermined value (step S62: No), as in step S5 and step S6 of FIG. The difference between the current date and time and the data selection date and time of the memory 100 is calculated (step S65), and it is determined whether or not the calculated difference is equal to or longer than a predetermined storage duty period (step S66). When the data selection unit 250 determines that the calculated difference is not equal to or longer than the predetermined storage duty period (step S66: No), the selection determination process ends for this measurement value. When the data selection unit 250 determines that the calculated difference is equal to or longer than the predetermined storage duty period (step S66: Yes), the value of the previous difference of the measurement data is set to “0” (step S67). Measurement data corresponding to the measurement value is selected as measurement data to be stored in the database 70 (step S64). Step S68 shown in FIG. 13 corresponds to step S8 shown in FIG.

  In the third embodiment, by performing each process shown in FIG. 13, instead of the change presence / absence information described in the first embodiment, a value obtained by subtracting the previous measurement value from the acquired measurement value is used as the previous difference. The management measurement data 271 is stored in the database 70 in association with the sensor type and the measurement value. FIG. 14 is a diagram illustrating a table illustrating the contents of the management measurement data 271 stored in the database 70.

  As shown in the table T11 of FIG. 14, the management measurement data 71 includes, in order from the left in the figure, a previous difference indicating a difference value from the previous measurement value in addition to the measurement date / time field L1, the sensor type field L2, and the measurement value L3. A column L24 is provided side by side, and the measurement date and time, sensor type, measurement value, and previous difference value are sequentially written in each cell so as to be arranged in a horizontal row for each measurement process. Here, as in the first embodiment, the first sensor 31 performs measurement processing every hour, and is required to store the measurement data in the database 70 in a three-hour cycle. The unit 250 will be described by taking as an example a case where the selection process is performed on the same measurement result as that described with reference to FIG.

  First, the measurement data at 0:00 on January 2 of the first sensor 31 is data that has not changed from the previous measurement value but has passed 3 hours or more since the previous storage, so the row R20 of the table T11 includes , The measurement date and time “January 2 00:00”, the sensor type “first sensor”, the measurement value “20.0”, and the value of the previous difference added by the data selection unit 250 “0.0” is written. Then, the measurement data of 2:00 on January 2 and 2:00 on January 2 is the same as in FIG. Since the data is from 0 minutes to less than 3 hours, it is not selected by the data selection unit 250 and is not written in the table T11.

  The next measurement data at 3:00:00 on January 2 corresponds to data that has passed 3 hours from 00:00 on January 2 stored last time, and therefore the data selection unit 250 sets “0. After “0” is added, it is selected as a storage target. Therefore, in the row R23 of the table T11, the measurement date and time “January 2 3:00”, the sensor type “first sensor”, the measurement value “20.0”, and the previous difference The value “0.0” is written. The next measurement data at 4:00:00 on January 2 does not change from the previous measurement value, and therefore is not selected by the data selection unit 250 and is not written in the table T11.

  Since the measurement data at 5:00:00 on January 2 has changed from the previous measurement value by a predetermined value or more, the data selection unit 250 adds the difference value “+10.0” from the previous measurement value. Selected for storage. As a result, in the row R25 of the table T11, the measurement date and time “January 2 5:00”, the sensor type “first sensor”, the measurement value “30.0”, and the previous difference The value “+10.0” is written. The next measurement data at 6:00:00 on January 2 does not change from the previous measurement value, so it is not selected by the data selection unit 250 and is not written in the table T11.

  And since the measurement data at 07:00 on January 2 has been changed by a predetermined value or more from the previous measurement value, the data selection unit 250 is given a difference value “+10.0” from the previous measurement value. As a result of the above selection as the storage target, in the row R27 of the table T11, the measurement date and time “January 2 7:00”, the sensor type “first sensor”, and the measurement value “40.0” are displayed. ”And the previous difference value“ +10.0 ”are written.

  Therefore, there is no change from the previous measurement value, and furthermore, the storage duty period has not elapsed since the previous storage, 2:00 on January 2, 2:00 on January 2, 4:00 on January 2, and The table T11 from which the measurement data at 6:00:00 on January 2 is missing is stored in the database 70 as management measurement data 271.

  Next, output measurement data creation processing performed by the output data creation unit 280 will be described with reference to FIG. FIG. 15 is a flowchart showing a processing procedure of output data creation processing in the output data creation unit 280 shown in FIG.

  Steps S71 to S75 shown in FIG. 15 correspond to steps S11 to S15 shown in FIG. When the output data creation unit 280 determines that there is no measurement data for the search target date and time (step S74: No), the output data creation unit 80 selects the search target date and time from the management measurement data 71. After that, the measurement data of the closest date and time is extracted (step S76). The output data creation unit 280 subtracts the value of the previous difference of the extracted measurement data from the measurement value of the extracted measurement data (step S77), and adopts the calculated value as the measurement value of the acquisition target date and time. (Step S78). The measurement value at the date and time not written in the management measurement data 271 corresponds to the measurement value that has not changed from the measurement value measured before this date and time. Among the measurement data of the management measurement data 271, this date and time It can be obtained by subtracting the value of the previous difference from the measured value measured after the latest date and time. Step S79 to step S81 shown in FIG. 15 correspond to step S18 to step S20 shown in FIG.

  With reference to FIG. 14 and FIG. 16, the output measurement data creation processing of FIG. 15 will be specifically described. FIG. 16 is a diagram illustrating an example of output measurement data created by the output data creation unit 280. Here, as in the description in the first embodiment, a case will be described as an example in which measurement data output from the first sensor 31 from 0:00 on January 2 to 7:00 on January 2 is instructed. .

  First, the output data creation unit 280 searches the data on January 2, 0:00, which is the start date and time, from the table T11 of FIG. Since the data of 0:00 on January 2 corresponds to the extracted data of the row R20, when the output data creation unit 80 finds the data of the row R20, the measurement value “20.0” of the row R20 is obtained. Is directly adopted as the measured value at 00:00 on January 2. As a result, as shown in the table T12 of FIG. 16, the row R20-1 in which the measurement value “20.0” of the “first sensor” 31 at 0:00 on January 2 is associated is arranged.

Subsequently, the output data creation unit 280 searches for data of 12:00 on January 2 on which the next measurement process was performed. Since the data of 0:00 on January 2 is not included in the table T11, the output data creation unit 280 is later than 1:00 on January 2 in the table T11, and most The data of the row R23 on January 2 at 3:00, which is measurement data of the near date and time, is extracted, and the previous difference value “0.0” is subtracted from the measurement value “20.0” of the extracted row R23 “20.0” is adopted as the measurement value at 1:00 on January 2. As a result, the measurement value “20.0” is complemented as the measurement value of the row R21-1 corresponding to 12:00 on January 2 in the table T12 as indicated by the arrow Y11. Similarly, since the next data of 2:00 on January 2 is not included in the table T11, the output data creation unit 280 will later execute the data from the table T11 after 2:00 on January 2. In addition, the data of 3:00:00 on January 2 of the nearest date and time is extracted, and as shown by the arrow Y12, the previous difference value “0” from the measured value “20.0” on January 2 00:00 “20.0” obtained by subtracting “.0” is complemented as a measurement value at 2:02:00 on January 2 in row R22-1.

  Since the next data of 3:00:00 on January 2 corresponds to the extracted data of the row R23, the output data creation unit 280 sets the measured value “20.0” of the row R23 to the row R23− of the table T12. 1 is used as it is as a measurement value at 3 o'clock on January 2nd. Since the next data of 4:00 on January 2 is not included in the table T11, the output data creation unit 280 is later than 4:00 on January 2 in the table T11. In addition, the data of the row R25 of January 2nd 5:00 at the nearest date and time is extracted, and the previous difference value “+10.0” from the measured value “30.0” on January 2nd 5:00:00 "20.0" is subtracted as a measurement value at 4:00:00 on January 2 in row R24-1. Since the next data of 5:00 on January 2 corresponds to the data in the row R25 of the table T11, the output data creation unit 280 displays this row as shown in the row R25-1 of the table T12. The measurement value “30.0” of R25 is directly adopted as the measurement value at 5:00:00 on January 2. Since the next data of 6:00:00 on January 2 is not included in the table T11, the output data creation unit 280 is later than 6:00:00 on January 2 in the table T11, And the data of 7:00:00 on January 2 of the nearest date and time is extracted, and as shown by the arrow Y14, the previous difference value “+10. “30.0” obtained by subtracting “0” is supplemented as a measurement value at 6:00:00 on January 2, row R26-1. Further, since the next data of 7:00 on January 2 corresponds to the row R27 of the table T11, as shown in the row R27-1 of the table T12, the measured value “40.0” of the row R27. Is directly adopted as the measurement value at 07:00 on January 2nd.

  As a result, in the data management apparatus 201, as shown in the table T12 of FIG. 16, the first sensor 31 is set to 1 between 0:00 on January 2 and 7:00 on January 2 when the output is instructed. Output measurement data arranged in order of measurement date and time is output without missing all the measured values measured every time.

  Thus, in the third embodiment as well, in the same way as in the first embodiment, only a part of the measurement data selected by the data selection unit 250 is stored in the database 70, so that it is compared with the case of storing all the measurement data. Thus, the amount of sensor measurement data stored in the database 70 can be reduced. Also in the third embodiment, as in the first embodiment, the measurement data is selected so that the measurement data is stored in the database 70 at a constant cycle for each storage duty period. The presence or absence of can also be determined based on the presence or absence of measurement values stored at this fixed period. In the third embodiment, instead of the change presence / absence information in the first embodiment, the previous difference value is stored in the management measurement data 271. If the number of digits of the previous difference value is small, the database 70 is stored. Can be reduced as compared with the first embodiment.

(Modification 1 of Embodiment 3)
Next, Modification 1 of Embodiment 3 will be described. In the first modification of the third embodiment, the measurement data selection process is performed so as to reduce the amount of sensor measurement data stored in the database 70 as compared with the third embodiment. FIG. 17 is a flowchart illustrating a processing procedure of measurement data selection processing to be stored in the first modification of the third embodiment.

Step S91 to step S94 shown in FIG. 17 correspond to step S61 to step S64 of FIG. When the data selection unit 250 determines that the acquired measurement value has not changed by a predetermined value or more from the previous measurement value (step S92: No), whether or not the measurement date and time of this measurement value is a predetermined storage reference time. Is determined (step S95). When the data selection unit 250 determines that the measurement date / time of the measurement value is not the predetermined storage reference time (step S95: No), the process of selecting and determining the measurement value ends.

  When the data selection unit 250 determines that the measurement date / time of the measurement value is a predetermined storage reference time (step S95: Yes), the value of the previous difference of the measurement data is set to “0” (step S96). The measurement data corresponding to the measurement value is selected as measurement data to be stored in the database 70 (step S94). Accordingly, when there is no change of a predetermined value or more from the previous measurement value, data other than measurement data at a fixed storage reference time is not stored in the database 70. For example, when the storage reference time is set to 0: 0, as illustrated in the table T13 of FIG. 18, measurement data that does not change more than a predetermined value from the previous measurement value in the data on January 2nd. Is stored in the database in a state in which the value of “0.0” is written in the previous difference only at 0:00:00 on January 2 of the storage reference time. Therefore, the table T3 in FIG. 18 is obtained by deleting the row R23 from the table T11 in FIG.

  Step S97 in FIG. 17 corresponds to step S68 in FIG. In the first modification of the third embodiment, the output data creation unit 280 creates output measurement data by performing each processing procedure shown in FIG.

  As described above, in the first modification of the third embodiment, when the measurement value does not change more than the predetermined value, the measurement value other than the predetermined storage reference time is not selected as the storage target. 3 can reduce the amount of sensor measurement data stored in the database 70. In the first modification of the third embodiment, the measurement data at the storage reference time is stored even when the measurement value does not change by a predetermined value or more. Also, the determination can be made based on the presence or absence of the measurement value stored at the storage reference time.

(Modification 2 of Embodiment 3)
Next, a second modification of the third embodiment will be described. FIG. 19 is a flowchart illustrating a processing procedure of output data creation processing according to the second modification of the third embodiment.

  Step S101 to step S105 shown in FIG. 19 correspond to step S71 to step S75 shown in FIG. When the output data creation unit 280 determines that there is no measurement data of the start date / time of the search target (step S104: No), the measurement data of the date / time closest to the search target date / time is selected from the management measurement data 271. It is extracted (step S106), and it is determined whether or not the extracted measurement data of the nearest date / time is measured before the date / time of search (step S107).

  When the output data creation unit 280 determines that the extracted measurement data of the nearest date / time is measured before the search date / time (step S107: Yes), the search in which no data is stored Since the measurement value of the target date and time corresponds to the measurement value that has not changed from the measurement value measured before that, the measurement value of the extracted measurement data of the closest date and time is used as the measurement value of the start date and time that is the acquisition target. Adopt (step S108).

  When the output data creation unit 280 determines that the extracted measurement data at the nearest date and time is not measured before the search target date and time (step S107: No), the extracted measurement data at the nearest date and time is Since the measurement data is later than the search target date and time and has the closest date and time, the previous difference value of the extracted measurement data is subtracted from the measurement value of the extracted measurement data (step In step S109, the calculated value is adopted as a measurement value for the date and time to be acquired (step S110). Step S111 to step S113 shown in FIG. 19 correspond to step S79 to step S81 shown in FIG.

  As described above, in the output data creation process according to the first modification of the third embodiment, when the measurement value of the date and time not stored in the management measurement data 271 is acquired, the measurement of the date and time closest to the search target date and time is obtained. When data is extracted and the extracted measurement data of the nearest date and time is measured before the search target date and time, the subtraction processing in step S77 from the processing of FIG. 15 is omitted.

(Embodiment 4)
Next, a fourth embodiment will be described. FIG. 20 is a block diagram of the configuration of the data management system according to the fourth embodiment.

  As shown in FIG. 20, the data management system 201A according to the fourth embodiment includes a data collection device 202A having a data selection unit 350, a data storage processing unit 60, a database 70, and an output data creation unit 280. The apparatus 203 </ b> A is connected via the network N.

  The data collection device 202A executes various programs and parameters to control processing operations of the data collection device 202A, the data collection unit 40, and measurement data to be stored in the database 70 of the data management device 203A. A data selection unit 350 to be selected, a memory 102A in which the data selection date and time by the data selection unit 350 is temporarily stored, and data to be transmitted to the data management device 203A via the network N by the measurement data selected by the data selection unit 350 And a transmission processing unit 112A. The data transmission processing unit 112A transmits data D2 in a format in which the measurement date and time, the sensor type, the measurement value, and the previous difference value are associated as the measurement data selected by the data selection unit 350.

  The data management device 203A receives the measurement data transmitted from the data collection device 202A via the input unit 10, the control unit 223A that executes various programs and parameters to control the processing operation of the data management device 203A, and the network N. A data reception processing unit 113A to receive, a data storage processing unit 60 to store measurement data received by the data reception processing unit 113A in the database 70, a database 70, an output data creation unit 280, and an output unit 90 are provided.

  Next, processing for selecting measurement data to be stored in the data selection unit 350 shown in FIG. 20 will be described. FIG. 21 is a flowchart illustrating a processing procedure of selection / transmission processing of measurement data to be stored in the data collection device 202A.

  Step S121 to step S123 shown in FIG. 21 correspond to step S61 to step S63 shown in FIG. Step S124 corresponds to step S54 shown in FIG. Step S125 and step S126 correspond to step S55 and step S56 shown in FIG. When the data selection unit 350 determines that the calculated difference is not equal to or greater than the predetermined transmission cycle (step S126: No), the measurement data ends the selection determination process. On the other hand, when the data selection unit 350 determines that the calculated difference is equal to or greater than the predetermined transmission cycle (step S126: Yes), the value of the previous difference of the measurement data is set to “0” (step S127). Step S128 and step S129 correspond to step S58 and step S59 shown in FIG. Note that the data selection unit 350 performs the processing of steps S124 and S128 of FIG. 21 after performing steps S91 to 93, S95, and S96 shown in FIG. 17, and selects measurement data to be transmitted to the data management device 203A. May be. Further, the output data creation unit 280 creates output measurement data by performing the processing procedure shown in FIG. 15 or FIG.

  Since the fourth embodiment transmits only a part of the measurement data as in the second embodiment, data transmission to the management device reduces concentration and suppresses the communication load to the management device. There is an additional effect that the load of the reception process can be reduced.

  An execution program for each process executed by the data management device, the data collection device, and the data management device according to the present embodiment is a file in an installable format or an executable format, and is a CD-ROM or flexible disk. (FD), CD-R, DVD (Digital Versatile Disk), etc. may be recorded and provided on a computer-readable recording medium and stored on a computer connected to a network such as the Internet. The program may be provided by being downloaded via a network. Further, it may be configured to be provided or distributed via a network such as the Internet.

1,201 Data management device 1A, 201A Data management system 2A, 202A Data collection device 3A, 203A Data management device 20, 22A, 23A, 220, 222A, 223A Control unit 30 Sensor group 31 First sensor 32 Second sensor 40 Data Collection unit 50, 150, 250, 350 Data selection unit 60 Data storage processing unit 70 Database 71, 271 Management measurement data 80, 280 Output data creation unit 90 Output unit 100, 102A Memory 112A Data transmission processing unit 113A Data reception processing unit 201A data management system 202A data collection device

Claims (11)

A data management device that manages the storage of measurement data of a sensor that performs measurement processing at a fixed period in a database,
In the first measurement value measured by the sensor, the absolute value of the difference between the first measurement value and the second measurement value measured one time before the first measurement value is greater than or equal to a predetermined value. In some cases, data selection means for selecting measurement data including the first measurement value and the measurement date and time of the first measurement value as measurement data to be stored in the database;
Data storage processing means for storing the measurement data selected as the measurement data to be stored by the data selection means in the database;
Input means for inputting data output instruction information for instructing the date and time when the measurement data of the sensor should be output;
When the data output instruction information is input by the input means, the measurement data corresponding to the date and time to be output is searched from the measurement data stored in the database, and the measurement data of the date and time to be output cannot be searched Output data creation means for creating the measurement data of the date and time to be output based on the measurement data measured at the date and time closest to the date and time of output from the measurement data of the database,
Storage means for storing a data selection date and time which is a date and time when the data selection means has selected measurement data to be stored in the database;
Equipped with a,
The data selection unit updates the data selection date and time stored in the storage unit to the latest date and time each time the measurement data to be stored is selected, and the first measurement value with respect to the second measurement value is updated. When the absolute value of the difference is greater than or equal to the predetermined value, the first measurement value changes with respect to the second measurement value in addition to the first measurement value and the measurement date and time of the first measurement value. Measurement data including change information indicating that there is a change is selected as the measurement data to be stored, and the absolute value of the difference between the first measurement value and the second measurement value is less than the predetermined value. In some cases, if the determination timing for determining the selection of the first measurement value exceeds a predetermined storage duty period from the data selection date and time stored in the storage means, the first measurement value and In addition to the measurement date and time of the first measurement value Data management apparatus characterized by first measured value to select the measurement data moistened with no change information indicating that no change to the second measurement as the measurement data to be the storage.   If the output data creation means cannot retrieve the measurement data of the date and time to be output, the closest date and time before the date and time of output from the measurement data stored in the database The data management apparatus according to claim 1, wherein a measurement value of the measurement data is extracted, and the measurement value of the extracted measurement data is adopted as the measurement value of the date and time to be output. The output data creation means extracts measurement data measured at the date and time closest to the date and time of output from the measurement data stored in the database when the measurement data of the date and time of output cannot be retrieved. In the case where the extracted measurement data includes the no-change information, the measurement value of the extracted measurement data is adopted as the measurement value of the date and time to be output, and the extracted measurement data includes the change information Is before the date to be output from the measurement data stored in the database, and is prior to the date and time to output the extracted measurement data of the nearest date and time, and The data management apparatus according to claim 1 , wherein the measurement value of the measurement data of the nearest date and time is adopted as the measurement value of the date and time of output. A data management device that manages the storage of measurement data of a sensor that performs measurement processing at a fixed period in a database,
In the first measurement value measured by the sensor, the absolute value of the difference between the first measurement value and the second measurement value measured one time before the first measurement value is greater than or equal to a predetermined value. In some cases, data selection means for selecting measurement data including the first measurement value and the measurement date and time of the first measurement value as measurement data to be stored in the database;
Data storage processing means for storing the measurement data selected as the measurement data to be stored by the data selection means in the database;
Input means for inputting data output instruction information for instructing the date and time when the measurement data of the sensor should be output;
When the data output instruction information is input by the input means, the measurement data corresponding to the date and time to be output is searched from the measurement data stored in the database, and the measurement data of the date and time to be output cannot be searched Output data creation means for creating the measurement data of the date and time to be output based on the measurement data measured at the date and time closest to the date and time of output from the measurement data of the database,
Storage means for storing a data selection date and time that is a date and time when the data selection means has selected measurement data;
Equipped with a,
When the absolute value of the difference between the first measurement value and the second measurement value is greater than or equal to the predetermined value, the data selection unit may determine the first measurement value and the first measurement value. The measurement data including the previous difference value, which is a difference value obtained by subtracting the second measurement value from the first measurement value together with the measurement date and time, is selected as measurement data to be stored in the database,
The data selection means further updates the data selection date and time stored in the storage means to the latest date and time each time the measurement data to be stored is selected, and the second measurement of the first measurement value. When the absolute value of the difference with respect to the value is less than the predetermined value, and the selection date and time for the first measurement value exceeds a predetermined storage duty period from the data selection date and time stored in the storage means Selects, as the measurement data to be stored, the measurement data in which the previous difference value is 0 in addition to the first measurement value and the measurement date and time of the first measurement value,
When the output data creation means cannot find the measurement data of the date and time to be output, the output data creation means has a measurement value of the measurement data measured at the date and time closest to the date and time of output and the previous difference value of the measurement data. A data management apparatus for generating measurement data of the date and time to be output to the user . When the output data creation means cannot retrieve the measurement data of the date and time to be output, the closest date and time is later than the date and time of output from the measurement data stored in the database A value obtained by subtracting the previous difference value of the measurement data from the measurement value of the measurement data measured at the nearest date and time that is after the extracted date and time to be output. The data management apparatus according to claim 4 , wherein the data management device employs the measured value of the date and time to be output. The output data creation means extracts the measurement data closest to the date and time to be output from the measurement data stored in the database when the measurement data of the date and time to be output cannot be retrieved, and the extracted measurement When the measurement date of data is before the output date, the measurement value of the extracted measurement data is adopted as the measurement value of the output date, and the measurement date of the extracted measurement data is output. claims in some cases later than date and characterized by using a value obtained by subtracting the previous difference value of the measured data the extracted from the measured values of the measurement data the extracted as a measurement value of the date and time to the output 4 The data management device described in 1. The data and the selection means and the data storage processing unit, the data management apparatus according to any one of claims 1-6, characterized in that it is connected via a network. A data management method performed by a data management device that manages measurement data of a sensor that performs measurement processing at a constant cycle,
In the first measurement value measured by the sensor, the absolute value of the difference between the first measurement value and the second measurement value measured one time before the first measurement value is greater than or equal to a predetermined value. in some cases, the data selection step of selecting as said first measurement value and the measurement data to be stored in the database of the measurement data including the measurement date and time of the first measurement value,
A data storage processing step of storing in the database the measurement data selected as the measurement data to be stored in the data selection step;
When data output instruction information indicating the date and time when the measurement data of the sensor should be output is input, the measurement data corresponding to the date and time to be output is retrieved from the measurement data stored in the database, and the date and time when the data is output If the measurement data cannot be retrieved, the output data that creates the measurement data of the date and time to be output based on the measurement data measured at the date and time closest to the date and time of output from the measurement data of the database Creation steps,
A storage step of storing a data selection date and time that is a date and time when the measurement data to be stored in the database is selected in the data selection step;
Only including,
In the data selection step, each time the measurement data to be stored is selected, the data selection date and time stored in the storage step is updated to the latest date and time, and the first measurement value with respect to the second measurement value is updated. When the absolute value of the difference is greater than or equal to the predetermined value, the first measurement value changes with respect to the second measurement value in addition to the first measurement value and the measurement date and time of the first measurement value. Measurement data including change information indicating that there is a change is selected as the measurement data to be stored, and the absolute value of the difference between the first measurement value and the second measurement value is less than the predetermined value. In some cases, when the determination timing for determining the selection of the first measurement value exceeds a predetermined storage duty period from the data selection date and time stored in the storage step, the first measurement value and The first measured value And characterized in that the measured values of the first addition to the date and time to select the measurement data moistened with no change information indicating that no change to the second measurement as the measurement data to be the storage Data management method. A data management method performed by a data management device that manages measurement data of a sensor that performs measurement processing at a constant cycle,
In the first measurement value measured by the sensor, the absolute value of the difference between the first measurement value and the second measurement value measured one time before the first measurement value is greater than or equal to a predetermined value. in some cases, the data selection step of selecting as said first measurement value and the measurement data to be stored in the database of the measurement data including the measurement date and time of the first measurement value,
A data storage processing step of storing in the database the measurement data selected as the measurement data to be stored in the data selection step;
When data output instruction information indicating the date and time when the measurement data of the sensor should be output is input, the measurement data corresponding to the date and time to be output is retrieved from the measurement data stored in the database, and the date and time when the data is output If the measurement data cannot be retrieved, the output data that creates the measurement data of the date and time to be output based on the measurement data measured at the date and time closest to the date and time of output from the measurement data of the database Creation steps,
A storage step of storing a data selection date and time that is a date and time when measurement data is selected in the data selection step;
Only including,
In the data selection step, when the absolute value of the difference between the first measurement value and the second measurement value is greater than or equal to the predetermined value, the first measurement value and the first measurement value The measurement data including the previous difference value, which is a difference value obtained by subtracting the second measurement value from the first measurement value together with the measurement date and time, is selected as measurement data to be stored in the database,
In the data selection step, the data selection date and time stored in the storage step is updated to the latest date and time each time the measurement data to be stored is selected, and the second measurement of the first measurement value is performed. When the absolute value of the difference with respect to the value is less than the predetermined value, and the selection date and time for the first measurement value exceeds the predetermined storage duty period from the data selection date and time stored in the storage step Selects, as the measurement data to be stored, the measurement data in which the previous difference value is 0 in addition to the first measurement value and the measurement date and time of the first measurement value,
In the output data creation step, when the measurement data of the date and time to be output cannot be searched, the measurement value of the measurement data measured at the date and time closest to the date and time of output and the previous difference value of the measurement data are included. A data management method characterized in that measurement data of the date and time to be output is created . In the data management device that manages the measurement data of the sensor that performs measurement processing at a fixed period
In the first measurement value measured by the sensor, the absolute value of the difference between the first measurement value and the second measurement value measured one time before the first measurement value is greater than or equal to a predetermined value. in some cases, the data selection procedure for selecting as the measurement data to be stored measurement data in the database including a measurement date and time of the first measurement and the first measurement value,
A data storage processing procedure for storing the measurement data selected as the measurement data to be stored in the data selection procedure in the database;
When data output instruction information indicating the date and time when the measurement data of the sensor should be output is input, the measurement data corresponding to the date and time to be output is retrieved from the measurement data stored in the database, and the date and time when the data is output If the measurement data cannot be retrieved, the output data that creates the measurement data of the date and time to be output based on the measurement data measured at the date and time closest to the date and time of output from the measurement data of the database Creation procedure and
A storage procedure for storing a data selection date and time, which is a date and time when measurement data to be stored in the database is selected in the data selection procedure;
Was executed,
In the data selection procedure, each time the measurement data to be stored is selected, the data selection date and time stored in the storage procedure is updated to the latest date and time, and the first measurement value with respect to the second measurement value is updated. When the absolute value of the difference is greater than or equal to the predetermined value, the first measurement value changes with respect to the second measurement value in addition to the first measurement value and the measurement date and time of the first measurement value. Measurement data including change information indicating that there is a change is selected as the measurement data to be stored, and the absolute value of the difference between the first measurement value and the second measurement value is less than the predetermined value. In some cases, when the determination timing for determining the selection of the first measurement value exceeds a predetermined storage duty period from the data selection date and time stored in the storage procedure, the first measurement value and In addition to the measurement date and time of the first measurement value Data management, wherein you to select the measurement data measured values of the first is impregnated with no change information indicating that there was no change with respect to the second measurement as the measurement data to be the storage Program. In the data management device that manages the measurement data of the sensor that performs measurement processing at a fixed period
In the first measurement value measured by the sensor, the absolute value of the difference between the first measurement value and the second measurement value measured one time before the first measurement value is greater than or equal to a predetermined value. in some cases, the data selection procedure for selecting as the measurement data to be stored measurement data in the database including a measurement date and time of the first measurement and the first measurement value,
A data storage processing procedure for storing the measurement data selected as the measurement data to be stored in the data selection procedure in the database;
When data output instruction information indicating the date and time when the measurement data of the sensor should be output is input, the measurement data corresponding to the date and time to be output is retrieved from the measurement data stored in the database, and the date and time when the data is output If the measurement data cannot be retrieved, the output data that creates the measurement data of the date and time to be output based on the measurement data measured at the date and time closest to the date and time of output from the measurement data of the database Creation procedure and
A storage procedure for storing a data selection date and time that is a date and time when measurement data was selected in the data selection procedure;
Was executed,
In the data selection procedure, when the absolute value of the difference between the first measurement value and the second measurement value is greater than or equal to the predetermined value, the first measurement value and the first measurement value The measurement data including the previous difference value, which is a difference value obtained by subtracting the second measurement value from the first measurement value together with the measurement date and time, is selected as measurement data to be stored in the database,
In the data selection procedure, every time the measurement data to be stored is selected, the data selection date and time stored in the storage procedure is updated to the latest date and time, and the second measurement of the first measurement value is performed. When the absolute value of the difference with respect to the value is less than the predetermined value, and the selection date and time for the first measurement value exceeds the predetermined storage duty period from the data selection date and time stored in the storage procedure Selects, as the measurement data to be stored, the measurement data in which the previous difference value is 0 in addition to the first measurement value and the measurement date and time of the first measurement value,
In the output data creation procedure, when the measurement data of the date and time to be output cannot be searched, the measurement value of the measurement data measured at the date and time closest to the date and time of output and the previous difference value of the measurement data are included. preparative the program data management characterized that you create a measurement data of date and time to be the output.

Images