JP2012018458A - Environmental information tabulation system, environmental information tabulation method, and environmental information tabulation program - Google Patents

Abstract

PROBLEM TO BE SOLVED: To increase the efficiency of collecting environmental information on a product and avoid the generation of variance such as under-reporting in a tabulation result of the environmental information.SOLUTION: A computer executes: a processing for searching a component attribute table for environmental information on a component constituting a product and collecting environmental information; a processing for transmitting a request to obtain environmental information on the component to a specified server with respect to the component whose environmental information is not obtained by the search and collects the environmental information; a processing for obtaining environmental information on the component whose procuring destinations are multiple in a component group having collected environment information and identifying a logical sum of kind of chemical material, the maximum value of a content in each chemical material, and the minimum value of a component weight with respect to the same component; and a processing for calculating a content by dividing the maximum value of a content by the minimum value of the component weight for each kind of the chemical material obtained by a logical sum with respect to the component whose procuring destinations are multiple, and calculating a content of the chemical material with respect to the component whose procuring destinations are not multiple, and tabulating and outputting a content of the chemical material calculated with respect to each component regarding each products.

Description

  The present invention relates to an environmental information totaling system, an environmental information totaling method, and an environmental information totaling program. Specifically, the present invention aims to improve the collection efficiency of environmental information related to products, and to underreport the environmental information totaling result. The present invention relates to a technique for avoiding wrinkles such as

In corporate activities, it is important to understand the status of compliance with various environmental regulations for the products handled and reflect them in product development and manufacturing. In countries such as Europe and China, environmental regulations and laws have been strengthened in particular, and it is required to report various environmental information such as the amount and concentration of chemical substances contained in products.
In order to collect environmental information, it is indispensable to collect environmental information for each part used in the product, and it is necessary to use a mechanism to collect environmental information as part of ordering information with parts suppliers. It has begun.

Further, in parts procurement activities in companies, generally, procurement of parts with the same specifications from a plurality of suppliers (ie, purchasing by a plurality of companies) is common for the purpose of preventing out of stock and reducing procurement costs. Therefore, it is useful to collect and tabulate various environmental information related to products in consideration of the procurement method of such parts.
The environmental information aggregation technology includes, for example, part information of a minimum part unit of a product composed of a plurality of parts, unit part information constituted by assembling the parts, and purchase ratio of regular parts and alternative parts. Product cost calculation device that calculates the total cost of a product based on an input means for inputting product part information, a part connection means for connecting parts, and a setting means for setting alternative parts for regular parts Based on the ratio calculation means for calculating the ratio between the regular part and the part specified as the substitute part, and the purchase ratio of the regular part and the substitute part, the part cost is accumulated and the total product cost is calculated. There has been proposed a product cost calculation device (see, for example, Patent Document 1) characterized by including total cost calculation means.

