JP5086121B2 - ENVIRONMENTAL DATA MANAGEMENT DEVICE AND ENVIRONMENTAL DATA MANAGEMENT METHOD - Google Patents

Description

  The present invention relates to an environmental data management apparatus and an environmental data management method, and more particularly to an environmental data management apparatus and an environmental data management method for performing aggregation processing in a calculation target period on time-series environmental data collected in advance.

  The GLP (Good Laboratory Practice) system aims to ensure the reliability of various safety test results for chemical substances. The GLP Principles in the OECD (Organization for Economic Co-operation and Development) were established in 1981 and revised in 1997. (Act No. 117) introduced the GLP system in March 1984 and is consistent with the OECD GLP principles. The GLP system ensures "reliability of test results by confirming conformity to GLP standards for operation management, test equipment, test plan, internal audit system, reliability assurance system, test results, etc. for each test facility" Is.

In a pharmaceutical factory, for example, environmental management data (temperature, humidity, CO ₂ concentration, etc.) of a factory building is measured and accumulated at 1-minute intervals as test research data in a pharmaceutical system. These data are submitted after calculating the maximum / minimum / average from the measured values for a specified calculation period, for example, two years, based on the GLP system. Here, the data for two years is a huge number of data of 2 years × 365 days × 24 hours × 60 minutes = 1,051,200 data.

  Patent Document 1 discloses a form creation support apparatus that performs statistical data aggregation processing and outputs a form as a form, and that acquires, aggregates, and displays data in an arbitrary layout based on specified conditions. . The form creation support apparatus of Patent Document 1 is capable of flexible and quick setting and editing of layout items and function processing results corresponding to the layout items, and supports creation of forms with good readability.

