JP2007328536A - Environmental information tabulation device, environmental information tabulation method and program - Google Patents

Abstract

<P>PROBLEM TO BE SOLVED: To provide an environmental information tabulation device enabling operation by multiplication and division between aspect data. <P>SOLUTION: This environmental information tabulation device 100 comprises a storage part containing aspect data 105 as a numerical value at a plurality of times of an environmental aspect having a hierarchical structure, aspect hierarchical data 101 including a predetermined coefficient to be multiplied to a numerical value of an environmental aspect of a lower layer, and any one operator of addition, subtraction, multiplication and division for calculating an environment aspect of an upper layer and time hierarchical data 113 defining an inclusion relation of a plurality of time sections; and a tabulation processing part 106. The tabulation processing part calculates, based on the time hierarchical data 113 and the aspect data 105, a numerical value of the environmental aspect of a terminal layer in each time section, and calculates, based on the calculated value and the aspect hierarchical data 101, a numerical value of environmental aspect of the upper layer in each time section which does not satisfy a condition in which the operator is multiplication or division, and the value of environmental aspect of the low-order layer is '0'. <P>COPYRIGHT: (C)2008,JPO&INPIT

Description

  The present invention relates to an information processing system, and more particularly to an environmental information totaling apparatus, an environmental information totaling method, and a program for storing and totaling information related to business such as environmental management, environmental accounting, and chemical substance management.

  In an information processing system that handles environmental information, information relating to operations such as environmental management, environmental accounting, and chemical substance management is information relating to aspects (environmental aspects) defined by ISO14001. In other words, “organizational product / activity / service element”. These aspects are ambiguous, and include the use / disposal / storage amount of chemical substances, the number of complaints of residents in the surrounding area, the cost of environmental exchange events, the amount of recycled products shipped, the number of occupational accidents, etc. There are so many different names and units.

As an example of such an information processing system, Patent Document 1 defines the names and units of these environmental aspects as database records, and further adds a weighted sum (sum of products) between a plurality of aspects to the upper aspect. An environmental information aggregation and analysis system is disclosed that enables automatic aggregation of various environmental aspects over a certain period of time by having a side hierarchy structure defined as:
JP 2004-62471 A (paragraphs 0037 to 0040, FIGS. 9 and 10)

  The environmental information aggregation and analysis system described in Patent Literature 1 has a feature of having a side layer structure that defines a weighted sum (product sum) between a plurality of sides as an upper side, and uses energy and waste disposal Since many aspects such as these are the objects to be aggregated by the addition operation, there are not a few scenes that can be used in the above-described conventional technology.

  However, such a conventional technique has a problem in that multiplication and division between sides cannot be defined. For example, when the aspect of “Energy per product” is multiplied by “Production quantity” to derive the aspect of “Total environmental impact of the factory”, or “Total environmental impact of the factory” is divided by “Sales” Thus, when it is desired to derive the aspect of “per unit of sales”, the environmental information totaling analysis system described in Patent Document 1 cannot be solved.

  In other words, due to the fact that the aspect is recorded depending on the time and that multiple aspects are not necessarily recorded at the same time, in the case of multiplication or division, the calculation result is `` It becomes “zero” or “infinity”.

  SUMMARY OF THE INVENTION Accordingly, an object of the present invention is to provide means for enabling operations by multiplication and division between side data in view of the above-described problems of the prior art.