JP 2002-351945 A

  However, in the prior art, for example, it is necessary to collect various types of original data used for environmental information aggregation and perform processing after it has been completed. Therefore, depending on the degree of information collection, environmental information can be aggregated and evaluated with good accuracy. It was in a situation where it was impossible to perform such processing. If the source information required for tabulation is insufficient, it is impossible to prove that environmental information on harmful chemical substances is fully considered in the obtained tabulation results, and therefore violates laws and regulations such as environmental regulations. Risk arises. On the other hand, as a business partner (supplier) that provides environmental information, providing environmental information on supply parts in accordance with the requirements of each company (buyer) requires a lot of time and effort, and it is difficult to respond quickly. is there. From these situations, it was necessary to perform environmental information aggregation / evaluation work while constantly checking the environmental information collection status.

  In addition, as mentioned above, procurement methods such as purchasing by multiple companies have been diversified, but even parts purchased by multiple companies are handled as one part procured from one supplier on the parts list. Yes. Therefore, even if the parts have the same specifications, if the environmental information differs for each business partner, the results obtained by aggregating such environmental information are not only different from the environmental information shown by the actual product, but also are inadequate regarding hazardous substances. There are also concerns about flaws such as filing.

  SUMMARY OF THE INVENTION An object of the present invention is to provide a technique for improving the efficiency of collecting environmental information about products and avoiding the occurrence of defects such as underreporting in the environmental information tabulation results.

  The environmental information aggregation system of the present invention that solves the above problems is an information processing system that aggregates environmental information of products, and is a parent-child relationship between a communication device that communicates with other devices via a network and components that make up the product A storage device that stores a component configuration table that indicates a supplier, a component attribute table that stores environmental information for each component, and an instruction to collect environmental information related to a predetermined product from an input device or another device via a communication device Then, the parts constituting the product are specified in the part configuration table, the environment information of the specified parts is searched in the part attribute table, the environment information of each part is collected, and the parts are obtained by the search. For parts for which environmental information is not available in the configuration table, environmental information on various parts is disclosed on the network Processing for collecting the environmental information of the relevant part to the server, collecting the environmental information of the relevant part, and parts having a plurality of parts suppliers in the parts group from which the environmental information has been collected The environmental information provided by each component supplier for the same component is obtained by searching in the component attribute table or by obtaining an acquisition request to the predetermined server. The logical sum of the types of chemical substances, the processing for specifying the maximum value of the content of each chemical substance, and the minimum value of the part weight, and the parts obtained with the parts procurement source obtained by the logical sum. For each chemical substance type, calculate the content of the corresponding chemical substance by dividing the maximum value of the content by the minimum value of the part weight. Divide the content of each chemical substance indicated by the environmental information obtained by collection by the weight of the part to calculate the content rate of the corresponding chemical substance, and the content rate of the chemical substance calculated for each part is specified in the above aggregation instruction And a processing unit that counts up a group of parts constituting the product and outputs the count result to an output device.

  In addition, the environmental information totaling method of the present invention stores a communication device that communicates with other devices via a network, a component configuration table that indicates a parent-child relationship between components that make up a product, a procurement source and environmental information for each component. A computer that includes a storage device that stores a component attribute table to be processed and an arithmetic device, and that counts environmental information about products receives an instruction to count environmental information about a predetermined product from an input device or another device via a communication device Identifying the parts constituting the product in the part configuration table, searching the part attribute table for the environment information of the specified parts, collecting the environment information of each part, and the part configuration by the search Predetermined server that publishes environmental information on various parts on the network for parts for which environmental information is not available in the table On the other hand, a process for collecting the environmental information of the relevant part, sending the environmental information of the relevant part, and searching the part attribute table where there are a plurality of parts suppliers in the parts group from which the environmental information has been collected The environment information provided by each component supplier regarding the corresponding component is retrieved from the component attribute table or acquired by an acquisition request to the predetermined server, and the environment information provided by each component supplier regarding the same component , The logical sum of the types of chemical substances, the process of identifying the maximum value of the content of each chemical substance, and the minimum value of the part weight, and the chemical substance obtained by the logical sum for parts having a plurality of parts suppliers For each type, calculate the content rate of the corresponding chemical substance by dividing the maximum value of the content by the minimum value of the weight of the part. Divide the content of each chemical substance indicated by the environmental information by the weight of the component to calculate the content rate of the corresponding chemical substance, and configure the product specified in the above aggregation instructions with the calculated chemical substance content rate for each part And a process of summing up a group of parts to be output and outputting the summation result to an output device.

  In addition, the environment information totaling program of the present invention stores a communication device that communicates with other devices via a network, a component configuration table that indicates a parent-child relationship between components that make up a product, and a procurement source and environmental information for each component. A storage device that stores a component attribute table to be processed, and an arithmetic unit, and a computer that totals environmental information of products receives an environmental information totaling instruction for a predetermined product from an input device or another device via a communication device Identifying the parts constituting the product in the part configuration table, searching the part attribute table for the environment information of the specified parts, collecting the environment information of each part, and the part configuration by the search Predetermined environmental information on various parts on the network for parts for which environmental information is not available on the table A process for collecting the environmental information of the relevant part to the server, collecting the environmental information of the relevant part, and in the parts group from which the environmental information has been collected, a part having a plurality of parts suppliers is designated as the part attribute. The environment provided by each component supplier for the same component by searching the table and acquiring the environment information provided by each component supplier regarding the corresponding component by searching the component attribute table or by obtaining the specified server. Among the information, the logical sum of the types of chemical substances, the process of specifying the maximum value of each chemical substance, and the minimum value of the part weight, and the logical sum of parts for which there are multiple parts suppliers are obtained by the logical sum. For each chemical substance type, calculate the content rate of the corresponding chemical substance by dividing the maximum value of the content by the minimum value of the part weight, and for parts where there are no multiple parts suppliers, The content of each chemical substance indicated by the environmental information obtained in the collection is divided by the part weight to calculate the content ratio of the corresponding chemical substance, and the calculated chemical substance content ratio for each part is specified in the above aggregation instruction And a process of summing up a group of parts constituting the product and outputting the summation result to an output device.

  As the environmental information, in addition to chemical substances contained in products and the like, any of environmental load information handled in LCA (Life Cycle Assessment) and CO2 emissions generated during product manufacturing and transportation may be assumed in the same manner.

  According to the present invention, it is possible to improve the collection efficiency of environmental information related to products, and to avoid the occurrence of defects such as underreporting in the environmental information tabulation results.

It is a network block diagram including the environment information total system of this embodiment. It is a block diagram about the environmental information total system of this embodiment. It is a figure which shows the example of a data structure of the components structure table in this embodiment. It is a figure which shows the example of a data structure of the components attribute table in this embodiment. It is a flowchart which shows the process sequence of the environmental information totaling method of this embodiment. It is a figure which shows the structural information example regarding multiple company purchasing parts of this embodiment. It is a figure which shows the structural example of the virtual environment information of this embodiment. It is a figure which shows the example of an output result of this embodiment.

