JP6192455B2 - Log data collection device, log data management method, and program - Google Patents

Description

  The present invention relates to a log data collection device, a log data management method, and a program.

  In a system that manages equipment such as an air conditioner for use in monitoring abnormal conditions and energy saving measures, log data relating to setting values and operating states of the equipment is collected. Here, since the log data is data that is continuously stored in time series, there is a problem that the storage area of the log data will become tight in the future.

  In order to cope with this problem, Patent Document 1 discloses a log data collection for thinning out data so that characteristics due to changes in time series are not lost as much as possible when a storage area for storing time series data is tight. The device is described.

  Further, Patent Document 2 describes a log collection system that moves log data to another storage device when the connection with a log collection target device is disconnected.

Japanese Patent Laid-Open No. 06-282465 JP 2011-170701 A

  In the log data collection device described in Patent Document 1, the number of data to be thinned out increases as the amount of data to be stored increases, and there is a possibility that the characteristics and tendency of the entire data may be lost. Moreover, in the system described in Patent Document 2, only log data is moved to another storage device, the amount of data to be stored does not change, and the storage of the log data storage area is fundamentally solved. I can't.

  The present invention has been made in view of the above circumstances, and a log data collection device, a log data management method, and a program that can prevent storage space tightness while maintaining the properties and trends of the entire data. The purpose is to provide.

In order to achieve the above object, the log collection device of the present invention provides:
Log data acquisition means for acquiring log data;
Log data storage means for storing log data acquired by the log data acquisition means;
Statistic calculation means for calculating a statistic of log data stored in the log data storage means;
Statistical data storage means for storing statistical data indicating the statistics calculated by the statistics calculation means;
Log data deleting means for deleting the log data for which the statistics have been calculated by the statistics calculating means from the log data storage means;
Based on the statistical data stored in the statistical data storage means, non-standard data specification for specifying non-standard data having a different tendency from other log data among the log data stored in the log data storage means Means,
Non-standard data storage means for storing log data for a period corresponding to the specified condition, including non-standard data specified by the non-standard data specifying means, in a region different from the log data storage means;
Ru equipped with.

  According to the present invention, statistical data indicating the tendency of the entire log data is stored, and the log data for which the statistical amount is calculated is deleted. Accordingly, it is possible to prevent the storage area from being constrained while maintaining the properties and trends of the entire data.

It is a block diagram which shows the function structure of the log data collection apparatus which concerns on Embodiment 1 of this invention. It is a figure which shows the example of the log data stored in the log data storage part. It is a figure which shows the example of the statistical data stored in the statistical data storage part. It is a figure which shows the example of the log data stored in the nonstandard data storage part. 3 is a flowchart illustrating a daily processing procedure according to the first embodiment. 5 is a flowchart illustrating a procedure of statistical data update processing according to the first embodiment. 3 is a flowchart illustrating a procedure of non-standard data storage processing according to the first embodiment. It is a block diagram which shows the function structure of the log data collection apparatus which concerns on Embodiment 2 of this invention. It is a figure which shows the example of the maintenance information stored in the maintenance information storage part. It is a figure which shows the example of an information display screen. It is a figure which shows the example of an information display screen.

  Hereinafter, embodiments of the present invention will be described in detail with reference to the drawings. In the drawings, the same or corresponding parts are denoted by the same reference numerals.

