JP2009169784A - Chemical substance management method - Google Patents

Abstract

<P>PROBLEM TO BE SOLVED: To compute the total amount of chemical substances in the whole outgoing product in a specific period of time. <P>SOLUTION: A chemical substance management system 101 stores the alteration history of composition information, which indicates the contents of chemical substances contained in products, as a version of the composition information, in a chemical substance database 100. When the composition information of new version is registered, the system compares it with a composition version set as the reference. If the difference is within a permissible range or outside the permissible range, the system stores the reference composition version for the former case or its own composition version for the latter case, as the effective composition version, in the chemical substance database 100. Further, the system computes the total amount of chemical substances, which are contained in the whole collected product in a specific period of time, by using the effective composition version. <P>COPYRIGHT: (C)2009,JPO&INPIT

Description

  The present invention relates to a technique for managing the amount of a chemical substance contained in a product. In particular, the present invention relates to a technique for summing up the total amount of chemical substances contained in the entire shipment product in a specific period.

  Conventionally, a technique disclosed in Patent Document 1 has been proposed as a technique for counting the amount of chemical substances contained in a product. Patent Document 1 describes a chemical substance counting device that can easily add up the amount of chemical substances contained in a product even if the amount of parts or materials contained in the product is changed. For this purpose, the unit content storage unit of the chemical substance totaling device stores the unit content, the product development list storage unit stores the product development list, and the product chemical substance content totalization unit includes the product development list and the unit content. It is described that the amount of chemical substances contained in the product is tabulated based on the amount data.

JP2006-202040

  However, Patent Document 1 discloses only managing the amount of chemical substances contained in parts and materials and temporarily counting the amount of chemical substances contained in products. For this reason, it is not taken into consideration how the total amount of chemical substances contained in the entire shipped product in a specific period is counted.

  For example, when the amount of a chemical substance contained in a part or material is changed, it is necessary to manage history information regarding the change. In addition, it is desirable that the total amount of chemical substances contained in the entire collected product in a specific period is estimated more quickly even if it is approximately, rather than deriving an exact amount.

  Therefore, in the present invention, the change history of the composition information indicating the content of the chemical substance contained in the product is managed as a version of the composition information. In addition, when registering a new version of composition information, compare it with the version of the composition information set in advance as a reference, and if the difference is within an allowable range, it is effective when using the reference composition version for counting chemical substances. Register as a composition version. If it is out of the allowable range, it registers its own composition version as an effective composition version. Using this active composition version, the total amount of chemical substances contained in the entire collected product in a specific period is calculated.

More specifically, a chemical substance management method for aggregating chemical substances contained in a product having a different chemical substance content for each predetermined unit, the chemical substance and the unit for each unit of the product. In a chemical substance management method using a chemical substance management system including a storage device that stores a composition information table that stores a composition information including a content rate of a chemical substance and a composition version indicating a type of the composition information in association with each other.
The chemical substance management system includes:
In the composition information table, in association with the composition information of the unit serving as a reference in the aggregation of chemical substances in the product, the reference composition information indicating that the reference is registered,
Comparing the composition information to be aggregated with the composition information in which the reference composition information is registered, calculating the difference in the content of each chemical substance,
It is determined whether each of the calculated differences is within a deviation allowable range stored in advance in the storage device,
As a result of the determination, if the deviation is within the allowable range, the composition version information of the unit in which the reference composition information is registered is associated with the composition information in the unit to be aggregated as effective composition version information. Store and
As a result of the determination, when the deviation is outside the allowable tolerance range, the composition version information of the unit to be aggregated is stored in association with the composition information in the unit to be aggregated as effective composition version information. The chemical substance management method characterized by the above is also included in the present invention. Here, the content rate is different for each unit. However, in the present invention, it is not excluded that the content rate is the same between a certain unit and another unit. The unit includes a shipment unit called a so-called lot. Furthermore, the above-described processing may be performed on items other than products (including liquids and gases).

  Further, the present invention also provides a chemical substance management method characterized in that, when the total amount of chemical substances of products shipped in a specific period is further totaled, the total quantity of chemical substances is totaled based on the effective composition version information. include.