The environmental information totaling apparatus according to the present invention, which has been made to achieve the above-described object, calculates side data that is numerical values at a plurality of times of environmental aspects having a hierarchical structure, and environmental aspects of the upper hierarchy from the environmental aspects of the lower hierarchy. When performing the addition, subtraction to calculate the environmental aspect of the upper hierarchy using a predetermined coefficient multiplied by the numerical value of the environmental aspect of the lower hierarchy, and the numerical value of the environmental aspect of the lower hierarchy multiplied by this coefficient, Based on the side hierarchy data including any operator of multiplication or division, the storage unit that contains and stores the time hierarchy data defining the inclusion relation of a plurality of time intervals, the time hierarchy data and the side data, The numerical value of the environmental aspect of the terminal hierarchy in each time interval is calculated. Based on the calculated value and the lateral hierarchy data, the operator is multiplication or division, and the environmental aspect value of the lower hierarchy is “0”. Characterized in that it comprises a counting processing unit for calculating the numerical value of the environmental aspect of the upper layer in each time interval does not satisfy the condition.
Other aspects of the present invention will be described in detail in the embodiments described later.

  According to the environmental information totaling apparatus, the environmental information totaling method, and the program according to the present invention, when high-order side data is totaled using side data having a hierarchical structure, the high-order layers are totaled by multiplication and division between the side faces. Can do.

  Hereinafter, preferred embodiments of the present invention will be described in detail with reference to the accompanying drawings.

  FIG. 1 is a diagram showing a configuration example of an environmental information totaling analysis system according to an embodiment of the present invention. The environmental information totaling analysis system shown in FIG. 1 is housed in a computer apparatus 100 corresponding to the environmental information totaling apparatus of the claims, and includes a side hierarchy definition database 101, a side hierarchy definition interface 102, an organization hierarchy definition database 103, an organization The hierarchy definition interface 104, the side database 105, the aggregation processing unit 106, the side hierarchy data display interface 107, the organization hierarchy data display interface 108, and the time hierarchy definition database 113 are provided. Through a wide area network), a user can use the terminal device installed in the overall management department 111 of the entire organization and the management department 112 in each organization.

The side layer definition database 101 in FIG. 1 stores side layer data that defines the relevance of each side. For example, reference numeral 101a in FIG. 1 indicates “unit sales amount”, “total CO ₂ emission amount”, “CO ₂ emission amount per vehicle”, “sales amount”, “manufactured units” which are aspects of a certain factory. , The concept of side layer data defining the interrelationship between “heavy oil consumption per vehicle” and “power usage per vehicle”.

For example, if “power used per vehicle” is 1 kwh / unit, it is equivalent to discharging 0.4 kg / unit of CO ₂ into the atmosphere. In addition, if “the amount of heavy oil used per vehicle” is 1 liter (liter) / unit, this indicates that 3.2 kg / unit of CO ₂ has been discharged. Therefore, the CO ₂ emissions when electricity and heavy oil are consumed in the manufacturing process of a certain product correspond to the sum of the respective usage amounts with these weights.
On the other hand, when considering the factory as a whole, “CO ₂ emissions per vehicle” can be calculated by multiplying “Manufactured units”, and “Total CO ₂ emissions” can be calculated by dividing this by sales. The plateau unit can be calculated. The side layer definition database 101 stores such a hierarchical relationship between side surfaces as side layer data.

  The side hierarchy definition interface 102 is an interface for storing the above side hierarchy data based on an input from a terminal device installed in the overall management department 111. The side hierarchy definition interface 102 accepts inputs of side names, units, side inclusion relationships, operators and conversion factors, and uploads a text file (side hierarchy data) 110 consisting of lines describing these from the terminal device. The record is directly generated and stored in the side layer definition database 101 on the computer apparatus 100.

The organization hierarchy definition database 103 is a database that stores organization hierarchy data that defines a hierarchical relationship between a plurality of different organizations. Here, the reference numeral 103a in FIG. 1 shows the concept of organization hierarchy data that defines a tree structure indicating the relationship between the organizations.
The organization hierarchy definition interface 104 is an interface for storing the organization hierarchy data described above. Accepts input of organization name and organization inclusion relationship, and uploads a text file (organization hierarchy data) 110 composed of lines describing these from the terminal device or records directly in the organization hierarchy definition database 103 on the computer device 100 Is generated and stored.
The side database 105 stores side data. Aspect data is obtained by acquiring and storing numerical information transmitted from measuring means (not shown) that measures the aspect, or aggregated inside the system, and identifiers for each aspect, numerical values, dates, and organization identifiers. It is comprised including.