Embodiment 1
A log data collection device 1 according to Embodiment 1 of the present invention will be described with reference to FIG. The log data collection device 1 is a computer such as a server or an air conditioning controller that collects log data from the air conditioner 2 and stores and manages it. The air conditioner 2 includes a sensor for measuring the surrounding environment and the like, acquires setting information for the own unit, information about the control content, and information about the surrounding environment, and transmits to the log data collection device 1 as needed as log data.

  Functionally, the log data collection device 1 includes a log data acquisition unit 11, a nonstandard data identification unit 12, a statistical data creation unit 13, and a log data deletion unit 14. Further, the log data collection device 1 includes a log data storage unit 15, a statistical data storage unit 16, and a non-standard data storage unit 17 as data storage areas.

  The log data acquisition unit 11 acquires log data from the air conditioner 2. Then, the log data acquisition unit 11 stores the acquired log data in the log data storage unit 15 in addition to the already stored log data.

  Here, the log data stored in the log data storage unit 15 will be described with a specific example. In the present embodiment, there are three types of log data: observation history data, control history data, and operation history data. As shown in FIGS. 2A to 2C, the log data storage unit 15 stores log data by type.

  The observation history data is log data in which setting information of the air conditioner 2 and surrounding environment information are recorded. Specifically, as shown in FIG. 2A, the observation history data includes items of date, time, outside temperature, set temperature, indoor temperature, power consumption, evaporation temperature, and COP (Coefficient Of Performance). Consists of The air conditioner 2 creates observation history data and transmits it to the log data collection device 1 every 30 minutes. The log data acquisition unit 11 additionally records the received observation history data in the log data storage unit 15.

  The control history data is log data in which the contents of automatic control such as thermo-off and thermo-on executed by the air conditioner 2 are recorded. As shown in FIG. 2B, the control history data includes items such as date, time, and control content. When executing the automatic control, the air conditioner 2 creates control history data indicating the contents of the automatic control and transmits the control history data to the log data collection device 1. The log data acquisition unit 11 additionally records the received control history data in the log data storage unit 15.

  The operation history data is log data in which details of operations performed on the air conditioner 2 via a remote controller or the like are recorded. As shown in FIG. 2C, the operation history data includes items such as date, time, and operation content. When the air conditioner 2 is operated, the air conditioner 2 creates operation history data indicating the operation content and transmits the operation history data to the log data collection device 1. The log data acquisition unit 11 additionally records the received operation history data in the log data storage unit 15.

  Returning to FIG. 1, the statistical data creating unit 13 calculates a statistic (average, standard deviation) that quantitatively represents the tendency of the entire log data for each month from the log data stored in the log data storage unit 15. The statistical data indicating the calculated statistical amount is stored in the statistical data storage unit 16.

  Here, the statistical data stored in the statistical data storage unit 16 will be specifically described. In the present embodiment, as shown in FIGS. 3A to 3C, statistical data for each month is stored in the statistical data storage unit 16 for each log data of observation history data, control history data, and operation history data. Is remembered.

  For example, FIG. 3A is a diagram showing statistical data of observation history data stored in the statistical data storage unit 16. The statistical data storage unit 16 stores an average of each item (outside temperature, set temperature, room temperature, power consumption, evaporation temperature, COP) of the observation history data acquired for each month time zone. And the standard deviation are stored.

  FIG. 3B is a diagram showing statistical data of control history data stored in the statistical data storage unit 16. The statistical data storage unit 16 stores the average and standard deviation of the time (operating duration) from when the air conditioner 2 is thermo-ON to when it is thermo-OFF, and the air conditioner 2 is thermo-ON per hour. Alternatively, the average and standard deviation of the number of times of thermo OFF (thermo ON / OFF count) are stored.

  FIG. 3C is a diagram showing statistical data of operation history data stored in the statistical data storage unit 16. The statistical data storage unit 16 stores an average and standard deviation of the number of operations per hour performed by the air conditioner 2 every month.

  Returning to FIG. 1, the non-standard data specifying unit 12 selects other log data from the log data stored in the log data storage unit 15 based on the statistical data stored in the statistical data storage unit 16. Identify non-standard data with different trends. Then, the nonstandard data specifying unit 12 stores the log data including the specified nonstandard data in the nonstandard data storage unit 17.

  Here, examples of log data (observation history data, control history data, operation history data) stored in the non-standard data storage unit 17 are shown in FIGS. FIG. 4A shows the observation history data stored in the nonstandard data storage unit 17. FIG. 4B is a diagram showing control history data stored in the non-standard data storage unit 17. FIG. 4C is a diagram showing operation history data stored in the non-standard data storage unit 17.

  Among the values of each item of observation history data stored in the non-standard data storage unit 17, a non-standard value whose tendency is different from the values of other observation history data is an identifier for distinguishing from other values. Is attached. For example, as shown in FIG. 4A, the power consumption value of the observation history data at 12:30 on August 1, 2013 stored in the non-standard data storage unit 17 is a non-standard value. ★ mark indicating that.

  Returning to FIG. 1, the log data deletion unit 14 deletes log data that matches a predetermined condition from the log data storage unit 15 at the timing when the month changes. In the present embodiment, the log data deleting unit stores, from the log data storage unit 15, log data for which statistical data has been generated by the statistical data generating unit 13 and for which a predetermined period (for example, one year or more) has elapsed. delete.