Furthermore, the total amount of the chemical substances is
Calculate the total amount of shipment in units where the active composition version information is the same for each product,
Multiply the total amount of shipping calculated by the chemical substance content obtained from the composition information of the effective composition version information,
A chemical substance management method is also included in the present invention, in which the total amount of the chemical substance is totalized by totaling the content of the chemical substance as a result of multiplication.

  According to the present invention, the total amount of chemical substances contained in the entire collected product in a specific period can be calculated efficiently and quickly.

  Embodiments of the present invention will be described below with reference to the drawings.

FIG. 1 shows the overall configuration of a chemical substance comprehensive management system according to an embodiment of the present invention.
This comprehensive chemical substance management system can access the chemical substance database (100) from all terminals connected via a network. The chemical substance database (100) can store information on products, raw materials, and chemical substances, and can be managed in a hierarchical structure by the chemical substance management system (101). Further, the MSDS (Material Safety Data Sheet) creation support system (102) can create an MSDS using such information.

FIG. 2 shows the overall configuration of the network.
The system is connected to the intranet (200), and the users (201, 202, 203, 204, 205) are IDs and passwords issued by the system administrator (206) at terminals connected to the intranet from each base. It is possible to use in a form using a network such as accessing the system by logging in using. The chemical substance management system 101, the MSDS creation support system 102, and the terminal are each configured by a so-called computer, and although not shown, a processing device such as a CPU executes processing to be described later according to a program.

  FIG. 3 shows a database table for storing a product hierarchical structure in (a), and information that can be managed by the database table is shown in (b) as a compounding recipe (a hierarchy of raw materials and chemical substances in product manufacturing). The structure and its blending ratio) are shown, and (c) shows composition information (chemical substances contained in the product and their contents). That is, the contents of each table stored in the chemical substance database (100) are shown.

The product hierarchical structure has a product (300) as a top node, raw materials (301, 302) below it, and chemical substances (303 to 305) below it.
Regarding the way of holding the compounding prescription, in accordance with the product hierarchical structure, under the product A (306) as the top node, the raw material M1 (307), the raw material M2 (308), and further under the raw material M1, the chemical substance α (309), a form in which a chemical substance γ (311) and a chemical substance δ (312) are linked under the chemical substance β (310) and the raw material M2 is a representative example.
Regarding how to hold the composition information, under the top node product A (313), chemical substance α ′ (314), chemical substance β ′ (315), chemical substance γ ′ (316), chemical substance δ ′ ( The format associated with 317) is a representative example.

FIG. 4 shows a method for managing composition information history based on time stamps.
Specifically, FIG. 4 is a schematic diagram of (a) and a method for managing the content rate as a time stamp based on the date when the content rate was registered based on the representative example of the composition information shown in FIG. It is shown in the table image of the chemical substance database (100) of b), and the content rate (405) of the chemical substance α ′ and the chemical substance β ′ with respect to the content ratio (405 to 408) registered in 2006. The content rate of 406 (406) was updated in 2007 and represents a new value (409, 410). As for the time stamp, it is also considered to keep the time (HH: MM: SS) from the viewpoint of global correspondence. In the example, the top node to be managed is a product, but it is also possible to manage the top node as a raw material.

FIG. 5 shows a system processing flow when referring to composition information.
Specific processing contents are shown below.
The chemical substance management system (101) accepts input of a product name (601), a registration date (602), a chemical substance ID (603), and a content rate (604) as a search condition. (Example: Registration date is 2006.01.01 to 2007.12.31) (Step A1) Next, using the received search condition, search is performed with the shipping information table (900) AND condition of the shipping information management database, and the corresponding condition is met. The product search result is read from the shipping information table (900) of the shipping information management database. (Example: Product A, Product B, Product C, Product D, Product E) (Step A2) Next, it is displayed in the search result column (606). (Step A3) Next, based on the product selection (for example, product A) made by the user with respect to the result of step A3, the composition information of the selected product is stored in the composition information table (950) of the chemical substance management database. ). (Step A4) Next, composition information (616, 617, 618) corresponding to the registration date (example: 2007.08.01) designated by the user is displayed (step A5).

  FIG. 6 shows a system processing flow when newly registering composition information.