In recent years, the capacity of storage devices such as hard disks has increased, and accordingly, the storage period and storage objects of environmental data and the like have also increased. Therefore, when calculating statistical data, it is necessary to obtain data of a period corresponding to a condition from time-series data based on an arbitrary designated period and calculate a desired result.
JP 2007-188187 A

  However, Patent Document 1 has a problem in that the processing cost for calculating from time-series data corresponding to an arbitrary designated calculation target period is high. This is because in Patent Document 1, a form having a layout corresponding to various conditions can be created, but the stored original data is only acquired as it is. Therefore, when the data acquisition amount increases, the calculation efficiency decreases.

  In the present invention, an environmental data management apparatus is provided to solve such problems, and can efficiently perform aggregation processing from time-series data corresponding to any specified calculation target period. And an environmental data management method.

  The environmental data management apparatus according to the first aspect of the present invention performs aggregation processing for environmental data, which is time-series data, for an aggregation target period. Referring to the environmental data storage unit for storing the environmental data, the unit total data storage unit for storing the unit total data obtained by totaling the environmental data in a predetermined period unit, and the environmental data storage unit. A unit total data generation unit that totals the environmental data and stores the data as unit total data in the unit total data storage unit; and a calculation unit that calculates total result data for the total period to be calculated, the calculation unit including the total The unit aggregation data is acquired from the unit aggregation data storage unit for a period corresponding to the predetermined period unit in the target period, and the environment data is acquired for a period not corresponding to the predetermined period unit in the aggregation target period. Data acquisition means for acquiring the environmental data from the storage unit, the unit aggregate data acquired by the data acquisition means, and the environmental data Having a data collecting unit for calculating the counting result data corresponding to the aggregation period by aggregating the data.

  As a result, in the arbitrarily specified calculation target period, it is possible to use pre-aggregated period data for a period corresponding to a predetermined period unit, which is acquired compared to acquiring all unaggregated environmental data. The number of data to be reduced can be reduced. As a result, the number of environmental data to be tabulated is reduced, and the tabulation process can be performed efficiently.

  Further, the predetermined period unit is a period having a plurality of hierarchical structures, the unit aggregate data generation unit performs aggregation in a period unit corresponding to the plurality of hierarchical structures, and the data acquisition means The designated period may be divided so as to include a large number of period units so as to be the corresponding period. Thereby, the number of period data items to be acquired can be reduced.

  Furthermore, the data acquisition means divides the calculation target period by a period unit of the upper hierarchy, and when the divided period is less than the period unit of the upper hierarchy, the data acquisition means sets the period to be divided by the period unit of the lower hierarchy. The environmental data in the corresponding time zone may be acquired for a period that is less than all the predetermined period units. Thereby, it is efficient to divide the specified period into predetermined period units.

  The data acquisition unit may further include an input reception unit that receives an input of a specified period that specifies the calculation target period and an exclusion period that is excluded from the calculation target period. When the designated period input from the input receiving unit is divided into a plurality of divided periods, the divided designated periods may be processed as the aggregation target period. Thereby, it is possible to perform the tabulation process except for a period not to be calculated.

  In addition, the data acquisition unit further includes an input receiving unit that receives an input of a specified period that specifies the calculation target period and a condition that is excluded from the calculation target period, and the data acquisition unit includes the input condition that is input from the input receiving unit. Accordingly, an exclusion period is determined, and when the designated period input from the input receiving unit is divided by the exclusion period, the divided designated periods may be processed as the aggregation target periods. Thereby, it is possible to perform aggregation processing under conditions related to a plurality of data types. In addition, it is possible to arbitrarily set conditions for the exclusion period.

  Preferably, the predetermined period unit is a day, month, and year unit, and the unit aggregate data is daily unit data, month unit data, and year unit data. Thereby, environmental data can be totaled at a reasonable interval.

  Furthermore, it is desirable that the unit total data generation unit is executed at the time of daily change, monthly change, and annual change. As a result, as soon as the latest environmental data can be tabulated in a predetermined period unit, the tabulation result data can be quickly created.

  Further, the data aggregation means may calculate a maximum value, a minimum value, and an average value corresponding to the calculation target period. Thereby, the total result calculated | required by GLP system can be calculated | required.

  The environmental data management method according to the second aspect of the present invention performs aggregation processing for the aggregation target period on environmental data that is time-series data. Aggregating the environmental data in a predetermined period unit, and storing the unit aggregate data generation step for storing as unit aggregate data, and acquiring the unit aggregate data for a period corresponding to the predetermined period unit in the aggregation target period, The environmental data is acquired for a period that does not correspond to the predetermined period unit within the total period, and the unit total data acquired by the data acquisition step and the environmental data are totaled. A data aggregation step of calculating aggregation result data corresponding to the aggregation target period.

  As a result, in the arbitrarily specified calculation target period, it is possible to use pre-aggregated period data for a period corresponding to a predetermined period unit, which is acquired compared to acquiring all unaggregated environmental data. The number of data to be reduced can be reduced. As a result, the number of environmental data to be tabulated is reduced, and the tabulation process can be performed efficiently.

  Further, the predetermined period unit is a period having a plurality of hierarchical structures, the unit aggregation data generation step performs aggregation in a period unit corresponding to the plurality of hierarchical structures, and the data acquisition step The calculation target period may be divided so as to include a large number of hierarchy period units to be the corresponding period. Thereby, the number of period data items to be acquired can be reduced.

  In addition, the data acquisition step divides the calculation target period in units of upper hierarchy periods, and if the divided period is less than the period unit of the upper hierarchy, the data acquisition step sets the period to be divided in the period units of the lower hierarchy. The environmental data in the corresponding time zone may be acquired for a period that is less than all the predetermined period units. Thereby, it is efficient to divide the specified period into predetermined period units.

  The data acquisition step further includes an input reception step for receiving an input of a specified period for designating the calculation target period and an exclusion period to be excluded from the calculation target period, and the data acquisition step is performed according to the exclusion period input from the input reception step. When the designated period input from the input receiving step is divided into a plurality of divided periods, the divided designated periods may be processed as aggregation target periods. Thereby, it is possible to perform the tabulation process except for a period not to be calculated.

  The data acquisition step further includes an input reception step for receiving an input of a specified period for specifying the calculation target period and a condition to be excluded from the calculation target period. Accordingly, an exclusion period is determined, and when the designated period input from the input receiving step is divided by the exclusion period, the divided designated periods may be processed as aggregation target periods. Thereby, it is possible to perform aggregation processing under conditions related to a plurality of data types. In addition, it is possible to arbitrarily set conditions for the exclusion period.

  Preferably, the predetermined period unit is a day, month, and year unit, and the unit aggregate data is daily unit data, month unit data, and year unit data. Thereby, environmental data can be totaled at a reasonable interval.

  Furthermore, it is preferable that the unit total data generation step is executed at the time of daily change, at the time of monthly change, and at the time of annual change. As a result, as soon as the latest environmental data can be tabulated in a predetermined period unit, the tabulation result data can be quickly created.

  The data aggregation step may calculate a maximum value, a minimum value, and an average value corresponding to the calculation target period. Thereby, the total result calculated | required by GLP system can be calculated | required.

  According to the present invention, it is possible to provide an environmental data management apparatus and an environmental data management method that can efficiently perform aggregation processing from time-series data corresponding to an arbitrary designated calculation target period.

  Hereinafter, specific embodiments to which the present invention is applied will be described in detail with reference to the drawings. In the drawings, the same elements are denoted by the same reference numerals, and redundant description is omitted as necessary for the sake of clarity.

Embodiment 1 of the Invention
FIG. 1 is a block diagram showing an example of the configuration of an environmental data management system 100 according to an embodiment of the present invention. The environmental data management system 100 includes an environmental data management device 1, environmental data collection devices 2 a and 2 b, and a communication line 3. The environmental data management device 1 and the environmental data collection devices 2 a and 2 b are connected via a communication line 3. The communication line 3 may be a communication network such as the Internet, a public network, a dedicated line, and a mobile communication network.