(Daily processing)
Subsequently, an operation of daily processing performed every day in the log data collection device 1 will be described. The log data collection device 1 executes the daily processing shown in FIG. 5 at the timing when the date is changed by batch processing or the like.

  First, the statistical data creating unit 13 calculates the statistical amount from the current month's log data stored in the log data storage unit 15 to create statistical data, and executes statistical data update processing for updating the statistical data storage unit 16 (Step S10).

  Subsequently, the non-standard data specifying unit 12 refers to the statistical data of the newest month stored in the statistical data storage unit 16, specifies the non-standard data from the log data for the previous day, and specifies the specified non-standard data A non-standard data storage process for storing log data for a predetermined period including “in” in the non-standard data storage unit 17 is executed (step S20). This completes the daily process.

(Statistical data update processing)
Next, details of the above-described statistical data update process (step S10) will be described with reference to the flowchart of FIG.

  First, the statistical data creation unit 13 acquires log data (observation history data, control history data, operation history data) of the newest month from the log data storage unit 15 (step S11).

  Subsequently, the statistical data creation unit 13 calculates the average and standard deviation of each item (outside temperature, set temperature, room temperature, power consumption, evaporation temperature, COP) of the observation history data acquired in Step S11 (Step S11). S12).

  Subsequently, based on the control history indicated by the control history data acquired in step S11, the statistical data creation unit 13 calculates the operation duration and the average and standard deviation of the thermo ON / OFF count per hour ( Step S13).

  Subsequently, the statistical data creation unit 13 calculates the average and standard deviation of the number of operations per hour based on the operation history indicated by the operation history data acquired in step S11 (step S14).

  Subsequently, the statistical data creation unit 13 creates statistical data indicating the statistical amount (average, standard deviation) corresponding to each log data calculated in steps S <b> 12 to S <b> 14, and is stored in the statistical data storage unit 16. The statistical data of the newest month is updated (step S15). When the statistical data update process is performed at the timing when the month is switched, the statistical data creation unit 13 newly registers the statistical data of the switched month in the statistical data storage unit 16 instead of updating the statistical data. . Thus, the statistical data update process ends.

(Non-standard data storage processing)
Next, details of the above-described non-standard data storage process (step S20) will be described with reference to the flowchart of FIG.

  First, the nonstandard data specifying unit 12 acquires log data for the previous day from the log data storage unit 15 (step S21).

  Subsequently, the non-standard data specifying unit 12 acquires the statistical data of the newest month from the monthly statistical data stored in the statistical data storage unit 16 (step S22). The non-standard data specifying unit 12 may acquire statistical data for the same month in the previous year instead of the statistical data for the newest month.

  Subsequently, the non-standard data specifying unit 12 specifies the non-standard data from the log data for the previous day acquired in Step S21 with reference to the statistical data acquired in Step S22 (Step S23).

  When the non-standard data cannot be specified in step S23 (step S24; No), there is no previous day log data to be stored in the non-standard data storage unit 17, and the non-standard data storage process is terminated. On the other hand, when the non-standard data can be specified in step S23 (step S24; Yes), the non-standard data specifying unit 12 includes the non-standard data and corresponds to the period determined according to the condition determined to be the non-standard data. Log data is acquired (copied) from the log data storage unit 15 and stored in the non-standard data storage unit 17 (step S25). This is the end of the non-standard data storage process.