The tabulation processing unit 106 adds and tabulates the side data of the end side surface stored in the side database 105 along the time interval hierarchy stored in the time hierarchy definition database 113 to be described later, and uses the result value to calculate the side hierarchy. Aggregation of each upper side along the line is performed using an operator.
Further, the totalization processing unit 106 adds and totals each side according to the organizational hierarchy data stored in the organizational hierarchy definition database 103. As a result, the data of the upper side becomes the calculation result of the subordinate organization, and the side data of the upper organization becomes the addition result of the subordinate organization.
The detailed processing procedure of the aggregation processing unit 106 will be described later.

  The side hierarchy data display interface 107 provides the computer device 100 with a function for the terminal device of the management department 112 of each organization that accesses the wide area network 109. Via the side hierarchy data display interface 107, the terminal device of the management department 112 of each organization can display numerical values of any side, and further reversely display the numerical values of the lower side that is the breakdown. You can also. In this way, the tabulated numerical information can be displayed each time while freely moving up and down the side hierarchy tree.

  The organization hierarchy data display interface 108 provides a function for the terminal device of the management department 112 of each organization that accesses the computer device 100 via the wide area network 109. Via the organization hierarchy data display interface 108, the terminal device of the management department 112 of each organization can display the numerical values of the aspects of an arbitrary organization, and further reverses the numerical values of the aspect of the subordinate organization that is the breakdown. Can also be displayed. In this way, the aggregated numerical information can be displayed each time while freely moving up and down the tree of the organization hierarchy.

  The time hierarchy definition database 113 stores time hierarchy definition data that defines a hierarchy relationship between a plurality of different time intervals. Stores predefined records in addition to the time interval hierarchy based on calendar information such as day, month, and year. The record structure is composed of a unique identifier of a time section, a name, and a field representing an inclusion relationship between hierarchies. Details of the time hierarchy definition data will be described later with reference to FIG.

Here, FIG. 2 is a diagram showing an actual configuration example of the side layer data stored in the side layer definition database 101. The side hierarchy data of the present embodiment includes a table indicated by a reference numeral 201 having a “side identifier” for identifying a side, a “name” of the side, and a “unit” of the numerical value of the side as fields. “Parent identifier” and “child identifier” that define the inclusive relationship, “conversion coefficient” that is multiplied when calculating the parent upper side from the child lower side, and “operator” used for the calculation And a table indicated by a reference numeral 202 having a field as a field. In the example shown in FIG. 2, the calculation rule for the numerical value of “sales unit” whose “side identifier” item is “A0001” is the record in the first and second rows of the table indicated by reference numeral 202. has been written. That is, it is recorded that the total CO ₂ emission amount (A0003) is a numerator (multiplication) and the sales amount (A0002) is a denominator (division).

In the third and fourth rows of the table denoted by reference numeral 202, calculation rules for “total CO ₂ emission amount” (A0003) are written, and “manufactured units” (A0004) and “1 unit” are written. It is recorded that it is obtained by multiplication with "CO2 emission per hit" (A0005). Further, in the 5th and 6th rows of the table indicated by reference numeral 202, an arithmetic expression for obtaining “CO2 emission amount per unit” (A0005) is written, and “power consumption per unit” (A0006). An operation rule indicating that the value is obtained by adding the value obtained by multiplying 0.4 by 0.4 and the value obtained by multiplying “the amount of heavy oil used per vehicle” (A0007) by 3.2 is recorded. In this way, the inclusive relationship between complex aspects is defined as a collection of a plurality of records.

  Next, FIG. 3 is a diagram showing an example of a text format file 110 read from the side hierarchy definition interface 102. As shown in FIG. 3, the text format file 110 read from the side hierarchy definition interface 102 is a comma-separated file (see FIG. 2) having the same arrangement as the side hierarchy data (201, 202) shown in FIG. (CSV format: Comma Separated Values), and includes data indicated by reference numeral 301 and data indicated by reference numeral 302. This file 110 is uploaded to the computer apparatus 100 via the wide area network 109 from the terminal device of the general management department 111, for example. As a result, the record of the side layer data shown in FIG. 2 is generated.