The environmental data collection devices 2a and 2b are devices that periodically measure, collect, and store environmental data of a factory building or an experimental building in a pharmaceutical factory or the like. Here, the environmental data is a time-series numerical value representing the environmental information of the factory building or the experimental building. Examples of the environmental data include temperature, humidity, CO ₂ concentration, room pressure, and quality data (heavy data). And so on. In addition, the environmental data collection devices 2a and 2b measure and collect a plurality of types of environmental data, for example, time-series data at a cycle of 1 minute, and associate the types of environmental data with the measured times, To remember. The number of the environmental data collection devices 2a and 2b is not limited to this, and may be about several hundreds, for example. Further, the environmental data collection period in the environmental data collection devices 2a and 2b is not limited to one minute.

  The environmental data management device 1 collects and stores environmental data that is time-series data in units of minutes from the environmental data collection devices 2a and 2b periodically, for example, once a day. And the environmental data management apparatus 1 totals the maximum value, the minimum value, the average value, and the number of data items from the environmental data in units of days, months, and years, and stores them as period data. In addition, when it is necessary to submit environmental data aggregation results during any specified calculation target period (specified period), input of any specified period of environmental data for any type is accepted, and the environment corresponding to the specified period Aggregate the data and output the aggregated result data to a screen, file, etc. At this time, the environmental data management device 1 divides the designated period into year, month, and day units, and acquires year, month, and day period data corresponding to the divided periods. The environment data management apparatus 1 acquires environmental data in minutes for a period that is less than a day unit, and performs aggregation processing in the specified period from the acquired period data and environmental data. In addition, the aggregation result data can be used to create a submitted document by processing the data into a table or a graph.

  FIG. 2 is a block diagram showing the configuration of the environmental data management apparatus 1 according to the first embodiment of the present invention. The environmental data management device 1 includes an environmental data collection unit 11, a daily unit totaling unit 12, a monthly unit totaling unit 13, a year unit totaling unit 14, an input receiving unit 15, a calculating unit 16, and an output unit 17. The environmental data storage unit 21, the daily unit total data storage unit 22, the monthly unit total data storage unit 23, and the year unit total data storage unit 24 are provided.

  The environmental data collection unit 11 collects the previous day of all types of environmental data from the environmental data collection devices 2a and 2b for each day, and stores the collected environmental data in the environmental data storage unit 21 in association with the time. .

  The environmental data storage unit 21 stores the environmental data in minutes collected by the environmental data collection unit 11.

  The daily counting unit 12 is activated after the processing of the environmental data collection unit 11 every day, that is, every day, and refers to the environmental data storage unit 21 to acquire environmental data for the previous day. The maximum value, the minimum value, the average value, and the number of data items are totaled and stored in the daily total data storage unit 22 as daily total data.

  The daily total data storage unit 22 stores the daily total data collected by the daily total unit 12.

  The monthly totaling unit 13 is started after the processing of the daily totaling unit 12 after 0:00 on the first day of each month, that is, after the processing of the daily totaling unit 12, and refers to the daily totaling data storage unit 22. Minute total daily data is acquired, the maximum value, the minimum value, the average value, and the number of data in January are totaled and stored in the monthly total data storage unit 23 as monthly total data.

  The monthly total data storage unit 23 stores the monthly total data totaled by the monthly total unit 13.

  The yearly totaling unit 14 is started after the process of the monthly totaling unit 13 after 0:00 on January 1 every year, and refers to the monthly totaling data storage unit 23. The yearly aggregate data for the previous year is acquired, the maximum value, the minimum value, the average value, and the number of data in the year are aggregated and stored in the monthly aggregate data storage unit 23 as monthly aggregate data.

  The year unit total data storage unit 24 stores the year unit total data totaled by the year unit total unit 14.

  The input accepting unit 15 accepts input of the start time and end time of the calculation target period by year, month, day, hour, and minute, and sends the start time and end time to the calculation unit 16.

  The calculation unit 16 acquires the start time and end time of the calculation target period from the input reception unit 15, and for the specified period that is the period from the start time to the end time, the specified period is expressed in units of years, months, and days. A period division process is performed to divide the period. In the period division process, the calculation unit 16 minimizes the number of units to be divided. In other words, the maximum number of units is included as much as possible. Specifically, first, the calculation unit 16 divides only a period of less than a year unit into months. Next, the calculation part 16 divides | segments into a day unit only about the period less than a month unit. Thereafter, the calculation unit 16 converts the yearly aggregated data, the monthly aggregated data, and the daily aggregated data corresponding to the divided yearly, monthly, and daily periods into the annually aggregated data storage unit 24, Obtained from the unit total data storage unit 23 and the daily unit total data storage unit 22. In addition, the calculation unit 16 acquires environmental data in a corresponding minute unit from the environmental data storage unit 21 only for a period less than a day unit.

  In addition, after the period division processing, the calculation unit 16 aggregates the maximum value, the minimum value, and the average value from the obtained yearly aggregated data, monthly aggregated data, daily aggregated data, and environmental data, and aggregated. A calculation process is performed in which the total result data that is the maximum value, the minimum value, and the average value is sent to the output unit 17.

  The output unit 17 acquires count result data from the calculation unit 16 and performs output processing such as screen display, print output, or file output.

  The environmental data storage unit 21, the daily total data storage unit 22, the monthly total data storage unit 23, and the year total data storage unit 24 are non-volatile storage devices such as a hard disk drive and a flash memory. I just need it.

  FIG. 3 is a flowchart showing the environmental data collection process and the period data totaling process according to the first embodiment of the present invention. In FIG. 3, the environmental data collection unit 11 performs environmental data collection processing, and the daily unit totaling unit 12, the monthly unit totaling unit 13, and the year unit totaling unit 14 perform period data totaling processing. FIG. 4 is an example of data used in Embodiment 1 of the present invention. In FIG. 4, the environmental data management device 1 collects environmental data in 1 minute units from 0:00 on January 1, 2000 to 23:59 on December 11, 2007. Indicates that it has already been counted. If the collection interval of the environmental data collection process according to the first embodiment of the present invention is other than 1 minute, environmental data corresponding to the collection interval is collected. Hereinafter, the environmental data collection process and the period data totaling process in FIG. 3 will be described with reference to FIG. 4 as appropriate.

  First, the environmental data collection unit 11 collects environmental data from the environmental data collection devices 2a and 2b (S111). Specifically, the environment data collection unit 11 starts at 00:00 every day, and the environment data collection devices 2a and 2b are connected to the previous day for all types of environment data via the communication line 3. get. In addition, the starting time and interval in the environmental data collection unit 11 are not limited to 0:00 every day. For example, the environmental data collection unit 11 may be activated every hour to acquire environmental data for the previous hour.

  Subsequently, the environmental data collection unit 11 associates the collected environmental data with the time and stores them in the environmental data storage unit 21 for each type of environmental data (S112). FIG. 4A shows an example of time-series environmental data in minutes used in the first embodiment of the present invention. The environment data collection unit 11 stores, for example, environment data as shown in FIG. In the first embodiment of the present invention, the type of environmental data is not limited to the example of FIG.

  Next, the daily unit 12 determines whether or not it is a daily change timing (S113). Here, the daily change timing is the activation timing of the daily counting unit 12, and specifically indicates that it is after the processing of the environment data collection unit 11 activated at 00:00 every day. Therefore, here, the daily counting unit 12 is determined as the daily change timing, and the process proceeds to step S114. When the environmental data collection unit 11 is activated every day other than 0:00, the daily timing indicates that the daily counting unit 12 has not been started on that day, and the daily counting unit 12 on that day. Is already activated, the daily unit 12 is not activated and the period data aggregation process is terminated.

  Subsequently, the daily totalization unit 12 calculates the maximum value, the minimum value, and the average value of the environmental data for the previous day, and stores them in the daily totalization data storage unit 22 together with the number of data. (S114). Specifically, the daily totaling unit 12 refers to the environmental data storage unit 21 and acquires environmental data for the previous day. Then, the daily unit totalization unit 12 selects the maximum value and the minimum value among the environmental data for the day. Moreover, the daily totalization part 12 totals the environmental data in the said 1st, divides by the number of data, and calculates an average value. The daily totaling unit 12 uses the calculated maximum value, minimum value, and average value as daily totaling data together with the number of data in the day, and associates it with the time of the day, and the daily total data storage unit 22 To store.

  FIG. 4B is an example of the daily total data used in the first embodiment of the present invention. For example, the daily tabulation unit 12 stores the daily tabulation results of the environmental data as shown in FIG. 4B for each day and type. In FIG. 4B, examples of data types other than temperature are omitted.

  Thereafter, the monthly totalization unit 13 determines whether or not it is a monthly change timing (S115). Here, the monthly change timing is the activation timing of the monthly counting unit 13, and specifically indicates that the processing date is one day after the processing of the daily counting unit 12. When it is determined that the processing date is one day, the process proceeds to step S116, and when it is determined that the processing date is not one day, the monthly totaling unit 13 does not start and ends the period data totaling process.

  Subsequently, the monthly unit totalization unit 13 calculates the maximum value, the minimum value, and the average value of the daily unit total data for the previous month, and stores them in the monthly unit data storage unit 23 together with the number of data items. (S116). Specifically, the monthly aggregation unit 13 refers to the daily aggregation data storage unit 22 and acquires daily aggregation data for the previous month. Then, the monthly unit totaling unit 13 selects the maximum value and the minimum value from the daily unit total data in January. Moreover, the monthly totalization part 13 totals the daily totalization data in the said January, and divides by the number of data items, and calculates an average value. The monthly totaling unit 13 sets the calculated maximum value, minimum value, and average value as the monthly totaling data together with the number of data in the January, and stores them in the monthly totaling data storage unit 23 in association with the January. To do.

  FIG.4 (c) is an example of the monthly total data used for Embodiment 1 of this invention. The monthly totaling unit 13 stores, for example, monthly totaling results of environmental data as shown in FIG. 4C for each month and type. In FIG. 4C, examples of data types other than temperature are omitted.

  Then, the year unit totaling part 14 determines whether it is an annual change timing (S117). Here, the yearly change timing is the activation timing of the yearly totaling unit 14, and specifically indicates that the processing date is January 1 after the processing of the monthly unit totaling unit 13 ends. If it is determined that the processing date is January 1, the process proceeds to step S118. If it is determined that the processing date is not one day, the yearly totaling unit 14 does not start and ends the period data totaling process.

  Subsequently, the annual unit totaling unit 14 calculates the maximum value, the minimum value, and the average value of the monthly unit total data for the previous year, and stores them in the annual unit total data storage unit 24 together with the number of data. (S118). Specifically, the annual unit totaling unit 14 refers to the monthly unit totaling data storage unit 23 and acquires the monthly unit totaling data for the previous year. Then, the year unit totaling unit 14 selects the maximum value and the minimum value from the monthly unit total data in the year. Moreover, the annual unit totalization part 14 totals the monthly unit total data in the said 1 year, and divides by the number of data items, and calculates an average value. The annual unit totaling unit 14 sets the calculated maximum value, minimum value, and average value as the annual unit totaling data together with the number of data in the year, and stores it in the annual unit totaling data storage unit 24 in association with the year. To do.

  FIG. 4D is an example of yearly aggregated data used in Embodiment 1 of the present invention. The annual unit totaling unit 14 stores, for example, annual unit totaling results of environmental data as shown in FIG. 4D for each year and type. In FIG. 4D, examples of data types other than temperature are omitted.

  With the above, the period data totaling process ends. As a result, environmental data that is time-series data in minutes can be preliminarily aggregated in units of a predetermined period. Therefore, after that, by acquiring data that has been aggregated in units of years, months, and days for an arbitrary specified period, it is possible to efficiently perform aggregation processing in the specified period.

  FIG. 5 is a flowchart showing the period division processing according to the first exemplary embodiment of the present invention. FIG. 7 is a diagram conceptually illustrating an example of the period division processing according to the first exemplary embodiment of the present invention. In FIG. 7, in the state where the data of FIG. 4 is stored in the environmental data management apparatus 1, the designated period is a period from 0:00 on December 1, 2000 to 10:00 on February 10, 2003. An example of the period dividing process is shown. Hereinafter, the period division process in FIG. 5 will be described with reference to FIG. 7 as appropriate.

  First, the input receiving unit 15 receives an input for a specified period (S121). Specifically, as illustrated in FIG. 7, the input receiving unit 15 receives the start time Tstart (December 1, 2000, 00:00) and the end time of the calculation target period from the input interface of the environmental data management apparatus 1. Tend (February 10, 2003 10:00) is accepted. Then, the input reception unit 15 sends the start time Tstart and the end time Tend to the calculation unit 16. Here, the designated period P is a period determined by the start time Tstart and the end time Tend.

  Next, the calculation unit 16 determines whether or not the designated period P includes a yearly start time (S122). Specifically, the calculation unit 16 acquires the start time Tstart and the end time Tend, and the start time of January 1st, 00:00 on January 1, is between the start time Tstart and the end time Tend. Search how many are included. Here, as shown in FIG. 7, between the start time Tstart and the end time Tend, the time Ta (January 1, 2001 00:00) and the time Tb (January 1, 2002 00:00) ), The time Tc (January 1, 2003 00:00) is searched. For this reason, the calculation unit 16 determines that the specified period P includes a yearly start time, and proceeds to step S123. On the other hand, if it is determined that the designated period P does not include the yearly start time, the process proceeds to step S125.

  Then, the calculation unit 16 divides the designated period P into year units (S123). Specifically, the calculation unit 16 generates a new period by dividing the specified period P using the searched start time in units of years. Here, as shown in FIG. 7, the period PYstart, which is a period less than a year unit from the start time Tstart and the time Ta, and the period PY1, which is a year unit period from the time Ta and the time Tb, the time Tb and the time Tc, A period PY2 that is a period in units of years and a period PYend that is a period of less than years are generated from the time Tc and the end time Tend.

  Thereafter, the calculation unit 16 acquires yearly aggregate data corresponding to the divided yearly period (S124). Specifically, the calculation unit 16 refers to the yearly total data storage unit 24, acquires 2001 year total data corresponding to the period PY1, and also calculates the year 2002 total corresponding to the period PY2. Get the data.

  Subsequently, the calculation unit 16 determines whether or not there is a period of less than one year in the generated period (S125). Here, for the period PYstart and the period PYend, since the year-by-year total data has not been acquired, the calculation unit 16 determines that there is a period of less than one year, and proceeds to step S126. In addition, when it is determined that there is no period of less than one year, that is, the designated period P starts from the start time of the year (01:01 0:00) and ends the year (December 31, 23:59). ), Since the year-by-year aggregate data corresponding to all divided periods has been acquired, the period dividing process is terminated.

  Next, the calculation unit 16 determines whether or not the start time in units of months is included in the unacquired period (S126). Specifically, the calculation unit 16 searches the period PYstart and the period PYend to determine how many 00:00 of the day, which is the start time of the month. Here, as shown in FIG. 7, in the period PYstart, the start time Tstart (December 1, 2000 0: 0) and in the period PYend, the time Tc (January 1, 2003 00:00) , And time Td (February 1, 2003 00:00) are respectively retrieved. Therefore, the calculation unit 16 determines that the monthly start time is included for the period PYstart and the period PYend, and proceeds to step S127. On the other hand, if it is determined that the period PYstart and the period PYend do not include a monthly start time, the process proceeds to step S130.

  Then, the calculation unit 16 divides the period PYstart and the period PYend into monthly units (S127). Specifically, the calculation unit 16 generates a new period by dividing the period PYstart and the period PYend using the searched monthly start time. Here, as shown in FIG. 7, from the start time Tstart and time Ta, the period PMstart, which is a monthly period, from the time Tc and time Td, the period PMe1, which is a monthly period, from the time Td and the time Tend A period PMend, which is a period less than a monthly unit, is generated.

  Thereafter, the calculation unit 16 acquires monthly aggregate data corresponding to the divided monthly periods (S128). Specifically, the calculation unit 16 refers to the monthly total data storage unit 23, acquires the monthly total data for December 2000 corresponding to the period PMstart, and the January 2003 corresponding to the period PMe1. Get monthly aggregate data for.

  Subsequently, the calculation unit 16 determines whether or not there is a period of less than one month in the generated period (S129). Here, since the monthly total data has not been acquired for the period PMend, the calculation unit 16 determines that there is a period of less than one month, and proceeds to step S130. In addition, when it is determined that there is no period of less than one month, that is, both the period PYstart and the period PYend are both from the start time of the month (0:00 on the first day) to the end time of the month (23:59 on the last day of the month). In this case, since the monthly total data corresponding to all divided periods has been acquired, the period dividing process is terminated. As for the last day of the month, calendar data defining the year, month and day may be stored separately and referred to each time when determining at the end of the month.

  Next, the calculation unit 16 determines whether or not the start time in units of days is included in the unacquired period (S130). Specifically, the calculation unit 16 searches the period PMend to determine how many 0:00:00, which is the daily start time. Here, in the period PMend, February 1, 2003, 00:00, February 2, 2003, 00:00, ..., and February 10, 2003, 00:00 (not shown) ) Is searched. Therefore, the calculation unit 16 determines that the start time in units of days is included for the period PMend, and proceeds to step S131. If it is determined that the day start time is not included in the period PMend, the process proceeds to step S134.

  Then, the calculation unit 16 divides the period PMend into days (S131). Specifically, the calculation unit 16 generates a new period by dividing the period PMend using the searched daily start time. Here, as shown in FIG. 7, the daily period of February 1, 2003, February 2, 2003,..., February 9, 2003, and 0:00 on February 10, 2003 Minutes to a period PDend of less than a day unit of 9:59 on February 10, 2003 is generated.

  Thereafter, the calculation unit 16 acquires daily aggregate data corresponding to the divided daily periods (S132). Specifically, the calculation unit 16 refers to the daily total data storage unit 22 and acquires daily total data corresponding to each period from February 1 to 9, 2003.

  Subsequently, the calculation unit 16 determines whether or not there is a period of less than one day in the generated period (S133). Here, since the daily total data has not been acquired for the period PDend, the calculation unit 16 determines that there is a period of less than one day, and proceeds to step S134. If it is determined that there is no period of less than one day, that is, if the period PDend is from the start time of the day (0: 0) to the end time of the day (23:59), all the divisions Since the daily total data corresponding to the set period has been acquired, the period dividing process is terminated.

  Then, the calculation unit 16 divides the period PDend into units of minutes (S134). Specifically, the calculation unit 16 generates a new period by dividing the period PMend into minutes. Here, as shown in FIG. 7, period Pend1 (February 10, 2003 00:00), period Pend2 (February 10, 2003 0: 1),..., Period PendN (2003 2) A period in minutes of 9:59 on March 10 is generated.

  Thereafter, the calculation unit 16 acquires environmental data corresponding to the divided minute period (S135). Specifically, the calculation unit 16 refers to the environment data storage unit 21 and acquires environment data corresponding to the period Pend1, the period Pend2,.

  As a result, most of the period data in the specified period is acquired as a small number of period data using the period data aggregated in a predetermined period unit in advance, and environmental data in minutes is included in the predetermined period unit. By acquiring only the fractional period that cannot be obtained, environmental data can be efficiently acquired.

  In the above-described example of the period division process, the period PYstart and the period PMstart are the same monthly period, and thus may not be processed in step S127. That is, in step S128, the period PYstart may be processed instead of the period PMstart.

  FIG. 6 is a flowchart showing the calculation process according to the first embodiment of the present invention. After the period dividing process shown in FIG. 5 is completed in the calculation unit 16, the calculation process is started.

  First, the calculation unit 16 executes steps S141 to S143 in parallel. The calculation unit 16 calculates the maximum value from the data acquired in the period division process (S141). Specifically, the calculation unit 16 selects the maximum value from the acquired yearly aggregated data, monthly aggregated data, daily aggregated data, and environmental data. Then, the calculation unit 16 sends the selected maximum value to the output unit 17 as count result data.

  Further, the calculation unit 16 calculates a minimum value from the data acquired in the period division process (S142). Specifically, the calculation unit 16 selects a minimum value from the acquired yearly aggregated data, monthly aggregated data, daily aggregated data, and environmental data. Then, the calculation unit 16 sends the selected minimum value to the output unit 17 as count result data.

  Further, the calculation unit 16 calculates an average value from the data acquired in the period division process (S143). Specifically, the calculation unit 16 multiplies the acquired average annual data, monthly total data, daily total data, and environmental data by the average value and the number of data items in each period, and adds the results. Above, divide by the sum of all data counts. The calculation of the average value is not limited to this. Then, the calculation unit 16 sends the selected average value to the output unit 17 as count result data.

  Thereafter, the output unit 17 obtains the maximum value, the minimum value, and the average value, which are the aggregation result data in the designated period P, and performs output processing such as screen display, print output, or file output (S144).

  Note that steps S141 to S143 may be executed in series, and the order of execution in that case is not limited.

  As described above, according to the present embodiment, from the time series data corresponding to any specified calculation target period, the period data aggregated in advance in a predetermined period unit is acquired to the maximum, and all the minutes are obtained. It is not necessary to use environmental data for each unit, and it is possible to efficiently perform the aggregation process during the designated period.