--- System configuration ---
Embodiments of the present invention will be described below in detail with reference to the drawings. FIG. 1 is a network configuration diagram including the environment information totaling system of this embodiment. An environmental information totaling system 100 (hereinafter, system 100) shown in FIG. 1 is a computer system that improves the efficiency of collecting environmental information about products and avoids occurrence of defects such as underreporting in the environmental information totaling result. Here, as an example, it is assumed that the environmental information aggregation system 100 of the present embodiment is applied to a so-called BtoB system that mediates business transactions between companies.

  In this case, the component supplier server 400 in the network 140 in FIG. 1 corresponds to a component supplier server device in the BtoB system, while the system 100 corresponds to a component buyer information processing device in the BtoB system. . Accordingly, the exchange of environmental information shown in the present embodiment may be executed by data communication only for collecting environmental information, or incidental to an EDI message or the like generated when processing a commercial transaction as the BtoB system described above. It is also possible to execute it. When accompanying an EDI message processing, it is possible to assume a situation in which an environmental information request message is included in a buyer's order message and an environmental information reply message is included in a supplier's order message.

  The network 140 is also connected to a production management apparatus 200 that provides storage information of the component configuration table 125 to the system 100. The production management device 200 is, for example, a CAD system that is arranged in a product development department and manages information about a designed product and its component parts, and a parts management that is arranged in a manufacturing department, a parts procurement department, etc. to manage a bill of materials. A system can be assumed. Such a production management apparatus 200 transmits the data of the parts table to the system 100 as the data of the parts configuration table 125 at a certain time zone such as at night.

  The network 140 is connected to a public server 300, which is a predetermined server that publicizes environmental information regarding various components. This public server 300 stores the environmental information of each component sent from the component supplier server 400 in its own storage means. In addition, according to the protocol of the network 140, a server function is naturally provided that extracts the corresponding environment information from the storage unit and returns it as a response in response to a request from another device that has accessed.

  The above-described production management apparatus 200, public server 300, parts supplier server 400, and the like include general hardware (CPU, volatile memory, nonvolatile storage device, input / output means, communication means) provided as a computer and necessary It is assumed that a program for realizing various functions is provided. Further, the production management apparatus 200, the public server 300, and the parts supplier server 400 may be included in the system 100.

  Subsequently, hardware and functions of the system 100 included in such a network configuration will be described. FIG. 2 is a block diagram relating to the environment information totaling system 100 of the present embodiment. As shown in FIG. 2, the system 100 includes a program 102 that realizes necessary functions in the storage device 101, and an arithmetic device 104 such as a CPU reads the program 102 from the storage device 101 to the memory 103. Will be executed. Execution of the program 102 implements functions necessary as an environmental information totaling system. Further, the system 100 includes an input device 105 such as a keyboard and a mouse that receives instructions from a buyer who is a user, and an output device 106 such as a display and a speaker that outputs processing results. Furthermore, the system 100 also includes a communication device 107 for communicating with other devices such as the production management device 200, the public server 300, and the parts supplier server 400 via the network 140. As this communication apparatus, a NIC (Network Interface Card) or the like can be assumed. The storage device 101 stores a component configuration table 125 and a component attribute table 126. Details of these tables will be described later.

  The system 100 having the above-described configuration executes the following processing by the program 102 executed by the calculation unit 104. That is, the calculation unit 104 receives an instruction to collect environmental information related to a predetermined product from another device (such as a person in charge of a buyer company connected to the network 140) via the input device 105 or the communication device 107, and the corresponding product. Are identified in the component configuration table 125, the environment information of the identified component is searched in the component attribute table 126, and the process of collecting the environment information of each component is executed.

  In addition, the computing unit 104 provides a public server 300 that is a predetermined server that publishes environmental information regarding various components on the network 140 regarding components for which environmental information is not obtained in the component configuration table 125 by the search. Then, an acquisition request for the environmental information of the relevant part is transmitted, and processing for collecting the environmental information of the relevant part is executed.

  In addition, the calculation unit 104 searches the component attribute table 126 for components having a plurality of component suppliers in the component group from which the environment information has been collected, and obtains environmental information provided by each component supplier regarding the corresponding component. The logical sum of the types of chemical substances and the content in each chemical substance between the environmental information provided by each parts supplier regarding the same part, obtained by searching the part attribute table 126 or by an acquisition request to the public server 300 The process of specifying the maximum value of the minimum value and the minimum value of the part weight is executed.

  In addition, the calculation unit 104 divides the maximum value of the content by the minimum value of the component weight for each chemical substance type obtained by the logical sum for a component having a plurality of component suppliers. Calculate the content rate of the substance, calculate the content rate of the corresponding chemical substance by dividing the content of each chemical substance indicated by the environmental information obtained in the above collection by the part weight for parts for which there are no multiple suppliers. The chemical substance content rate calculated for each part is totalized for a group of parts constituting the product designated by the totaling instruction, and processing for outputting the totaling result to the output device 106 is executed.

  When the computing device 104 can collect environmental information about the specified component from the component attribute table 126, it sends a registration date or version information request regarding the environmental information of the relevant component to the public server 300. Then, the registration date or version information is obtained, the registration time or version of the corresponding environment information in the component attribute table 126 is compared with the registration time or version of the corresponding environment information obtained from the public server 300, and the public server 300 is compared. If it is found that the corresponding environment information in is the latest, the acquisition request may be transmitted to the public server 300 to collect the environment information of the corresponding part.

  Further, the storage device 101 in the system 100 may store contact information on the network 140 related to the component supplier in the component attribute table 126, that is, the address of the component supplier server 400. In this case, the computing device 104 uses the component attribute table 126 to set the address of the component supplier server 400 as the contact information of the relevant component supplier in relation to the component for which environmental information has not been obtained by the acquisition request to the public server 300. It is preferable to specify and send an environment information acquisition request for the relevant part to the parts supplier server 400 indicated by this address, and execute a process for collecting the environmental information of the relevant part.

  Further, the arithmetic unit 104 counts the number of parts for which environmental information can be collected and the total number of end parts in the group of parts constituting the product designated by the totaling instruction, and the parts for which environmental information can be collected. Is determined to be equal to or greater than a predetermined percentage of the total number of end parts, and the weights of the parts for which environmental information can be collected are summed based on the environmental information, and the total weight obtained here is designated in the totaling instruction. It is also possible to execute processing for determining whether or not the product is equal to or greater than a predetermined ratio of the weight indicated by the environmental information. In this case, the calculation unit 104 determines that the number of parts for which environmental information can be collected by the determination is equal to or greater than a predetermined ratio of the total number of the end parts, and the combined weight is equal to or greater than a predetermined ratio of the weight of the product. If it is possible, the totaling result is output to the output device 106. In addition, when it is determined by the determination that the number of parts for which environmental information can be collected is not equal to or greater than a predetermined ratio of the total number of end parts, or the total weight is not equal to or greater than a predetermined ratio of the weight of the product, the environmental information And processing for outputting warning information indicating that the accuracy is insufficient to the output device 106 is executed.