In addition, when reading a file containing information that overwrites or changes the side hierarchy data already stored in the side hierarchy definition database 101, the side hierarchy definition interface 102 prohibits writing and protects it so that it cannot be changed normally. To do.
In addition, the side hierarchy definition interface 102 performs error checks such as whether or not the same identifier exists with different names, whether or not different names exist with the same identifier, and whether or not a loop exists in the side hierarchy data. If there is an error, for example, the screen display data indicating that the error exists is transmitted to the terminal device of the general management department 111, and the reflection to the side hierarchy definition database 101 is reflected only when all the errors are resolved. Do.

  Such side hierarchy data stored in the side hierarchy definition database 101 can be regarded as basic know-how of environmental management. In other words, according to the purpose of environmental management, it can be considered as a file that defines a specific algorithm for how to analyze collectable information (terminal side) into management information (upper side).

  Next, FIG. 4 is a diagram showing a display example of the input screen for the side layer data described above, using the GUI (Graphical User Interface). Here, it is assumed that the tree structure between the side surfaces shown in FIG. As shown in FIG. 4B, on the input screen 401, the tree structure is displayed in the divided area on the left side of the screen. Here, the side layer data up to the side surfaces A, C, B, and E are already stored, and the case where the side surface F is set next is shown.

First, when the side surface definition interface 102 is clicked on the input screen 401 by using a pointing device such as a mouse (not shown) as a parent side surface (here, the B side surface), the side surface is selected and displayed in black and white. As a result, the “lower side addition screen” is displayed on the right side of the screen, and when the “new addition” button 402 is clicked on the screen, the “name”, “unit”, “conversion coefficient”, “operator” inputs Display a box. Here, the input boxes for "Name" and "Conversion factor" can be entered arbitrarily, and the input boxes for "Unit" and "Operator" can be selected and input from the pull-down menu format. . Thus, when a new additional definition is made, the side layer definition interface 102 automatically assigns a side identifier that does not overlap with an existing side identifier and stores it in the side layer definition database 101.
Note that the side hierarchy definition interface 102 displays a screen display indicating that an error exists in the terminal device of the overall management department 111, for example, when the name of the already registered side and a duplicate name are input to the input screen 401. Sending data prompts the user to re-enter.

  Next, FIG. 5 is a diagram showing a configuration example of organization hierarchy data stored in the organization hierarchy definition database 103. The organization hierarchy data according to the present embodiment includes a table indicated by reference numeral 501 that defines an organization name and a table indicated by reference numeral 502 that defines a hierarchical relationship between organizations. The table indicated by reference numeral 501 has a record having “organization identifier” for identifying each organization and “name” of the organization as fields, and the table indicated by reference numeral 502 identifies an upper organization. It has a record in which a “parent identifier” and a “child identifier” that identifies the subordinate organization are stored in pairs.

  Next, FIG. 6 is a diagram showing an example of the text format file 110 read from the organization hierarchy definition interface 104. As shown in FIG. 6, the text format file 110 read from the organization hierarchy definition interface 104 is a comma-delimited file (see FIG. 5) having the same arrangement as the record format of the organization hierarchy data (501, 502) shown in FIG. (CSV format), and is composed of data indicated by reference numeral 601 and data indicated by reference numeral 602. This file 110 is uploaded to the computer apparatus 100 via the wide area network 109 from the terminal device of the general management department 111, for example. As a result, the record of the organization hierarchy data shown in FIG. 5 is generated.

The organization hierarchy definition interface 104 prohibits writing and protects the reading of files containing information that overwrites or changes the organization hierarchy data already set in the organization hierarchy definition database 103 so that it cannot be changed normally. To do.
In addition, the organization hierarchy definition interface 104 checks whether there is an identical identifier with a different name, whether there is a different name with the same identifier, whether there is a loop in the organization hierarchy data, etc. If there is an error, for example, screen display data indicating that the error exists is transmitted to the terminal device of the overall management department 111, and the reflection to the organization hierarchy definition database 103 is reflected only when all the errors are resolved. Do.
The organization hierarchy data can also be input from the terminal device of the overall management department 111 using the same GUI as the input screen 401 shown in FIG.