Other Embodiments of the Invention
As a modification of the environmental data management apparatus 1 according to the first embodiment of the present invention, an exclusion period can be provided within an arbitrary designated period, and the tabulation process can be performed for the period excluding the exclusion period. For this purpose, for example, the input receiving unit 15 receives an input of a start time and an end time representing an exclusion period in addition to a specified period. And in the calculation part 16, before step S122 of FIG. 5, a period is divided | segmented so that an exclusion period may be excluded from a designated period. Thereafter, this can be realized by performing steps S122 to S135 of FIG. 5 for the divided period.

  Alternatively, as another modified example of the environmental data management device 1 according to the first exemplary embodiment of the present invention, a period in which the value of environmental data of a type different from the type of environmental data to be calculated satisfies a certain condition is set as an exclusion period. Also good. For example, when the type of environmental data to be calculated is “temperature”, the “humidity” may be equal to or greater than a certain value, and the “temperature” in a specified period may be aggregated. For this purpose, the input receiving unit 15 receives an input of environmental data type (for example, “humidity”) and a condition (a certain value or more) for defining an exclusion period in addition to the specified period. Then, the calculation unit 16 calculates a period during which the value of “humidity” in the designated period exceeds a certain value, that is, an exclusion period, before step S122 in FIG. At this time, the calculation unit 16 may refer to the environment data storage unit 21. Alternatively, the daily unit total data storage unit 22, the monthly unit total data storage unit 23, or the year unit total data storage unit 24 may be referred to depending on conditions. Thereafter, the calculation unit 16 divides the period so as to exclude the exclusion period calculated from the specified period. Thereafter, this can be realized by performing steps S122 to S135 of FIG. 5 for the divided period.

  According to the above-described modification, it is possible to perform aggregation processing in more complicated condition designation.

  In addition, although the total unit in the environmental data management apparatus 1 concerning Embodiment 1 of this invention was a day, a month, and a year unit, it is not limited to this. In other words, the aggregation unit may be a certain period unit. For example, it may be a week unit, a unit of time, a unit of 3 months, a unit of 6 hours, or the like. In addition, the total unit may be at least one of the above-described units.

  In the first embodiment of the present invention, the activation timings of the daily unit totaling unit 12, the monthly unit totaling unit 13, and the year unit totaling unit 14 are daily, monthly, and annual. However, the present invention is not limited to this. Not. The activation timings of the daily unit totaling unit 12, the monthly unit totaling unit 13, and the year unit totaling unit 14 may be distributed and executed in a time zone where the processing load of the environmental data management device 1 is low.

  In the daily unit totaling unit 12, the monthly unit totaling unit 13, and the year unit totaling unit 14, the average values may not be totaled. In that case, the daily unit totaling unit 12, the monthly unit totaling unit 13, and the year unit totaling unit 14 totalize and store the total values, and the calculation unit 16 calculates the average after totaling each total value and the number of data items. Find the value. Thereby, in the period data totaling process, the processing load corresponding to the calculation of the average value is reduced, so that the steady processing cost in the environmental data management apparatus 1 can be reduced.

  The monthly totaling unit 13 may acquire the corresponding January environmental data from the environmental data storage unit 21 and calculate the monthly totaling data. Similarly, the annual unit totaling unit 14 acquires the corresponding one year of environmental data from the environmental data storage unit 21 or acquires the corresponding one year of daily totaling data from the daily unit totaling data storage unit 22. The annual unit data may be calculated. However, as in the first embodiment of the present invention, the monthly totaling unit 13 is from the daily totaling data storage unit 22, and the annual unit totaling unit 14 is from the monthly unit totaling data storage unit 23. By acquiring this data, the aggregation process can be made more efficient.

  Further, the environmental data targeted in the first embodiment of the present invention is more effective in the environmental data in the GLP system. The environmental data in the GLP system needs to be quickly calculated and submitted for the environmental data for the calculation target period arbitrarily designated by the inspector during the inspection by the Ministry of Health, Labor and Welfare. However, regarding the period and conditions of environmental data to be submitted, due to the strictness of inspection, the type and period of environmental data required in advance cannot be known in advance, and pharmaceutical manufacturers, drugs, inspections It depends on the content. Furthermore, environmental data in the GLP system may be used as evidence in a trial, and the storage period of environmental data is long.

  The environmental data storage unit 21, the daily unit total data storage unit 22, the monthly unit total data storage unit 23, and the year unit total data storage unit 24 according to the embodiment of the present invention are non-volatile storage devices. It is not limited to. For example, a volatile storage device such as a DRAM (Dynamic Random Access Memory) may be used. In that case, when the content of the environment data storage unit 21 is corrected, it can be realized by performing recalculation.

  It is assumed that the environmental data stored in the environmental data storage unit 21 according to the embodiment of the present invention is not changed. This is because, for example, when the environmental data is pharmaceutical data in the GLP system, tampering is prohibited. However, some pharmaceutical manufacturers may allow modification of environmental data by satisfying certain conditions, for example, by leaving correction evidence. In that case, the daily totaling unit 12, the monthly unit totaling unit 13, and the annual unit totaling unit 14 total the data in the daily unit, the monthly unit, and the year unit, and the daily total data storage unit. The total data may be stored in the monthly total data storage unit 23, the total data storage unit 24, and the total data storage unit 24 per year.

  Furthermore, the present invention is not limited to the above-described embodiments, and various modifications can be made without departing from the gist of the present invention described above.