Here, the process of specifying and storing non-standard data (step S23 to step S25) when the type of log data is observation history data will be described more specifically. In this case, the non-standard data specifying unit 12 includes observation history data in which the outside air temperature, power consumption, COP, and evaporation temperature satisfy any of the following conditions a to d among the observation history data for the previous day acquired in step S21. Are specified as non-standard data. In addition, what is necessary is just to acquire from the statistical data of the newest month of the time slot | zone corresponding to the acquisition time of the observation history data made into discrimination | determination.
Condition a: When the outside air temperature is (average value + 2 × standard deviation) or more during cooling operation or when the outside air temperature is (average value−2 × standard deviation) or less during heating operation (when the outside air temperature is a non-standard value) ).
Condition b: When power consumption is (average value + 2 × standard deviation) or more (when power consumption is a non-standard value).
Condition c: When COP is (average value−2 × standard deviation) or less (when COP is a non-standard value).
Condition d: When the evaporation temperature is (average value + 2 × standard deviation) or more or (average value−2 × standard deviation) or less (when the evaporation temperature is a non-standard value).

  When the observation history data that is non-standard data can be specified, the non-standard data specifying unit 12 includes the specified non-standard data, and log data for a period corresponding to the specified condition is stored in the non-standard data storage unit. 17. Specifically, the non-standard data specifying unit 12 immediately before the log data or non-standard data for one day on the day when the non-standard data is acquired is acquired according to the condition specifying the non-standard data. Log data and the like for several hours are stored in the non-standard data storage unit 17.

  For example, when the outside temperature or the power consumption is specified as non-standard data due to the non-standard value, the non-standard data specifying unit 12 sets all the observation history data for one day acquired in step S21 as non-standard. The data is stored in the data storage unit 17. The non-standard data specifying unit 12 may further change the range of the observation history data stored in the non-standard data storage unit 17 according to the value of the non-standard value of the specified non-standard data. For example, the non-standard data specifying unit 12 may store the observation history data for the most recent two days in the non-standard data storage unit 17 when the power consumption value is equal to or greater than (average value + 3 × standard deviation). .

  Further, for example, when the COP is specified as non-standard data due to the non-standard value, the non-standard data specifying unit 12 determines that the COP is an average among the observation history data acquired before the non-standard data. The observation history data acquired from the time of acquisition of the latest observation history data that is equal to or greater than the value to the time of acquisition of the non-standard data is stored in the non-standard data storage unit 17.

  Further, for example, when the evaporation temperature is specified as non-standard data because of the non-standard value, the non-standard data specifying unit 12 determines the evaporation temperature among the observation history data acquired before the non-standard data. The non-standard data storage unit 17 stores the observation history data acquired from the acquisition of the latest observation history data with the average value until the acquisition of the non-standard data.

Next, the process of specifying and storing non-standard data (step S23 to step S25) when the type of log data is control history data will be described more specifically. In this case, the non-standard data specifying unit 12 first calculates the operation continuation time of the previous day and the number of thermo ON / OFF times per hour from the control history data for the previous day acquired in step S21. In addition, when thermo-ON and thermo-OFF are repeated a plurality of times in the log data of the previous day, the operation continuation time is calculated by the number of repetitions. Then, the non-standard data specifying unit 12 converts all the control history data for the previous day into non-standard data when the calculated operation continuation time of the previous day and the thermo ON / OFF count satisfy one of the following conditions e and f. Store in the storage unit 17.
Condition e: When at least one operation continuation time is (average value + 2 × standard deviation) or more or (average value−2 × standard deviation) or less (when the operation continuation time is a non-standard value).
Condition f: When the thermo ON / OFF count is (average value + 2 × standard deviation) or more or (average value−2 × standard deviation) or less (when the thermo ON / OFF count is a non-standard value) .

  As described above, according to the present embodiment, a statistic is calculated and stored from a plurality of log data, and the log data used for calculating the statistic is subsequently deleted. Therefore, it is possible to prevent the storage area from being constrained while maintaining the characteristics and tendency of the entire log data.

  Further, according to the present embodiment, log data having a different tendency from other log data is stored as non-standard data in another area and is not deleted. Therefore, the user can refer to the non-standard data later and use it for identifying the cause when the failure occurs.

  Further, according to the present embodiment, when storing non-standard data in another area, not only the non-standard data but also log data for a period corresponding to a condition specifying the non-standard data are also stored in another area. Stored. Therefore, the user can later confirm the transition of log data until the non-standard data is acquired.