Next, FIG. 7 is a diagram illustrating a configuration example of the side data stored in the side database 105. As described above, the side data is obtained by recording actual numerical values of each side. As shown in FIG. 7, for each “side identifier”, “organization identifier” that identifies the organization in which the “numerical value” of the side is registered is recorded in the side database 105. Next, the “date and time” in which the “number” field is recorded and the “number” are recorded.
Here, the organization which can newly register the numerical value of the side face is limited to the terminal tissue. This is because the numerical value of the aspect of the higher organization is derived by the aggregation processing unit 106 adding up the aspects of the lower organization.

Next, FIG. 8 is a diagram showing a configuration example of time hierarchy data that defines a hierarchical relationship between a plurality of different time intervals stored in the time hierarchy definition database 113. The time hierarchy definition data includes a record in which “date time value” corresponding to the “time interval identifier” for identifying the time interval shown in FIG. 8A is stored, and reference numeral 801 for defining the time interval. And a table denoted by reference numeral 802 having information defining the inclusion relationship of the time intervals.
The information defining the inclusion relationship of the time intervals stored in the table indicated by reference numeral 802 represents the relationship of the tree structure shown in FIG. 8B, and is a parent that identifies the parent time interval. It has a record structure in which a time interval identifier and a child time interval identifier included in the time interval identifier for identifying a child time interval are recorded in pairs.

For example, in the record group indicated by reference numeral 8021 in FIG. 8A, the “parent time section identifier” is “T2006” and the time period “2006” has “child time section identifier” “T200601”. It defines that the time interval from “January 2006” to “December 2006” with “child time interval identifier” “T20000612” is included.
Further, in the record group indicated by reference numeral 8022 in FIG. 8A, the time period “February 2006” with the “parent time interval identifier” “T200602” has the “child time interval identifier” “T20060201”. It is defined that “February 1, 2006” to “February 28, 2006” in which “child time interval identifier” is “T2006060228” are defined.
These definitions are used to perform time interval aggregation that is essential for multiplication and division operations described later. The time hierarchy definition database 113 is defined in advance as calendar information, and is updated by directly operating the table by database operation.

  Next, FIG. 9 is a diagram for explaining the reason why it is usually difficult to perform multiplication and division between side data, and a solution to that using a time interval hierarchy in the present invention. In FIG. 9A, the horizontal axis indicates the date and time, and the data on the two side surfaces B and C are shown. Assume that these two aspects are tabulated by calculation from time T1 to time T2.

Generally, side data is acquired at various dates and times. For example, the amount of power used is often determined by the difference from the previous measurement, but if it is known when the monthly electricity bill is revealed, recorded by daily inspections, or by a power meter It may be recorded every second. Further, for example, as the number of manufactured units, the cumulative number of manufactured units for the day may be recorded at the end of the day, or the number of manufactured units for each hour may be recorded.
In this way, depending on the type and acquisition method, as shown in FIG. 9A, each numerical value may be an instantaneous value at a different point in time, and addition and aggregation can be performed from time T1 to time T2. However, there are cases where aggregation by multiplication and division is not possible. In other words, there is a case where the data at the same time is not accurately prepared, and it becomes impossible to know at what time the other party's data should be subjected to multiplication or division.

Therefore, the computer apparatus 100 according to the present embodiment first calculates a value obtained by adding and summing the numerical values of the respective sides in various time intervals defined in advance. FIG. 9B is an example in which the side surface B and the side surface C shown in FIG. By summing up as shown in FIG. 9B, multiplication and division can be performed between the values summed up within the same time interval. This is based on the fact that many aspects such as power consumption, sales, and production volume generally have the property of being able to be added up in the time axis direction. This property makes it possible to align the instantaneous value of the side face at different times with the total value of the same time interval.
Some types of aspects have properties that are unsuitable for adding up and summing numerical values within a time interval. For example, if the side surface is electric power (W), it corresponds by calculating the average value in the time interval.