It is a block diagram which shows an example of a structure of the environmental data management system 100 concerning Embodiment 1 of this invention. It is a block diagram which shows the structure of the environmental data management apparatus 1 concerning Embodiment 1 of this invention. It is a flowchart figure which shows the environmental data collection process concerning Embodiment 1 of this invention, and a period data total process. It is an example of the data used for Embodiment 1 of this invention. (A) is an example of time-series environmental data. (B) is an example of daily total data. (C) is an example of monthly total data. (D) is an example of annual total data. It is a flowchart figure which shows the period division | segmentation process concerning Embodiment 1 of this invention. It is a flowchart figure which shows the calculation process concerning Embodiment 1 of this invention. It is a figure which shows notionally the example of the period division | segmentation process concerning Embodiment 1 of this invention.

Explanation of symbols

DESCRIPTION OF SYMBOLS 100 Environmental data management system 1 Environmental data management apparatus 2a, 2b Environmental data collection apparatus 3 Communication line 11 Environmental data collection part 12 Day unit total part 13 Month unit total part 14 Year unit total part 15 Input reception part 16 Calculation part 17 Output part 21 Environmental data storage unit 22 Daily unit total data storage unit 23 Month unit total data storage unit 24 Year unit total data storage unit P Pointed period PYstart period PYend period PY1 period PY2 period PMstart period PMend
Period PMe1 period PDend period Pend1 period Pend2 period PendN period Tstart start time Tend end time Ta time Tb time Tc time Td time

