This application claims the benefit of priority of Japanese Application No. 2004-251213 filed on Aug. 31, 2004, the disclosure of which also is entirely incorporated herein by reference.
The present invention relates to a technique for assessing an environmental impact (including a harmful effect on public health) of products and chemicals put on the market through the supply chain, and relates to an information management technique preferable for assessing the contents of environmental impact substances or environmental risks thereof.
Commercial products (e.g. chemicals) are distributed to society along the so-called supply chain. That is, the supply chain network begins from nearly pure substance products (raw materials, etc.) that are provided by substance manufacturing companies on the uppermost stream. Many companies purchase such products (raw materials, etc.), use, compound, add or arrange the purchased products as raw materials in accordance with their own manufacturing process, thereby manufacturing new products. Further, other companies use the manufactured products for wide purposes such as printing, painting, coating or achieving physicochemical functions, thereby manufacturing their products. Finally, many companies use thus manufactured products, thereby manufacturing end products (such as vehicles, electric/electronic products, construction materials, daily goods, clothes, etc.). In this manner, the supply chain is formed in a long and complicated network.
Recently, the composition, hazard and risks of various commercial products are some of the most important concerns from the social and business management points of view. In such circumstances, the European Parliament presented a proposal for a new EU regulatory framework, called REACH (Registration, Evaluation, Authorization and Restriction of Chemicals) in 2003. Based on the old ways, it is necessary to control the impact (called a hazard) of those pure chemical substances (single type of molecules or atoms) manufactured by the uppermost stream companies, on the public health or ecosystems. Unlike the old ways, according to a recent proposal, those substances are all traced along the supply chain so as to understand how these substances are used, and understand the types, contents, usage and (sold) quantity of the chemical substances included in the downstream products (e.g. TV, etc.). As a result, the degree of chemical risks are desirably estimated and controlled, collectively as a whole.
Conventionally, several systems for collecting chemical information are disclosed. A Japanese patent publication No. 3361051 discloses a technique for retrieving environmental information regarding other companies-manufactured goods necessary for manufacturing products from an environmental information database of other companies through a network communication system. Further, according to the disclosed technique, the retrieved environmental information regarding other companies manufactured goods and additional environmental information regarding the manufactured products by itself (company) are calculated according to information item, thereby generating environmental information of their own products.
Generally speaking, the environmental impact assessment has several steps: estimating an exposure quantity (of the human body and the environment) based on the usage and quantity of substances; obtaining a product of the hazard value and the exposure quantity; and assessing risks. The old way of controlling the chemical substances has nothing beyond the controlling of the hazard (controlling of the harmful effect). However, in recent years, it is aimed principally at controlling risks. To do this, it is important to prepare an information system to collect information regarding the individual product from a great number of companies within the supply chain.
According to the conventional techniques, (for instance the Japanese patent publication No. 3361061), relaying of information is assumed to be done in the direction from the upstream side to downstream side (from those companies manufacturing materials to companies manufacturing composed goods or finished products) of the supply chain. However, no consideration is given to assembling of information in the direction from the downstream side (companies manufacturing composed goods or finished products) to upstream side (companies manufacturing materials or parts). In addition, no consideration is given to information confidentiality regarding some company secret matters.
According to the present invention, the following problems should be examined and solved. The first problem aims to acquire usage and quantity (used or sold) information regarding target products. Such information cannot be acquired simply by assembling information in the direction from the upstream side of the supply chain.
The second problem is related to confidential information. Confidential information is disclosed from companies based on some restrictions regarding trade secrets. Specifically, depending on information attributes, some information cannot be disclosed to any other company, can be disclosed only to customers, can be disclosed widely to society, and disclosed in accordance with a legal duty. However, unless other companies' confidential information is used, a company's own product information (regarding component compositions, quantity information according to usage) cannot be obtained.
That is, information from other companies is necessary in order to understand through what steps those necessary materials have been made from pure substances, for what purpose company-made products are used, and in which products the company-made products are incorporated. From this point of view, generally, information should thus be acquired from other companies rather than the company's own information. In other words, important information regarding its own company-manufactured products needs to mostly be given from others. Even in such circumstances, composition information or quantity (sold products) information is the trade secrets. Such information thus cannot easily be disclosed.
The present invention aims to solve the above dilemmatic condition, by collecting confidential information into a predetermined database managed by a third party and sharing collected results.
The present invention has been made in consideration of the above, and it is accordingly an object of the present invention to realize collection and sharing of information necessary for risk assessment, while securely keeping information confidentiality.
To achieve the above first problem, it is necessary to assemble usage/quantity information in a backward direction from the downstream side along the supply chain, in addition to component/composition information composed of information in a direction from the upstream side of the supply chain. That is, relaying of information along the supply chain needs to be executed based on a new idea, (i.e. in both directions, from the upstream to downstream and then to the upstream again). The product environmental information sharing database is connected to a network for collecting information from all of the companies. In this database, a data registration processor registers raw data regarding the company's own products after being sent from other companies, in a product information memory section.
The product information memory section stores information component/composition data, hazard data, usage/quantity data representing all the products.
A forward chain processor sequentially calculates component compositions or hazard information of the substances included in the middle products or finished products, while sequentially tracing the supply chain from the uppermost data, based on various data registered from companies.
A backward chain processor calculates and records usage/quantity information of the middle products or raw material products using on the component/composition data, while sequentially tracing the supply chain in a backward direction from the lowermost stream data, based on various data registered from companies.
To achieve the second problem, a confidentiality cancellation processor executes a predetermined operation. This operation is executed based on an assumption that it is necessary to usage other companies' confidential information (secret information) for calculating predetermined product information while only a calculated (processed) result should be presented. That is, all of the companies register raw information including their confidential information. As a result, companies can acquire “calculated result” representing information of the company's own products. This calculated result is generated based on other companies' product information that cannot be acquired by themselves. This is a great advantage acquired in return for registration of product information of themselves. According to this idea, the confidentiality cancellation processor selects a disclosure range of target information based on a disclosure level defined in advance according to each product and each addressee company. In addition, the confidentiality cancellation processor limits disclosure data items based on predetermined legal request items so as to cope with disclosure requests from the companies.
The system according to the present invention can realize collection and sharing of information necessary for assessing the environmental impact risks in association with a group of products through the supply chain.
A preferred embodiment of the present invention will now be described.
In the supply chain, the raw materials are positioned in the upstream direction, while the finished products are positioned in the downstream direction. For example, for predetermined middle products, an “upstream company” is one that manufactures middle parts or raw materials necessary for manufacturing the middle products, and “upstream data” is represents such middle parts or raw materials. Further, for predetermined middle products, a “downstream company” is one that manufactures products including the predetermined middle products, and “downstream data” represents the products including the predetermined middle products.
As shown in
The product environmental information sharing database 101 includes a data registration processor 102 which receives raw data regarding the company's own products from the group of companies and carries out a process for registering data into a product information memory section 103.
The product information memory section 103 stores the component/composition data, hazard data, usage/quantity data, in association with all products on the supply chain. In the environmental impact assessment, hazardousness (inherent harmfulness of chemicals) should be estimated before everything else. Next, a hazardous substance exposure quantity of the human body and environment is estimated, based on the usage and its usage quantity. Finally, a product of the hazardousness and the exposure quantity is obtained so as to assess the risks. Information regarding the substance usage and the quantity (of sold products) necessary for risk assessment is stored in the memory unit.
Note that the exposure quantity represents a quantity of chemicals to be taken into the human body or living body through breathing, after the chemicals come out in the environment. For the chemicals having a low level of harmfulness, a high level of risk is still assessed as long as a large exposure quantity is estimated. On the contrary, for the chemicals having relatively a high level of harmfulness, a low level of risk is assessed as long as a small exposure quantity is estimated.
A forward chain processor 104 calculates and stores component compositions or hazard information regarding the substance in the middle or finished products, based on the information acquired sequentially in a direction from the uppermost stream data along the supply chain, using various data registered by companies.
A backward chain processor 105 calculates and stores usage/quantity information of middle or material products, based on the information acquired sequentially in a backward direction from the lowermost stream data along the supply chain together with the component/composition data, using various data registered by companies.
Note that such calculation methods have been described only by way of example. Instead of beginning from the uppermost stream data, the calculation may be carried out using sequentially from an N-th data from the uppermost stream data. The calculation may be carried out, based on sequentially from any data along a path between the uppermost stream data and the lowermost stream data, along the upstream or downstream of the supply chain. Further, product information may be calculated using the data on the spread route of the supply chain, or any other calculation method may be adopted.
Resultant data processed in accordance with this embodiment may be displayed on a screen and arranged in the order from the upstream to downstream direction or from the downstream to upstream direction, along the route of the supply chain. The resultant data may be displayed on a screen both in the upstream and downstream directions, in response to a display instruction from a user of this database system. Further, the resultant chemical information may be displayed in association with product information, or data calculated in accordance with any other method may be provided.
A confidentiality cancellation processor 106 selects the disclosure range of information, based on predetermined disclosure levels provided according to product and addressee company. The confidentiality cancellation processor limits disclosure data items based on predetermined legal request items so as to handle a disclosure request of each company.
Though not illustrated, each company system includes requested hardware (CPU, memory, disk, etc.) or software (OS, DBMS, Web server program, various clients programs, etc.), thus using information stored in the product environmental information sharing database 101 through reference or transmission/reception via a network, etc. Note that the product environmental information sharing database 101 represents the entire system including computers, programs, memory devices, etc. that executes the above-described processes. In addition, each of processors included in the database 101 is a program for executing data processing or information storage. Such programs may be executed either by respective computers, by a single computer controlling the entire processing or by any other method.
Referring to
For example, the table shown in the upper part of the illustration includes records regarding products of a raw material manufacturing company A. This table explains that raw data is disclosed to a direct customer, a company B, and the calculation result and disclosure information based on a legal request are disclosed to all companies. The table in the lower part of the illustration includes records regarding products of a middle product manufacturing company B, by way of example. This table explains that raw data is disclosed to a direct client, company C, the calculation result is disclosed to the direct partner, company A, and information based on legal request items disclosed to all companies. Note that the disclosure range of information defined with a high (low numerical value) disclosure level includes information of low disclosure levels. Thus, if defined as “level 1”, all information is disclosed.
Referring to
Of those substances included in a product, each substance that is used/researched by itself (company) is specified in the row of the “component substance ID” field, while each substance purchased from any other company is specified in another row for specifying its component/composition product ID. In either case, the component content of the product is specified in the “content” field.
Note that the ID system of the above component substance IDs is determined in advance, and is used for other tables in this specification as well. For example, the CAS registry number defined by Chemical Abstracts Service of the U.S. or the EINECS (European Inventory of Existing Commercial Chemical Substances) number of Europe can be used. Note that the above-described substance IDs are described only by way of example, and other identifiers can be used.
It is an important aspect that this raw component/composition data table 401 gives data defining the supply chain. The records of this table show which products is a raw material of other products. Therefore, the supply chain can be traced by referring to the records. That is, the route information of the supply chain can be obtained using the record data. It is possible to define upstream data and downstream data with respect to data of a particular substance, based on the route information of the supply chain corresponding to the referred records.
The component/composition data table 402 shows resultant data regarding substance IDs representing all components, obtained as a result of the operation of a forward chain processor 104 as will be described later. This table stores calculation results based on the supply chain, and does not include confidential information suggesting the company relations or manufacturing methods shown in the raw data table 401.
Referring to
In this embodiment, classification codes corresponding to such hazard classifications are defined, and are given as classification IDs. In the product level hazard table 502, resultant hazard information regarding products is obtained based on the component/composition data table by a process of the forward chain processor 104. This resultant calculation data is stored in the memory device.
Referring to
The exposure quantity (quantity of chemicals discharged to the environment with effects on living body) differs depending on the substance usage. The same chemical substance has different exposure quantities, for example, when used on the surface of a product, when used inside an airtight device, and when used for a device having temperature changes. Thus, it is important to make clear the usage classification in order to obtain the exposure quantity.
For example, the usage classification includes “coating”, “solvent”, “chemical synthesis material”, “addition flame retarder”, “display system material” and “coating for antirust”. Codes are given in advance for such usage classifications. As a result, it becomes obvious for what purpose a predetermined product is used and what tonnage the predetermined product is used. However, in many cases, since disclosing the above information results in disclosing the manufacturing method or manufacturing cost (particularly regarding finished products), such information is confidential and can hardly be disclosed.
The usage/quantity data table 602 stores a calculation result representing a quantity of each of all products (including any other middle products or raw material products that are not specified in the raw data table 601) according to usage. Specifically, the backward chain processor 105 operates the calculation, based on the raw data table 601 and tracing information in a backward direction from the downstream to upstream of the supply chain. As a result, the backward chain processor 105 obtains the calculation result representing the quantity of all products (according to usage) including those middle products and raw materials that are not specified in the raw data table 601. It is difficult to estimate information representing the usage and quantity information (used for the calculation) of the finished products, only with reference to the calculation result regarding a predetermined product specified in this table, thus securely keeping the information confidentiality.
The forward chain processor 104 multiplies the content of each component row copied in 802, deletes the row selected in 804, and inserts a multiplied result therein (805). That is, the component row of a component product is replaced by the component rows of plural component substances. The calculator 104 repeats this replacement (conversion), resulting in expanding from the upstream to downstream. The data table shows simply the substance compositions in the end. After this operation is ended, if a component product is still specified in the table, it means that there is a product whose substance compositions on the upstream side are not defined. Such information is stored as it is. If information is additionally registered afterwards from a manufacturing company, data regarding substance components is stored, thus clearing the remaining information.
The calculator 104 obtains a hazard value corresponding to the classification ID “β” included in the record of the product ID “α”, using the content and hazard value of each extracted component substance. Then, the calculator 104 writes the obtained value in its corresponding row of the product level hazard data table 502 (906). In particular, a product hazard is obtained based on hazard values of the component substances, using an equation suitable for the hazard classification.
For example, to obtain “mouse acute toxicity (LD50)”, products of reciprocals and their corresponding component percentages are added to each other, and further a reciprocal of the sum is calculated. For example, if substances of LD 4 mg (50%) and substances of LD 10 mg (30%) are included, 1/(0.5×¼+0.3× 1/10)=6.45 mg.
Hereinafter, this initial table is repeatedly updated, thereby generating the usage/quantity data table 602. To do this, the component/composition (raw) data table 401 is necessary. The backward chain processor 105 refers the data table 401, selects one end product (product whose product ID is not shown in any other component product ID row), and sets its product ID as “α” (1001). If this procedure has already been done for all end products, the backward chain processor 105 ends this operation (1002). If this procedure has not already been done for all end products, the backward chain processor 105 executes an operation shown in
If such a record does not exist, the backward chain processor 105 adds a new row thereinto (1104). The backward chain processor 105 reads the quantity data in association with each usage in the record, adds a result of V(β)×(quantity of product “α”) to the read quantity data, and writes the added result into each quantity data (1105). Such calculation results represent the usage and quantity of the component product “β” included in the product “α”. The backward chain processor 105 replaces “α” by “β” in order to execute such a procedure for the component of “β” (1106), and recurrently calls the same routine (1107). In this case, the recurrent call is widely executed until component expansion is performed up to the raw material product of the uppermost stream. In this manner, if such a process is completed for a predetermined component, the same process is executed for other components. Thus, in the end, the usage and quantity of all products (on the upstream side) used for the product “α” selected at the beginning in the process of
The above process will now specifically be explained with reference to
For the product P000Z1, because the quantity of the product P000Z1 for the usage “Use001” is 1 ton, the quantity of the product P000B (a component part (50%) of the product P000Z1) for the usage “Use001” is 1×0.5=0.5 ton. Similarly, the quantity of the product P000B for the usage “Use002” is 2×0.5=1.0 ton. For the product P000Z2, the quantity of the product P000Z2 for the usage “Use002” is 3 tons. The quantity of the product P000B (a component part (30%) of the product P000Z2) for the same usage is 1.9 tons for total, based on an equation of 3×0.3=0.9 ton plus the obtained 1.0 ton. By repeating such an operation, the supply chain can be traced back from the downstream side to upstream side, thereby obtaining the sum of the usage and quantity of the middle and raw material products. Note that the procedures of this backward chain calculation is based on the indicated components of finished products. Therefore, the calculation result has an error, because of the quantity of substances lost upon a chemical reaction or newly generated for some reason.
If the disclosure level is “1”, the processor 106 discloses all information regarding the target product ID from the component/composition (raw) data table 401 and the usage/quantity (raw) data table 601 (1203, 1204).
If the disclosure level is “2”, the processor 106 discloses all information regarding the target product ID from the component/composition data table 402, the usage/quantity data table 602 and the product level hazard table 502 (1205, 1206).
If the disclosure level is “3”, the processor 106 discloses information regarding the target product ID, in association with data representing a substance ID based on a legal request for disclosure from the component/composition data table 402 and data representing a classification ID legally requested for disclosure from the product level hazard table 502 (1207, 1208).
When disclosing data, substance identifiers and law titles (regulation IDs and identifiers provided for regulation) may be displayed in association with each other on a display screen. By so doing, it is obvious which data is disclosed based on what law. In combination with this display and another display based on the path of the supply chain, the user can easily know what data on which part of the supply chain to disclose based on what law.
As described above, the supply chain has a complicated form of network, because there are plural companies manufacturing raw materials and/or middle products. In some cases, the route of the supply chain may go through plural nations or plural companies. Even in such a case, confidential data of each company can be secured, and information can be disclosed based on each nation's rules.
In this manner, the system according to this embodiment collects/calculates/shares environmental information regarding plural products manufactured by plural companies, and includes a product environmental information sharing database for data transmission through data communications with the plural companies. The product environmental information sharing database includes a data registration processor, a product information memory section and a backward chain processor. The data registration processor stores data, including component composition information regarding another company's products and constituent substances as product materials and information regarding the quantity of products according to usage. Such data is received from the plural companies. The product information memory section stores all of the registered data. The backward chain processor traces the chain regarding the composition information representing component products purchased from other companies, in a direction from the finished products to the middle products whose quantity information is specified according to usage. That is, the backward chain processor trances the product supply chain in a backward direction, while calculating the information regarding the quantity of products according to usage. Further, the backward chain processor sequentially calculates information regarding the quantity of middle products and raw materials according to usage.
The system also includes the forward chain processor tracing the chain of the composition information representing component products purchased from other companies in a direction from the raw material products to the middle products whose component compositions of their constituent substances are clearly specified. By so doing, the forward chain processor traces the product supply chain in a forward direction. In addition, the forward chain processor sequentially calculates component composition information of constituent substances of raw materials up to finished products. The backward chain processor traces the product supply chain in a backward direction from the finished products to middle products whose quantity information is clearly specified according to usage, while calculating the quantity information according to usage. The backward chain processor sequentially calculates quantity information of the middle products up to raw materials according to usage.
In this embodiment, the system includes the confidentiality cancellation processor which discloses a calculated result of the calculator in response to a request for information disclosure from anther company, other than raw data registered from the company.
As a result, the system can advantageously realize collection, analysis and sharing of information necessary for assessing environmental impact risks, in association with a group of products put on the market through the complicated form of the supply chain, still in consideration of information confidentiality.
Further, the system can acquire usage and quantity information (the used quantity and the sold quantity) necessary for risk assessment. Such usage and quantity information cannot be acquired simply based on the information of the upstream side of the supply chain.
Number | Date | Country | Kind |
---|---|---|---|
2004-251213 | Aug 2004 | JP | national |