Specific processing contents are shown below.
The chemical substance management system (101) accepts input of a product name (601), a registration date (602), a chemical substance ID (603), and a content rate (604) as a search condition. (Example: Registration date is from January 01, 2006 to December 31, 2007) (Step B1) Next, using the received search condition, the shipping information table (900) in the shipping information management database is searched with the AND condition, and the corresponding The search result of the product to be read is read from the shipping information table (900) of the shipping information management database. (Example: Product A, Product B, Product C, Product D, Product E) (Step B2) Next, it is displayed in the search result column (606). (Step B3) Next, based on the product selection (for example, product A) made by the user with respect to the result of step B3, the composition information of the selected product is stored in the composition information table (950) of the chemical substance management database. ). (Step B4) Next, the composition information (616, 617, 618) input on the screen by the user is read. (Step B5) Next, the composition information is stored in the database together with the registration date (working date) (Step B6).

FIG. 7 shows a system processing flow when registering composition information.
Specific processing contents are shown below.
The chemical substance management system (101) accepts input of a product name (601), a registration date (602), a chemical substance ID (603), and a content rate (604) as a search condition. (Example: Registration date is 2006.01.01-2007.12.31) (Step C1) Next, using the received search conditions, the shipping information table (900) in the shipping information management database is searched with an AND condition, and The search result of the product to be read is read from the shipping information table (900) of the shipping information management database. (Example: Product A, Product B, Product C, Product D, Product E) (Step C2) Next, it is displayed in the search result column (606). (Step C3) Next, the composition information table (950) in the chemical substance management database is searched with the product information (for example, product A) selected by the user for the result of Step C3, and the composition information of the product as the search result. Is read from the composition information table (950) of the chemical substance management database. (Step C4) Next, composition information (616, 617, 618) corresponding to the registration date (for example, 2007.08.01) designated by the user is displayed. (Step C5) Next, the input of the result (616, 617, 618) edited from the screen with respect to the composition information displayed by the user is received. (Step C6) Next, the composition information is stored in the database together with the registration date (working date) (Step C7).

FIG. 9 shows a screen operation flow when referring to and registering composition information in FIGS.
The product search screen (600) uses the product name (601), the registration date (602), the chemical substance ID (603), and the content rate (604) as search keys for the AND condition, and the chemical substance management system (101 ) To search for products managed. The products that are found in the search process are listed on the screen, and the product (606) to be referred to, updated, or registered is selected from the composition information, and the details display button (607) is used to display the details display screen (608). It is possible to transition.

  The detail display screen (608) includes a button (609) for transitioning to a screen for displaying production shipment information, a button (610) for transition to a screen for displaying physicochemical properties, and a button for transitioning to a screen for displaying composition information ( 611), a button (612) for transitioning to a screen for creating an MSDS is arranged. Further, a button for transitioning to a screen for displaying, editing, and outputting a form of other information related to the product may be arranged.

  The composition information screen (613) is a screen that is changed by a button (611) for changing from the detailed display screen (608) to a screen for displaying composition information. By selecting any registration date from the pull-down menu (614) for selecting the registration date, it is possible to display the composition information corresponding to the registration date. The displayed composition information includes a chemical substance ID (616), a chemical substance name (617), and a content rate (618). Further, other information regarding the composition information may be included in the configuration. In the pull-down menu (614) for selecting the registration date, an item for enabling new registration of composition information by selecting it is arranged. The copy & new button (615) is capable of copying the composition information selected by pressing it and registering it as new composition information. All editing operations on this screen can be registered in the database using the update button (627).