Claims (12)

An environmental data management device that performs aggregation processing for the aggregation target period for environmental data that is time-series data,
An environmental data storage unit for storing the environmental data;
A unit tabulation data storage unit for storing unit tabulation data that is tabulated in a plurality of period units having a hierarchical structure in which the environment data is longer than the time series interval of the environment data and has a higher interval .
Referring to the environmental data storage unit, totaling the environmental data based on each of the plurality of period units , and storing the unit total data generation unit as unit total data in each period unit in the unit total data storage unit;
A calculation unit for calculating the aggregation result data of the aggregation target period;
The calculation unit includes:
The aggregation target period is divided into a plurality of periods so as to include more period units of the upper hierarchy among the period units of the plurality of hierarchies, and a period corresponding to the period unit of the upper hierarchy among the plurality of divided periods For the period corresponding to the period unit of the lower hierarchy from the upper hierarchy among the plurality of divided periods, the unit aggregation data corresponding to the period unit of the upper hierarchy is acquired from the unit aggregation data storage unit. Obtains the unit aggregate data corresponding to the period unit of the lower hierarchy from the unit aggregate data storage unit, and corresponds to a period that is less than the period units of all hierarchies among the plurality of divided periods. Data acquisition means for acquiring environmental data of a time zone from the environmental data storage unit ;
An environmental data management apparatus comprising: a data totaling unit that totalizes the unit total data acquired by the data acquisition unit and the environmental data and calculates totaling result data corresponding to the totaling target period.   An input receiving unit that receives an input of a specified period that specifies the aggregation target period;
  The data acquisition means includes
  When the specified period is divided into a plurality by the exclusion period excluded from the aggregation target period, processing is performed as the aggregation target period for each of the divided designated periods.
  The environmental data management apparatus according to claim 1.   The input receiving unit further receives an input of a condition to be excluded from the aggregation target period,
  The data acquisition means includes
  When an exclusion period is determined according to the exclusion condition input from the input receiving unit, and the specified period is divided into a plurality of the determined exclusion period, the aggregation target period for each of the divided specified periods Process as
  The environmental data management apparatus according to claim 2. The predetermined period unit is a day, a month, and a year unit,