--- Data structure example ---
Next, an example of the data structure in the database used by the system 100 of this embodiment will be described. The system 100 includes a component configuration table 125 and a component attribute table 126 in a nonvolatile storage device such as a hard disk drive that is provided by itself or that can be used via a network.

  FIG. 3 is a diagram illustrating a data configuration example of the component configuration table 125 according to the present embodiment. The part configuration table 125 is a table that hierarchically shows a parent-child relationship between parts constituting a product. As shown in FIG. 3, this part configuration table 125 includes, for example, each part of “A001”, “XX-001”, “C001” and the number of parts constituting a certain product “P001”, and the part “ Child part “D001”, “E001” and the number of parts that make up A001 ”, child part“ Y001 ”and the number of parts that make up part“ XX-001 ”, etc. ”To“ D001 ”,“ E001 ”, and“ Y001 ”at the lowest level of the hierarchy form a tree structure showing the relationship between the components. The data of the component configuration table 125 is acquired and stored by the system 100 from the production management apparatus 200, for example.

  FIG. 4 is a diagram illustrating a data configuration example of the component attribute table 126 in the present embodiment. The component attribute table 126 is a table that stores environmental information for each component, a supplier, and contact information on the network regarding the component supplier. As shown in the figure, this part attribute table 126 has, for example, environmental information (part weight, type of contained chemical substance) using a part number (provided by the supplier) as identification information for uniquely identifying a part. And the content (weight)), the part number set by the buyer regarding the corresponding part, the identification information of the part supplier, and the address of the part supplier server 400 are associated with the record.