FIG. 8 shows a system processing flow when outputting composition information by MSDS.
Specific processing contents are shown below.
The chemical substance management system (101) accepts input of a product name (601), a registration date (602), a chemical substance ID (603), and a content rate (604) as a search condition. (Example: Registration date is 2006.01.01-2007.12.31) (Step D1) Next, using the received search condition, the shipping information table (900) in the shipping information management database is searched with the AND condition, and the corresponding The search result of the product to be read is read from the shipping information table (900) of the shipping information management database. (Example: Product A, Product B, Product C, Product D, Product E) (Step D2) Next, it is displayed in the search result column (606). (Step D3) Next, the composition information table (950) of the chemical substance management database is searched with the product information (eg, product A) selected by the user for the result of Step D3, and the product composition as the search result is searched. Information is read from the composition information table (950) of the chemical substance management database. (Step D4) Next, composition information (616, 617, 618) corresponding to the registration date designated by the user is displayed. (Step D5) Next, the MSDS is calculated in the composition information (616, 617, 618) corresponding to the registration date (eg, 2007.08.01) designated by the user and the language (eg, Japanese) designated by the user. Create (step D6).

FIG. 10 shows a screen operation flow when the composition information is output by MSDS.
The MSDS creation screen (700) is a screen that is transitioned by a button (612) for transitioning from the detail display screen (608) to a screen for performing MSDS creation. The display language can be specified by selecting an arbitrary language from the pull-down menu (702) for selecting the display language of the text written in the output MSDS. By selecting any registration date from the pull-down menu (702) for selecting the registration date in which the composition information is registered as the composition information version, the composition information corresponding to the registration date is displayed. It is possible. The displayed composition information includes a chemical substance ID (703), a chemical substance name (704), and a content rate (705). Further, other information regarding the composition information may be included in the configuration. The selected composition information can be output to the MSDS by using the creation button (712).

FIG. 11 shows the structure of various database tables to be linked, and FIG. 12 shows a view table generated based on these database tables and a table for storing final aggregation results. These may be stored in the chemical substance database 100 or may be stored in a database (not shown) connected via the intranet (200) or the like.
The shipping information table (900) of the shipping information management database is not a database table included in this system, but a database table included in another system that manages shipping information of a company that introduces this system. The database table can be referred to and linked from the chemical substance management system (101).

  The composition version information table (930) and the composition information table (950) of the chemical substance database (100) are “product ID” (932) and “composition version” (933) or “active composition version” (937), This is a database table in which composition information can be version-managed for each product by concatenating (940) “product ID” (952) and “composition version” (953) as a combination key. “Product ID” (932, 952) is an ID for identifying a product for which composition information is managed, and “Composition Version” (933, 953) is for identifying a plurality of registered composition information for each product in time series. Version information, “Composition Registration Date” (934) is the date when the composition information was registered, “Chemical Substance” (954) and “Content (%)” (955) are the chemical substances contained in the product and their contents. To express.

  The “reference composition” flag (935) is a flag for designating a product having a reference blending ratio in a composition that can exist in plural for each product, and this can be designated by a user for any composition version. Shall. Note that this flag can be specified by the user for any version when registering two or more compositions for one product (eg, composition versions v01, v02, v03 for product M). (Example: v01 in product M) Further, it is possible to change to specify another composition version at an arbitrary timing.

  “Deviation” (958) represents the deviation (automatic calculation) between the content of the chemical substance and the content of the product designated by the reference composition flag, and “Deviation allowed” (959, 936) represents the “deviation”. "Represents an automatic determination result for each chemical substance and each product, whether or not" "is within the range of" deviation tolerance "(957) specified by the user. This “deviation tolerance” (957) can be set by the user for the composition version designated by the user with the “reference composition” flag (935). Further, the “effective composition version” (937) represents a table item storing either the “composition version” (933) or the composition version of the reference composition according to the value of the “deviation allowance” (936) of the product level.

  The aggregated object combination view table (970) represents a view table that is extracted by the European market distribution start date and the destination and extracts the objects to be aggregated for export volume, and the “export volume” (972) indicates the substance for each product. Represents a table item that stores the result of automatically calculating the export volume. Further, the substance unit export total amount totaling result table (980) represents a table storing the result of totaling the “export amount” (972) of the substance calculated for each product for each substance.