The unit aggregate data, daily data, monthly data, and environmental data management apparatus according to any one of claims 1 to 3, characterized in that a yearly data. The environmental data management apparatus according to claim 4 , wherein the unit total data generation unit is executed at the time of a daily change, a monthly change, and an annual change. The environmental data management apparatus according to any one of claims 1 to 5 , wherein the data aggregation means calculates a maximum value, a minimum value, and an average value corresponding to the aggregation target period . The environment data which is time-series data, have rows counting processing for aggregation period, the environmental data storing unit for storing the environmental data, using the environmental data management device and a unit aggregate data storage unit environment A data management method,
The environmental data management device, the longer than the interval of the time series of environmental data, and aggregate the environment data based on each of a plurality of period unit having a hierarchical structure in which the upper ones are long intervals, each time period A unit total data generation step of storing in the unit total data storage unit as unit total data in units;
The environmental data management device divides the aggregation target period into a plurality of periods so as to include more period units of the upper hierarchy among the period units of the plurality of hierarchies, and the upper hierarchy of the plurality of divided periods For the period corresponding to the period unit, the unit aggregation data corresponding to the period unit of the upper hierarchy is acquired from the unit aggregation data storage unit, and the lower hierarchy of the upper hierarchy is divided among the divided periods. For the period corresponding to the period unit, the unit aggregate data corresponding to the period unit of the lower hierarchy is acquired from the unit aggregate data storage unit, and the period units of all the hierarchies among the divided periods are satisfied. For a non-period , a data acquisition step of acquiring environmental data for a corresponding time zone from the environmental data storage unit ;
The environmental data management device comprises the environmental data comprising: the unit aggregate data acquired in the data acquisition step; and the data aggregation step of calculating the aggregated data corresponding to the aggregation target period by aggregating the environmental data Management method.   The environmental data management device further comprises an input receiving step of receiving an input of a designated period for designating the aggregation target period,
  The data acquisition step includes:
  When the environmental data management device is divided into a plurality of specified periods by an exclusion period excluded from the aggregation target period, each of the divided designated periods is processed as the aggregation target period.
  The environmental data management method according to claim 7.   In the input receiving step, the environmental data management device further receives an input of a condition to be excluded from the aggregation target period,
  The data acquisition means includes
  In the case where the environmental data management device determines an exclusion period according to the exclusion condition input in the input reception step, and the specified period is divided into a plurality by the determined exclusion period, the divided specified period For each of the above, the processing is performed as the aggregation target period.
  The environmental data management method according to claim 8. The predetermined period unit is a day, a month, and a year unit,
The environmental data management method according to any one of claims 7 to 9 , wherein the unit total data is daily unit data, monthly unit data, and year unit data. The environmental data management method according to claim 10 , wherein the unit total data generation step is executed when the environmental data management device changes daily, monthly, and annually. The environmental data management method according to any one of claims 7 to 11 , wherein in the data aggregation step, the environmental data management device calculates a maximum value, a minimum value, and an average value corresponding to the aggregation target period. .

Images