--- Processing procedure example ---
Hereinafter, the actual procedure of the environmental information totaling method in the present embodiment will be described with reference to the drawings. Various operations corresponding to the environmental information aggregation method described below are realized by a program 102 that is read out and executed by the arithmetic unit 104 of the system 100 in the memory 103. And this program 102 is comprised from the code | cord | chord for performing the various operation | movement demonstrated below. FIG. 5 is a flowchart showing an example of a processing procedure of the environmental information totaling method in the present embodiment.

  In this case, the calculation unit 104 of the system 100 sends an environmental information aggregation instruction regarding a predetermined product from another device (such as a person in charge of a buyer company connected to the network 140) via the input device 105 or the communication device 107. Accept (s100). The information included in the aggregation instruction received here is the part number of the product or part to be aggregated.

  The calculation unit 104 performs a search in the part configuration table 125 of the storage device 101 using the part number as an aggregation target as a key, and in the hierarchical structure of the part configuration table 125, a part whose parent is the corresponding product, this part The parts are specified up to the lowest part of the hierarchical structure, that is, the end part, such as a child part whose parent is a child part and a grandchild part whose parent is this child part (s101).

  Subsequently, the computing unit 104 searches the component attribute table 126 for environmental information regarding each component identified in step s101 (s102). For parts for which environmental information can be retrieved by this retrieval (s103: OK), the corresponding environmental information is collected from the part attribute table 126 and stored as virtual parts table data in the storage device 101 or memory 103 (s104). ).

  Note that the computing device 104 may perform the following subflow when the environment information regarding the component identified in the step s101 can be collected from the component attribute table 126. In other words, the calculation unit 104 transmits a registration date / time or version information request regarding environmental information to the public server 300 using the part number of the corresponding part as a key (s200).

  On the other hand, when the public server 300 receives the information request, searches the environment information with its storage means using the part number included in the information request as a key, and if the environment information can be specified for the corresponding part, The registration date / time or version information is extracted and returned to the system 100 (s201). Therefore, the system 100 receives and acquires information on the registration date / time or version from the public server 300 and compares it with the registration time / version of the environment information related to the relevant part in the part attribute table 126 (s202).

  When the registration time or version of the public server 300 is newer, that is, the corresponding environment information in the public server 300 is found to be newer (s203: Yes), the calculation unit 104 obtains the acquisition from the public server 300. The request is transmitted to collect environmental information of the relevant part (s204). On the other hand, when the disclosure server 300 and the component attribute table 126 are the same regarding the registration time or version, or the component attribute table 126 is new, that is, the corresponding environment information in the component attribute table 126 is found to be the latest (s203: No). Then, the subflow ends.

  Here, the processing returns to step s103. On the other hand, when there is a part for which environmental information cannot be retrieved by the search in step s102 (s103: NG), the calculation unit 104 includes the part number of the corresponding part as a key to the public server 300 via the network 140. A request for obtaining environmental information is transmitted (s105). On the other hand, when the public server 300 receives the acquisition request, searches the environment information with its storage means using the part number included in the acquisition request as a key, and if the environment information can be identified for the corresponding part, The corresponding environment information is returned to the system 100, and if the environment information cannot be specified, a response indicating that there is no corresponding information is sent (s106).

  When the environment information is returned from the public server 300 (s107: OK), the calculation unit 104 of the system 100 stores the received corresponding environment information regarding the corresponding component in the component attribute table 126, and also stores the storage device 101 or the memory. The virtual parts table data in 103 is stored (s108).

  On the other hand, when a reply to the effect that there is no corresponding information is received from the public server 300 (s107: NG), the calculation unit 104 uses the part number of the corresponding part as a key to contact the relevant part supplier in the part attribute table 126. The address of the parts supplier server 400 is specified as information (s109). In addition, the calculation unit 104 transmits an environment information acquisition request including the part number of the corresponding part to the part supplier server 400 indicated by the identified address (s110).

  At this time, the parts supplier server 400 receives the acquisition request, and searches the environment information held in its own storage means using the received part number as a key (s111). If the environmental information related to the relevant part can be identified by this search, the parts supplier server 400 returns the relevant environmental information to the system 100, and if the environmental information cannot be identified, a reply that there is no relevant information. Is performed (s112).

  The arithmetic unit 104 of the system 100 receives the reply from the parts supplier server 400, and if the reply includes the environment information (s113: OK), the received environment information is used as the corresponding part in the part attribute table 126. And stored in the virtual parts table data in the storage device 101 or memory 103 (s114). On the other hand, if the reply from the component supplier server 400 indicates that there is no corresponding information (s113: NG), the computing unit 104 causes the process to transition to the next step s115 for the time being.

  Subsequently, the computing unit 104 searches the part attribute table 126 for parts having a plurality of parts suppliers in the parts group that has collected environmental information through the above processing, that is, the parts group that constitutes the product to be aggregated. (S115). This search process is, for example, a process of extracting a buyer-side part number for each part included in the part group in the part attribute table 126 and specifying a part having a common buyer-side part number. In other words, the buyer uses the same specification as the parts, but the parts supplier specifies different parts.

  If the computing unit 104 identifies a part in which a plurality of parts suppliers exist by the search in step s115 (s116: Yes), the computing unit 104 provides environmental information provided by each parts supplier regarding the identified parts. Then, a search is made in the component attribute table 126 or an acquisition request is sent to the public server 300 or the component supplier server 400 (s117). On the other hand, when the search in step s115 fails to identify a component having a plurality of component suppliers (s116: No), the arithmetic unit 104 shifts the process to step s119.

  For the environmental information (provided by each component supplier regarding the parts used as the same component on the buyer side) acquired in step s117, the calculation unit 104 determines whether the chemical substance between the environmental information of each component supplier The logical sum of the types, the maximum value of the content in each chemical substance, and the minimum value of the part weight are specified (s118).

  At this time, a specific image of the processing performed by the calculation unit 104 is illustrated in FIG. FIG. 6 is a diagram showing an example of configuration information regarding parts purchased by a plurality of companies according to the present embodiment. The calculation unit 104 combines environmental information (such as contained chemical substance information) of the parts in a hierarchical structure with respect to the parts having a plurality of parts suppliers, that is, parts purchased by a plurality of companies. In the example shown in the figure, a buyer purchases a part “YY-001” from three parts suppliers, that is, “Company A”, “Company B”, and “Company C”. 1234 ”,“ B-3456 ”, and“ C-5678 ”. Therefore, the calculation unit 104 uses “A company: A-1234”, “B company: B-3456”, “C company: C−” as subordinate parts of the buyer-side part number “YY-001” of purchased parts of a plurality of companies. "5678" is related to each other to generate a hierarchical structure. In practice, such a hierarchical structure may be created on a table secured in a memory or the like.

  Further, the calculation unit 104 obtains environmental information from the virtual parts table data for the parts “A company: A-1234”, “B company: B-3456”, and “C company: C-5678”. Extract and link to the relevant part in the hierarchical structure. In the example of the figure, regarding the component “A-1234”, information on contained chemical substances such as lead: 5 g, chromium: 3 g, zinc: 2 g, copper: 10 g, and content (weight), that is, environmental information is linked. In addition, regarding the component “B-3456”, information on contained chemical substances and content (weight) such as lead: 7 g, chromium: 2 g, cobalt: 1 g, copper: 5 g is associated. In addition, regarding the component “C-5678”, information on contained chemical substances such as lead: 4 g, antimony: 6 g, and copper: 15 g and the content (weight) are linked.

  Therefore, the calculation unit 104 extracts all types of chemical substances without omission across the parts “A company: A-1234”, “B company: B-3456”, and “C company: C-5678”. To do. In other words, the logical sum of the types of chemical substances is taken. In the example shown in the figure, lead, chromium, zinc, copper, cobalt, and antimony are the result of the logical sum. The arithmetic unit 104 temporarily stores the logical sum as a chemical substance contained in the component “YY-001” in the storage device 101 or the memory 103 (FIG. 7).

  Moreover, the calculation part 104 straddles each part of said "A company: A-1234", "B company: B-3456", and "C company: C-5678", and sets the maximum value of content regarding each chemical substance. Extract. In the example of the figure, “7 g” of “Company B: B-3456” for lead, “3 g” of “Company A: A-1234” for chromium, “A Company: A-1234” for “Zinc” "2g", "15g" of "C company: C-5678" for copper, "1g" of "B company: B-3456" for cobalt, "6g" of "C company: C-5678" for antimony Is the extraction result. The calculation unit 104 stores the extraction result in association with each chemical substance temporarily stored as the chemical substance contained in the component “YY-001”.

  In addition, the calculation unit 104 calculates the minimum value of the component weight among the components “A company: A-1234”, “B company: B-3456”, and “C company: C-5678”. B-3456 ”is specified as“ 15 g ”. The calculation unit 104 stores the minimum component weight specified here as the component weight for the component “YY-001” in which the contained chemical substances and the like are temporarily stored.

  As a result of such processing, the calculation unit 104 generates virtual environmental information (containing chemical substances and their contents) and part weight data regarding the part “YY-001” illustrated in FIG. 7.

  Subsequently, the calculation unit 104 divides the maximum value of the content by the minimum value of the weight of the component for each chemical substance type obtained by the logical sum for the parts purchased by the plurality of companies, and calculates the content rate of the corresponding chemical substance. Calculate (s119). In the case of the above-mentioned component “YY-001”, it can be calculated that “7 g / 15 g = 47%” for lead, “3 g / 15 g = 20%” for chromium, and the like. In this step, the calculation unit 104 also divides the content of each chemical substance indicated by the environmental information obtained by the collection by the weight of the part for other parts for which there are not a plurality of parts suppliers. The rate is calculated in the same way. By these calculation processes, the calculation unit 104 acquires the content rate of each contained chemical substance for the product for which the aggregation instruction has been given as the aggregation result, and stores this in the storage device 101 or the memory 103.

  In addition, the arithmetic unit 104 includes the number of parts that have collected environmental information among the parts constituting the product designated by the aggregation instruction, and the end of the group of parts constituting the product designated by the aggregation instruction. The total number of parts is counted to determine whether the number of parts for which environmental information can be collected is equal to or greater than a predetermined ratio of the total number of end parts (s120). For example, the number of parts for which environmental information can be collected is the end part For example, if it is 90% or more of the total number (s120: OK), the arithmetic unit 104 causes the process to transition to step s121. On the other hand, if the number of parts that can collect environmental information is less than 90% of the total number of end parts, for example (s120: NG), the calculation unit 104 calls attention to “the collection rate is low, so that the total accuracy is low”. A message is output from the output device 106 (s122), and the process ends.

  In step s121, the calculation unit 104 adds the weights of the parts for which environmental information can be collected based on the environmental information, and the total weight obtained here is the weight indicated by the environmental information for the product specified by the aggregation instruction. It is determined whether the ratio is equal to or greater than a predetermined ratio. If the number of parts for which environmental information can be collected by this determination is 90% or more of the total number of end parts, for example (s121: OK), the calculation unit 104 stores the summation result in the storage device 101 or memory 103. The stored information on the content rate of each contained chemical substance is read out and output to the output device 106 (s123). An output example is shown in FIG.

  On the other hand, if the number of parts for which environmental information can be collected is less than 90% of the total number of the end parts, for example (s121: NG), it indicates that the accuracy is insufficient as environmental information. Warning information such as “the total accuracy is low because no parts are collected” is output to the output device 106 (s124), and the process is terminated.

  Although the best mode for carrying out the present invention has been specifically described above, the present invention is not limited to this, and various modifications can be made without departing from the scope of the invention.

  According to this embodiment, it is possible to improve the efficiency of collecting environmental information about products, and to avoid the occurrence of defects such as underreporting in the environmental information tabulation results.

  In addition, at least the following is clarified by the description of the present specification. That is, when the computing device is able to collect environmental information regarding the identified component from the component attribute table, it sends a registration date or version information request regarding the environmental information of the relevant component to the predetermined server, and registers it. The date and version information is acquired, the registration time or version of the corresponding environment information in the part attribute table is compared with the registration time or version of the corresponding environment information obtained from the predetermined server, and the corresponding environment information in the predetermined server is the latest. If it is determined that the environmental information of the relevant part is collected by transmitting the acquisition request to the predetermined server.

  Further, in the environmental information totaling system, the storage device stores contact information on a network related to a component supplier in the component attribute table, and the computing device receives environmental information in response to an acquisition request to a predetermined server. For the parts that could not be obtained, the contact information of the relevant parts supplier is specified in the part attribute table, and the environment information acquisition request for the relevant parts is sent to the parts supplier indicated by the contact information. It is also possible to execute a process of collecting environmental information of the relevant part.

  Further, in the environmental information totaling system, the arithmetic unit counts the number of parts for which environmental information can be collected and the total number of end parts in the group of parts constituting the product designated by the totaling instruction, It is determined whether the number of parts for which information can be collected is equal to or greater than a predetermined ratio of the total number of end parts, and the weight of parts for which environmental information has been collected is added based on the environmental information, and the total weight obtained here is It is determined whether or not the weight specified by the environmental information regarding the product specified by the aggregation instruction is equal to or greater than a predetermined ratio, and the number of parts for which environmental information can be collected by the determination is equal to or greater than the predetermined ratio of the total number of the end parts, When it is determined that the combined weight is equal to or greater than a predetermined ratio of the weight of the product, the total result is output to an output device, and the number of parts for which environmental information can be collected by the determination is the total number of the end parts. Predetermined When it is determined that the total weight is not equal to or greater than the predetermined ratio of the weight of the product, the warning information indicating that the accuracy is insufficient as environmental information is output to the output device. There may be.