[Processing of total processing section]
Next, FIG. 10 is a flowchart showing a processing procedure of the aggregation processing unit 106 that realizes the aggregation method shown in FIG. Hereinafter, the processing procedure in the totalization processing unit 106 of the computer apparatus 100 will be described with reference to the flowchart shown in FIG. 10 (see FIGS. 1 and 9 as appropriate). As a premise, each of the above-described information is stored in each database (101, 103, 105, 113) of the computer apparatus 100.

  First, the totalization processing unit 106 sets a totaling period (in the example of FIG. 9, from time T1 to time T2) to be totaled (step 10a). This setting is made by acquiring information specifying the time point via the side layer data display interface 107 from the terminal device of the general management department 111 or the management department 112 of each organization.

Next, the totalization processing unit 106 executes the following totalization process for the records included in the totalization period acquired in Step 10 a from the record group of the side database 105.
First, using the time interval stored in the time hierarchy definition database 113 for the end aspect, the numerical values (instantaneous values) of all aspects included in the aggregation period are added and aggregated for each time interval (step 10b). . Here, the terminal side surface is a side surface having a numerical value as a measured value that is an instantaneous value. From the instantaneous value illustrated in FIG. 9A, the aggregated value for each time interval illustrated in FIG. 9B. Is converted to
Then, for each side surface, the upper side surfaces are totaled using the operator (see FIG. 2) of the side layer data stored in the side layer definition database 101 (step 10c). Here, the upper side surface is a side surface having a numerical value as a calculated value using the end side surface or another upper side surface.

  When calculating the upper side, when multiplication or division is used, if the value on one side is “0”, the value on the upper side becomes “0” or infinite. Therefore, in Step 10c, a special procedure is used to avoid the side surface value from becoming “0” or infinity. Details of the mechanism of the special procedure in step 10c will be described later.

  Next, based on the organization hierarchy data stored in the organization hierarchy definition database 103, the aggregation processing unit 106 performs subordinate organization along the organization hierarchy so that the numerical value of the upper organization is a simple sum of the numerical values of the lower organization. From side to side, the side faces are added and totaled (step 10d).

Here, FIG. 11 is a diagram showing an example of an intermediate record indicating the counting result after the procedure of step 10b. The table indicated by reference numeral 1101 in FIG. 11 indicates “time interval total value” that is the interval total value for each large and small “time interval identifier” for the side surface with the side identifier “A0008”.
It can be seen that if the time interval hierarchy is too low (that is, if the time interval is too short), there is no measurement value that falls within that interval, and the time interval aggregate value may be “0” (for example, “time interval” Field of “time interval total value” with “identifier” of “T2006060102”). However, the time section aggregate value does not become “0” in a time section higher than a certain time section hierarchy. The computer apparatus 100 according to the present embodiment selects an appropriate time interval for executing multiplication and division by paying attention to such a relationship.

  In relation to the selection of this time interval, FIG. 12 is a detailed flowchart of step 10c of the flowchart shown in FIG. The process in step 10c will be described in detail with reference to FIG.

First, the aggregation processing unit 106 determines whether the operator for calculating the higher-order aspect to be calculated is multiplication or division (step 12a).
Here, when the operator is not multiplication or division (in the case of “NO” in step 12a), the operator is addition / subtraction, the operation is performed between the target lower aspects, and the result value is set to the numerical value of the upper aspect. (Step 12c).
On the other hand, when the operator is multiplication or division (“YES” in step 12a), it is determined whether or not there is no target lower side surface having the time interval aggregate value “0” (step 12b). Here, when there is no “0” in the time section aggregate value (in the case of “YES” in step 12b), the process proceeds to step 12c to calculate and record the upper side surface.
On the other hand, when there is a time section total value of “0” (in the case of “NO” in step 12b), the calculation of the upper side is skipped and the process is terminated.
By such a processing procedure, the aggregate value of the aspect according to the appropriate time interval can be obtained, and based on this, the aggregate value in an arbitrary aggregation period (from time T1 to time T2 in FIG. 9) can be calculated. it can.