<< Embodiment 2 >>
Next, the log data collection device 10 according to Embodiment 2 of the present invention will be described. As shown in FIG. 8, the log data collection device 10 includes a maintenance information storage unit 18, a data search unit 19, and a search result display unit 20 newly added to the log data collection device 1 according to the first embodiment. Have a configuration.

  The maintenance information storage unit 18 stores maintenance information related to maintenance work such as repair and inspection performed on the air conditioner 2. Specifically, as shown in FIG. 9, the maintenance information storage unit 18 associates, for each maintenance work, the date when the maintenance work was performed, the person in charge of the maintenance work, and the content of the maintenance work. Maintenance information is stored. The maintenance information stored in the maintenance information storage unit 18 is information input by a person in charge of the maintenance work or an administrator when the maintenance work is performed. Note that maintenance information may be acquired from an external database via the Internet or the like.

  When the user requests display of information related to the air conditioner 2, the data search unit 19 searches the storage units 15 to 18 in the data area to detect the requested information and related information.

  The search result display unit 20 creates screen data of an information display screen that displays information detected by the data search unit 19 and displays the screen data on a display device (not shown). Note that the search result display unit 20 may transmit screen data created to a monitoring PC (not shown) or the like via the Internet and display an information display screen on the monitoring PC.

  Here, processing by the data search unit 19 and the search result display unit 20 will be described with an example. For example, when the user operates an input device (not shown) to instruct the display of power consumption of the air conditioner 2 from August 1 to August 7, the data search unit 19 searches the log data storage unit 15. Thus, the power consumption value is acquired from the observation history data acquired from August 1 to August 7. In addition, the data search unit 19 searches the non-standard data storage unit 17 to identify a time zone in which the power consumption value is between the August 1st and August 7th. Further, the data search unit 19 searches the maintenance information storage unit 18 and acquires maintenance information indicating maintenance work performed in a time zone in which the specified power consumption is a non-standard value. And the search result display part 20 displays an information display screen as shown in FIG. 10 based on these information which the data search part 19 acquired. On this information display screen, the power consumption value acquired from the observation history data is displayed in a graph, and the time zone where the power consumption value is a non-standard value is highlighted with a bold line. The acquired maintenance information is displayed at the bottom of the screen.

  Further, for example, the data search unit 19 may detect a statistic such as an average value of power consumption from the statistical data storage unit 16, and the search result display unit 20 may display an information display screen as shown in FIG. .

  Thus, according to the present embodiment, necessary information can be acquired and displayed from collected log data, created statistical data, and specified non-standard data, which is useful for management of the air conditioner 2. It becomes possible to provide the user with various information. In addition, according to the present embodiment, maintenance information related to the time zone indicating the non-standard value can be displayed together, so that the user can analyze the cause of the non-standard value in more detail. It becomes.