DESCRIPTION OF SYMBOLS 100 Environmental information totaling system 101 Storage apparatus 102 Program 103 Memory 104 Arithmetic apparatus 105 Input apparatus 106 Output apparatus 107 Communication apparatus 125 Part structure table 126 Part attribute table 140 Network 200 Production management apparatus 300 Public server (predetermined server)
400 Parts supplier server

Claims (6)

An information processing system for collecting environmental information of products,
A communication device that communicates with other devices via a network;
A storage device for storing a component configuration table indicating a parent-child relationship between components constituting the product, and a component attribute table for storing a procurement source and environment information for each component;
An instruction to collect environmental information related to a predetermined product is received from another device via an input device or a communication device, the parts constituting the corresponding product are specified in the part configuration table, and the environmental information regarding the specified part is specified as the part attribute. Search the table and collect environmental information for each part,
For a part for which environmental information is not obtained in the part configuration table by the search, a request for acquiring environmental information of the part is transmitted to a predetermined server that publishes environmental information about various parts on the network, A process of collecting environmental information for the part,
In the parts group for which environmental information is collected, a part having a plurality of parts suppliers is searched for in the part attribute table, and the environment information provided by each parts supplier regarding the corresponding part is searched for in the part attribute table. Obtain the logical sum of the types of chemical substances, the maximum content of each chemical substance, and the minimum value of the part weight among the environmental information provided by each parts supplier regarding the same parts. Process to identify,
For the parts where there are a plurality of parts suppliers, for each chemical substance type obtained by the logical OR, calculate the content rate of the corresponding chemical substance by dividing the maximum value of the content by the minimum value of the part weight, For parts that do not have multiple parts suppliers, calculate the content of each chemical substance by dividing the content of each chemical substance indicated by the environmental information obtained in the above collection by the weight of the part. An arithmetic unit that performs a process of summing up the content rate with respect to a group of parts constituting the product specified by the aggregation instruction and outputting the aggregation result to an output device;
Environmental information totaling system characterized by comprising. When the computing device is able to collect environmental information about the identified component from the component attribute table, the computing device transmits a registration date or version information request regarding the environmental information of the corresponding component to the predetermined server, and the registration date or time The version information is acquired, the registration time or version of the corresponding environment information in the component attribute table is compared with the registration time or version of the corresponding environment information obtained from the predetermined server, and the corresponding environment information in the predetermined server is the latest. If it is found, collect the environmental information of the relevant part by sending the acquisition request to the predetermined server,
The environmental information totaling system according to claim 1, wherein: The storage device stores contact information on a network related to a component supplier in the component attribute table,
The computing device specifies contact information of a corresponding component supplier in the component attribute table for a component for which environmental information has not been obtained by an acquisition request to a predetermined server, and the component supplier device indicated by the contact information To send an environment information acquisition request for the relevant part to collect the environmental information of the relevant part.
The environmental information totaling system according to claim 1, wherein: The arithmetic unit is:
Count the number of parts that have been able to collect environmental information and the total number of end parts in the group of parts that make up the product specified in the aggregation instruction, and the number of parts that have been able to collect environmental information is the total number of end parts. To determine if it is over a certain percentage of
Summing up the weights of the parts for which environmental information can be collected based on the environmental information, determining whether the total weight obtained here is equal to or greater than a predetermined percentage of the weight indicated by the environmental information for the product specified in the aggregation instruction,
If the number of parts for which environmental information can be collected by the determination is equal to or greater than a predetermined ratio of the total number of end parts, and the total weight is determined to be equal to or greater than a predetermined ratio of the weight of the product, the aggregation result To the output device,
If it is determined by the determination that the number of parts for which environmental information can be collected is not equal to or greater than a predetermined percentage of the total number of end parts, or the total weight is not equal to or greater than a predetermined ratio of the weight of the product, accuracy as environmental information It executes a process of outputting warning information indicating that it is insufficient to the output device.
The environmental information totaling system according to any one of claims 1 to 3. A storage device that stores a communication device that communicates with other devices via a network, a component configuration table that indicates a parent-child relationship between components that make up a product, and a component attribute table that stores a procurement source and environmental information for each component; , A computer comprising an arithmetic unit and counting the environmental information of products,
An instruction to collect environmental information related to a predetermined product is received from another device via an input device or a communication device, the parts constituting the corresponding product are specified in the part configuration table, and the environmental information regarding the specified part is specified as the part attribute. Search the table and collect environmental information for each part,
For a part for which environmental information is not obtained in the part configuration table by the search, a request for acquiring environmental information of the part is transmitted to a predetermined server that publishes environmental information about various parts on the network, A process of collecting environmental information for the part,
In the parts group for which environmental information is collected, a part having a plurality of parts suppliers is searched for in the part attribute table, and the environment information provided by each parts supplier regarding the corresponding part is searched for in the part attribute table. Obtain the logical sum of the types of chemical substances, the maximum content of each chemical substance, and the minimum value of the part weight among the environmental information provided by each parts supplier regarding the same parts. Process to identify,
For the parts where there are a plurality of parts suppliers, for each chemical substance type obtained by the logical OR, calculate the content rate of the corresponding chemical substance by dividing the maximum value of the content by the minimum value of the part weight, For parts that do not have multiple parts suppliers, calculate the content of each chemical substance by dividing the content of each chemical substance indicated by the environmental information obtained in the above collection by the weight of the part. The content rate is totalized with respect to the parts group constituting the product specified by the totaling instruction, and the totaling result is output to the output device; and
The environmental information totaling method characterized by performing this. A storage device that stores a communication device that communicates with other devices via a network, a component configuration table that indicates a parent-child relationship between components that make up a product, and a component attribute table that stores a procurement source and environmental information for each component; , A computer equipped with an arithmetic unit, which aggregates environmental information on products,
An instruction to collect environmental information related to a predetermined product is received from another device via an input device or a communication device, the parts constituting the corresponding product are specified in the part configuration table, and the environmental information regarding the specified part is specified as the part attribute. Search the table and collect environmental information for each part,
For a part for which environmental information is not obtained in the part configuration table by the search, a request for acquiring environmental information of the part is transmitted to a predetermined server that publishes environmental information about various parts on the network, A process of collecting environmental information for the part,
In the parts group for which environmental information is collected, a part having a plurality of parts suppliers is searched for in the part attribute table, and the environment information provided by each parts supplier regarding the corresponding part is searched for in the part attribute table. Obtain the logical sum of the types of chemical substances, the maximum content of each chemical substance, and the minimum value of the part weight among the environmental information provided by each parts supplier regarding the same parts. Process to identify,
For the parts where there are a plurality of parts suppliers, for each chemical substance type obtained by the logical OR, calculate the content rate of the corresponding chemical substance by dividing the maximum value of the content by the minimum value of the part weight, For parts that do not have multiple parts suppliers, calculate the content of each chemical substance by dividing the content of each chemical substance indicated by the environmental information obtained in the above collection by the weight of the part. The content rate is totalized with respect to the parts group constituting the product specified by the totaling instruction, and the totaling result is output to the output device; and
An environmental information aggregation program characterized by causing

Images