[Screen display example]
Next, FIG. 13 is a diagram showing an example of a screen display that the side hierarchy data display interface 107 displays on the terminal device of the management department 112 of each organization. In the screen display 1301 shown in FIG. 13, the side hierarchy tree display indicated by reference numeral 1302 is shown on the left half. For example, when “greenhouse gas emissions” is selected, “1” is displayed as the lower hierarchy. “Greenhouse gas emissions per unit” and “Manufactured units” are displayed. Further, in the side hierarchy tree display in which the lower hierarchy indicated by reference numeral 1302 is displayed, when “greenhouse gas emission” is selected, the area indicated by reference numeral 1303 on the right side of the screen display 1301 is indicated by reference numeral 1304. As shown in the figure, not only “23800 kg” is displayed as a total numerical value, but also numerical values of two lower side surfaces that are the breakdown thereof are displayed as indicated by reference numeral 1305.

Next, FIG. 14 is a diagram showing an example of a screen display that displays a side hierarchy tree in which “greenhouse gas emissions per vehicle” is further expanded in the screen display 1301 shown in FIG. In the screen display 1401 shown in FIG. 14, the side hierarchy tree display indicated by reference numeral 1402 is shown in the left half. Here, the “greenhouse effect per vehicle” is indicated by the side hierarchy tree indicated by reference numeral 1302 in FIG. 13. This is an example in a case where “gas emission amount” is selected and “CO ₂ emission amount” in the lower hierarchy is selected. At this time, the area indicated by reference numeral 1403 on the right side of the screen display 1402 not only displays “119000 kg” as a total numerical value as indicated by reference numeral 1404, but also as indicated by reference numeral 1405. The numerical values of the eight items, which are the breakdown, are shown in each unit, and converted to CO ₂ kg after conversion. The total of the conversion results corresponds to “119000 kg” of “Greenhouse gas emissions per vehicle” in FIG.

  Next, FIG. 15 is a diagram showing an example of a screen display that the organization hierarchy data display interface 108 displays on the terminal device of the management department 112 of each organization. In the screen display 1501 shown in FIG. 15, the organization hierarchy tree display indicated by reference numeral 1502 is shown in the left half, and when a lower Kanto district (with jurisdiction) of the environmental headquarters is selected, the screen display 1501 An area indicated by reference numeral 1503 is displayed on the right side of the display 1501, and the total value “1030000 kg” of the side surface (greenhouse gas emissions) indicated by reference numeral 1504 and the breakdown of its subordinate organizations are “Tokyo office”, “ The breakdown of “Chiba Works”, “Gunma Works”, and “△△△ Company” is shown in the area denoted by reference numeral 1505.

  In the embodiment described above, the computer apparatus 100 is implemented using a general computer having a CPU (Central Processing Unit), a RAM (Random Access Memory), a ROM (Read Only Memory), a hard disk drive, a network interface, and the like. Is possible. At this time, the totalization processing unit 106 and each interface (102, 104, 107, 108) of the computer apparatus 100 are implemented by executing a dedicated program stored in a hard disk drive, for example, and each database (113, 101, 103, 105) are implemented by allocating hard disk drive areas, respectively.

  The present invention is not limited to the above-described embodiment, and can be implemented with various modifications. For example, using the computer apparatus 100 alone, data can be input to each database from input means (not shown) of the computer apparatus 100. In addition, a measuring unit that measures the numerical value of the environmental aspect may be connected to the computer apparatus 100. Therefore, the present invention is defined by the technical idea described in the claims.