≪Modifications and application examples≫
In addition, this invention is not limited to said each embodiment, Of course, the deformation | transformation and application in the part which do not deviate from the summary of this invention are possible.

  For example, in each of the embodiments described above, the log data collection devices 1 and 10 that collect the log data of the air conditioner 2 have been described. However, the present invention is not limited to the log data of the air conditioner 2 and collects all types of log data. It can be applied to a log collection device.

  Further, in each of the above embodiments, the statistical data update process and the non-standard data storage process are performed in the daily process, but the timing for performing these processes is arbitrary, monthly process or weekly process May be implemented. Further, at the timing when the log data acquisition unit 11 acquires the log data, the non-standard data specifying unit 12 determines whether or not the log data is non-standard data. It may be stored in the data storage unit 17.

  In each of the above embodiments, the statistical data creation unit 13 creates monthly statistical data and stores it in the statistical data storage unit 16. However, the statistical data for each hour, every day, every week, and every season (three months) is used. Data may be created and stored.

  Moreover, in each said embodiment, the average and the standard deviation were shown as a statistic which the statistical data preparation part 13 calculates. However, any index that can grasp the trend of the entire log data can be adopted as a statistic. For example, the statistical data creation unit 13 may calculate a median value, a mode value, a quartile, or the like as a statistic.

  Further, for example, the log data collection devices 1 and 10 according to the above embodiments may be used by being incorporated in an air conditioning controller.

  In addition, for example, by applying an operation program that defines the operation of the log data collection devices 1 and 10 according to the above embodiments to an existing personal computer, an information terminal device, or the like, the personal computer or the like can be applied to the above embodiments. It is also possible to function as such log data collection devices 1 and 10.

  Further, such a program distribution method is arbitrary. For example, a computer-readable medium such as a CD-ROM (Compact Disk Read-Only Memory), a DVD (Digital Versatile Disk), an MO (Magneto Optical Disk), or a memory card is readable. It may be distributed by storing in a recording medium, or distributed via a communication network such as the Internet.

  DESCRIPTION OF SYMBOLS 1,10 Log data collection apparatus, 11 Log data acquisition part, 12 Non-standard data specification part, 13 Statistical data creation part, 14 Log data deletion part, 15 Log data storage part, 16 Statistical data storage part, 17 Non-standard data storage Section, 18 maintenance information storage section, 19 data search section, 20 search result display section, 2 air conditioner

Claims (5)

Log data acquisition means for acquiring log data;
Log data storage means for storing log data acquired by the log data acquisition means;
Statistic calculation means for calculating a statistic of log data stored in the log data storage means;
Statistical data storage means for storing statistical data indicating the statistics calculated by the statistics calculation means;
Log data deleting means for deleting the log data for which the statistics have been calculated by the statistics calculating means from the log data storage means;
Based on the statistical data stored in the statistical data storage means, non-standard data specification for specifying non-standard data having a different tendency from other log data among the log data stored in the log data storage means Means,
Non-standard data storage means for storing log data for a period corresponding to the specified condition, including non-standard data specified by the non-standard data specifying means, in a region different from the log data storage means;
Carlo Gudeta collection device equipped with. Data search means for searching for at least one of the log data storage means, the statistical data storage means, and the non-standard data storage means to detect requested information;
Search result display means for displaying information detected by the data search means;
Log data collection apparatus according to 請 Motomeko 1 Ru equipped with.   The log data is log data collected from the device,
  Maintenance information storage means for storing maintenance information related to maintenance work performed on the device;
  The search result display means displays maintenance information corresponding to the time when the non-standard data was acquired when displaying the detected non-standard data.
  The log data collection device according to claim 2. A log data management method by a computer,
The computer calculates a statistic of log data stored in the log data storage means;
The computer stores statistical data indicating the calculated statistics,
Based on the stored statistical data, the computer identifies non-standard data having a different tendency from other log data among the log data stored in the log data storage means,
The computer stores log data for a period corresponding to the specified condition, including the specified non-standard data, in a different area from the log data storage means,
The computer deletes the log data for which the statistic is calculated from the log data storage means;
How to manage log data. Computer
Log data acquisition means for acquiring log data;
Log data storage means for storing log data acquired by the log data acquisition means;
Statistic calculation means for calculating the statistic of log data stored in the log data storage means;
Statistical data storage means for storing statistical data indicating the statistics calculated by the statistics calculation means;
Log data deletion means for deleting the log data for which the statistics are calculated by the statistics calculation means from the log data storage means;
Based on the statistical data stored in the statistical data storage means, non-standard data specification for specifying non-standard data having a different tendency from other log data among the log data stored in the log data storage means means,
Non-standard data storage means for storing log data for a period corresponding to the specified condition, including non-standard data specified by the non-standard data specifying means, in an area different from the log data storage means,
Program to function as.

Images