FIG. 13 shows a system processing flow when determining the effective composition version in FIG.
Specific processing contents are shown below.
The “product ID” (952), “composition version” (953), “content ratio” (955), “deviation allowable range” (957), “deviation” (958) are read from the composition information table (950). (Step E1) Next, the composition version whose “reference composition” flag (935) is ON is read from the composition version information table (930) for each product. As a result, the product M is v01 and the product N is v01. (Step E2) Next, the difference between each read “content ratio” (955) and the content ratio of the reference composition version is calculated for each row, that is, for each chemical substance (for example, the third row of product M For the chemical substance α of v02, 91.0-90.0 = 1.0), which is stored in “deviation” (958). (Step E3) Next, for the stored “deviation” (958), “deviation tolerance” (959, 936) is sequentially determined according to the following determination logic (step E4).

(Judgment logic 1)
"Deviation" (958) is within the range of "Deviation tolerance" (957) ⇒ "Deviation tolerance" (959) = "OK"
(Judgment logic 2)
“Deviation” (958) is outside the range of “Deviation tolerance” (957) ⇒ “Deviation tolerance” (959) = “NG”
(Judgment logic 3)
“NG” exists in “Deviation Allowed” (959) in the same “Product ID” (952) and “Composition Version” (953) ⇒ “Deviation Allowed” (936) = “NG”
(Judgment logic 4)
The same “Product ID” (952) and “Composition Version” (953) “Deviation Allowed” (959) does not contain “NG” and all are “OK”
⇒ "Allow deviation" (936) = "OK"
Here, “all” is not used, but it may be determined that deviation allowance (936) = “OK” when a predetermined number or more is “OK” or “OK” for a predetermined item.

  Next, “composition version” (933), “reference composition” (935), and “allowable deviation” (936) are read from the composition version information table (930). (Step E5) Next, “effective composition version” (937) is sequentially determined according to the following determination logic (step E6).

(Judgment logic 1)
“Standard composition” flag = ON or “Allow deviation” = “OK”
⇒ In “Active Composition Version” (937),
Search for the line where the “reference composition” flag is ON for the same product,
The value of “Composition Version” (933) is stored.
(Judgment logic 2)
“Allow deviation” = “NG”
⇒ In “Active Composition Version” (937),
Stores the value of “Composition Version” (933) in the same row.

FIG. 14 shows a system processing flow when the total export amount of the substance unit in FIGS. 11 and 12 is totaled.
Specific processing contents are shown below.
From the shipment information (900), “European market distribution start date” corresponds to the notification target year (eg, 2006), and “Destination ID” (905) retrieves the shipment lot information in Europe. As a result, lots A, C, D, E, and F are obtained. (Step F1) Next, based on the “product ID” (903) and “manufacturing date” (907) of the shipping lot of the search result, the “composition registration date” (934) is obtained from the composition version information table (930). ) Is before the “manufacturing date” (907) and there are a plurality of cases, the “effective composition version” (937) which is the latest date is searched. As a result, the lot A is v01 of the product M, the lot C is v01 of the product N, the lot D is v01 of the product N, the lot E is v01 of the product M, and the lot F is v03 of the product M. (Step F2) Next, the “chemical substance” (954) and its “content” (955) are read from the composition information table (950) under the following conditions (Step F3).