It is drawing which shows the structural example of an environmental information totaling analysis system. It is drawing which shows the structure of the side hierarchy data stored in the side hierarchy definition database. It is drawing which shows the file of the text format read from the side hierarchy definition interface. It is a figure which shows the input screen which a side hierarchy definition interface displays. It is drawing which shows the structure of the organization hierarchy data stored in the organization hierarchy definition database. It is a figure which shows the file of the text format read from the organization hierarchy definition interface. It is drawing which shows the structure of the side data stored in the side database. It is drawing which shows the structure of the time hierarchy data stored in the time hierarchy definition database. It is drawing for demonstrating the reason why the multiplication and division between side data are difficult, and the solution to it. It is the flowchart which showed the process sequence which implement | achieves the totaling method shown in FIG. It is the figure which showed the example of the intermediate record which shows the total result after the procedure of step 10b. It is a detailed flowchart of step 10c. It is drawing which showed the example of the screen display which a side hierarchy data display interface displays. In the screen display shown in FIG. 13, a side hierarchy tree in which “greenhouse gas emissions per vehicle” is further expanded to the lower level is shown. It is drawing which showed the example of the screen display which an organization hierarchy data display interface displays.

Explanation of symbols

101 Side hierarchy definition database 103 Organization hierarchy definition database 105 Side database 106 Total processing unit 113 Time hierarchy definition database

Claims (5)

An environmental information aggregation device that aggregates environmental information using side data that are numerical values at a plurality of times of environmental aspects having a hierarchical structure,
When calculating the environmental aspect of the upper hierarchy from the environmental aspect of the lower hierarchy, the upper level is calculated using a predetermined coefficient multiplied by the numerical value of the environmental aspect of the lower hierarchy and the environmental aspect value of the lower hierarchy multiplied by this coefficient. Side hierarchy data, including any of addition, subtraction, multiplication or division operators to calculate the environmental aspects of the hierarchy;
A storage unit including time hierarchy data defining an inclusion relationship of a plurality of time intervals;
Based on the time hierarchy data and the aspect data, calculate the numerical value of the environmental aspect of the end hierarchy in each time interval, based on the calculated value and the aspect hierarchy data, the operator is multiplication or division, and An aggregation processing unit for calculating numerical values of the environmental aspects of the upper hierarchy in each time interval that does not satisfy the condition that the value of the environmental aspects of the lower hierarchy is '0';
Environmental information aggregation device characterized by The storage unit
It further includes organizational hierarchy data that defines the inclusion relationship between the upper organization and the lower organization of the organization having a hierarchical structure,
The aggregation processing unit
Using the numerical values of the environmental aspects of the upper hierarchy in each calculated time interval and the organizational hierarchy data, calculating the numerical values of each environmental aspect in each time interval of each organization;
The environmental information totaling apparatus according to claim 1. An environmental information totaling method in an environmental information totaling apparatus including a storage unit that stores side data that are numerical values at a plurality of times of environmental aspects having a hierarchical structure,
The storage unit
When calculating the environmental aspect of the upper hierarchy from the environmental aspect of the lower hierarchy, the upper level is calculated using a predetermined coefficient multiplied by the numerical value of the environmental aspect of the lower hierarchy and the environmental aspect value of the lower hierarchy multiplied by this coefficient. Side hierarchy data, including any of addition, subtraction, multiplication or division operators to calculate the environmental aspects of the hierarchy;
Including time hierarchy data that defines the inclusion relationship of multiple time intervals,
The aggregation processing unit of the environmental information aggregation device
Based on the time hierarchy data and the aspect data, calculate the numerical value of the environmental aspect of the terminal hierarchy in each time interval,
Based on this calculated value and the side hierarchy data, the operator is multiplication or division, and the environmental aspect of the upper hierarchy in each time interval that does not satisfy the condition that the value of the environmental aspect of the lower hierarchy is '0'. Calculating a numerical value,
Environmental information aggregation method characterized by The storage unit
It further includes organizational hierarchy data that defines the inclusion relationship between the upper organization and the lower organization of the organization having a hierarchical structure,
The aggregation processing unit
Further calculating the numerical values of the environmental aspects in each time interval of each organization using the numerical values of the environmental aspects of the upper hierarchy in each calculated time interval and the organizational hierarchy data;
The environmental information totaling method according to claim 3.   A program causing a computer to execute the environmental information totaling method according to claim 3 or 4.

Images