(Condition 1) Product ID (932) of the composition version information table (930);
Product ID (952) in the composition information table (950) matches.
(Condition 2) Effective composition version (937) of the composition version information table (930);
The composition version (953) of the composition information table (950) matches.

  Next, based on the information obtained by the series of search and reading processes described above, a view table (970) in which the information to be aggregated is combined is generated. (Step F4) Next, in the aggregation target combined view table (970), a line in which “product ID” (903) and “active composition version” (937) match (for example, v01 of product M is lines 1, 4, Product version v01 for rows 2 and 3, and product M v03 for rows 5) The product version unit count result table (990) that stores “product version shipment amount” (994) is generated. To do. (Step F5) Next, in the product version unit tabulation result table (990), “product version shipment amount” (994) and “content ratio” (996) are integrated (example: 20t in the chemical substance α of v01 of product M) × 90.0% = 18t) and store in “Substance shipment volume” (997). (Step F6) Next, “Substance shipment volume” (997) is tabulated in units of “Chemical substances” (954) (example: 18t + 9.2t + 18t = 45.2t for chemical substance α), and the total unit export result table for substance units (980) is generated (step F7).

System configuration diagram of an embodiment of the present invention Network configuration diagram of an embodiment of the present invention Premise data structure of the embodiment of the present invention (product hierarchical structure, how to hold a compounding recipe, how to hold composition information) Data structure of the embodiment of the present invention (history management of composition information by time stamp) Flow chart of examples of the present invention (refer to composition information) Flow chart of an embodiment of the present invention (new registration of composition information) Flow chart of an embodiment of the present invention (copy of composition information & new registration) Flow chart of embodiment of the present invention (MSDS output) Screen flow diagram of embodiment of the present invention (reference / registration) Screen flow diagram of the embodiment of the present invention (MSDS creation) Database table structure diagram (shipment information table, composition version information table, composition information table) Database table structure diagram (Aggregation target combined view table, Substance unit export totals aggregation result table) Flow chart of embodiment of the present invention (effective composition version determination) Flow chart of the embodiment of the present invention (total amount of export in substance unit)

Explanation of symbols

Chemical substance database ... 100, chemical substance management system ... 101,
MSDS creation support system ... 102, Intranet ... 200, Terminal ... 201,
Product hierarchy composition ... 300-305, how to hold the compounding prescription ... 306-312,
How to have composition information ... 313-317,
History management of composition information by time stamp ... 400-412,
Database structure of composition information: 500 to 511,
Screen name / screen item 600-627, 700-712,
Shipping information database structure ... 900-909,
Database structure of composition version information ... 930-937,
Composition information database structure ... 950-959,
Database structure of aggregation view to be combined ... 970-972,
Database structure of aggregate export results of substance units ... 980-983

Claims (3)

A chemical substance management method for aggregating chemical substances contained in a product having a different chemical substance content rate for each predetermined unit, wherein the product is determined from the chemical substance and the chemical substance content rate for each unit. In a chemical substance management method using a chemical substance management system provided with a storage device that stores a composition information table that stores the composition information and the composition version indicating the type of the composition information in association with each other,
The chemical substance management system includes:
In the composition information table, in association with the composition information of the unit serving as a reference in the aggregation of chemical substances in the product, the reference composition information indicating that the reference is registered,
Comparing the composition information to be aggregated with the composition information in which the reference composition information is registered, calculating the difference in the content of each chemical substance,
It is determined whether each of the calculated differences is within a deviation allowable range stored in advance in the storage device,
As a result of the determination, if the deviation is within the allowable range, the composition version information of the unit in which the reference composition information is registered is associated with the composition information in the unit to be aggregated as effective composition version information. Store and
As a result of the determination, when the deviation is outside the allowable tolerance range, the composition version information of the unit to be aggregated is stored in association with the composition information in the unit to be aggregated as effective composition version information. Chemical substance management method characterized by The chemical substance management method according to claim 1,
A chemical substance management method, comprising: summing up the total amount of chemical substances based on the effective composition version information when further summing up the total amount of chemical substances of products shipped in a specific period. The chemical substance management method according to claim 2,
The total amount of the chemical substances is
Calculate the total amount of shipment in units where the active composition version information is the same for each product,
Multiply the total amount of shipping calculated by the chemical substance content obtained from the composition information of the effective composition version information,
A chemical substance management method, wherein the total amount of the chemical substance is totalized by totaling the content of the chemical substance as a result of multiplication.

Images