JP5568020B2 - Chemical substance management system - Google Patents

Description

  The present invention relates to a system for managing information on materials and chemical substances constituting a part together with information on a product and information on a part constituting the product.

  In recent years, various regulations regarding chemical substances have been enforced from the viewpoint of global environmental protection, and the severity of chemical substance management has been increasing year by year. In particular, the REACH regulations implemented in Europe require disclosure of the type and content of chemical substances as well as the presence or absence of hazardous substances contained in products.

  However, when there are a large number of products that must be managed and the number of parts of those products, there is a limit to manual management, and the introduction of chemical substance management systems has been promoted. Patent Document 1 classifies input part information into parts that completely match, partially match, or completely do not match information registered in the part attribute information database, and estimates input parts according to the score for part match part information. Techniques to do this are disclosed.

JP2009-238118

  If the types and number of products and components to be managed are large, the capacity of the database that the chemical substance management system should have becomes enormous, and the registration work of new parts in the database also becomes enormous. Under such circumstances, the technique disclosed in Patent Document 1 is a technique for estimating uncertain input component information, and facilitates manual management.

  However, in order to comply with various regulations concerning chemical substances, strictness is required instead of estimation, and the number of types and types of parts registered in the database inevitably increases. The increase in the number of types and types of parts is caused by the passage of years when parts and products using the parts exist in the market.

  The products and parts include series products that have the same management number for managing them, but the materials and substances constituting them and the content ratios thereof are the same. Specifically, the series products have the same type, but have different model values due to different characteristic values. In order to solve the above problem, that is, to suppress the increase in the capacity of the database, the inventor paid attention to the existence of series products.

  The disclosed chemical substance confirmation support system has the following database. They correspond to the series identifier that identifies the series product that is a group of parts of the same type that share the same calculation formula for determining the content of the chemical substance, the series name of the series product, and the chemistry of the series product. Series master database that stores formula identifiers that specify formulas for determining the content of substances, formula master database that stores formulas corresponding to formula identifiers used to determine the content of chemical substances Corresponding to the series identifier, the series management database that stores the part identifier that identifies the part included in the series product indicated by the series identifier, and contained in the part included in the series product indicated by the series identifier corresponding to the series identifier Chemical substance information database storing chemical substance names and chemical substance content rates, and parts identification Corresponding to the child, a parts information database for storing the names and part of the mass of the part indicated by the part identifier. In response to the input of registered part information for registering a new part from the input device, the contained chemical substance confirmation support system further checks whether the registered part information relates to a new series product that is not stored in the series master database. Means for determining, if the result of this determination relates to a new series product, means for determining whether or not the input formula identifier included in the registered part information is stored in the formula master database; as a result of this determination, the input formula identifier Is stored in the formula master database, a new series identifier, a new series name, and an input formula identifier for the new series product included in the registered part information are stored in the series master database. Means for storing series identifiers in the chemical substance information database Corresponding to the new series identifier, means for storing the name of the new chemical substance and the content rate of the new chemical substance contained in the registered part information, and the registered part information corresponding to the stored new series identifier Means for storing a new part identifier for identifying a new part in the series management database, and means for storing the new part identifier, the name of the new part and the mass of the new part in the part information database.

  As another desirable mode of the contained chemical substance confirmation support system, as a result of determination by means for determining whether the input calculation formula identifier is stored in the calculation formula master database, the input calculation formula identifier is not stored in the calculation formula master database. Then, it further has means for storing the new calculation formula included in the registered component information in the calculation formula master database in correspondence with the input calculation formula identifier.

  Still another desirable mode of the contained chemical substance confirmation support system is that the name of the part included in the retrieved part information and stored in the parts information database in response to the retrieved part information for retrieving the part from the input device And means for outputting the mass to the output device, means for outputting the calculation formula identifier corresponding to the series identifier included in the search part information to the output device with reference to the series master database, and containing chemical substances in the contained chemical substance information database Means for calculating the content of the chemical substance by applying the rate and the mass of the part to the calculation formula indicated by the calculation formula identifier stored in the calculation formula master database, and the calculated chemical substance content And a means for outputting to the output device in association with the name.

  ADVANTAGE OF THE INVENTION According to this invention, the increase in the capacity | capacitance of the database of a contained chemical substance management system can be suppressed.

It is a structural example of a contained chemical substance management system. It is an example of a series master database. It is an example of a series management database. It is an example of a calculation formula master database. It is an example of a variable master database. It is an example of a parts information database. It is an example of a contained chemical substance information database. It is a process flowchart of a component registration part. It is an example of a component registration screen. It is an example of a component registration screen. It is an example of a component registration screen. It is a process flowchart of a components deletion part. It is an example of a component deletion screen. It is an example of a component deletion screen. It is a process flowchart of a components search part. It is an example of a parts search screen. It is an example of a parts search screen. It is an example of a parts search screen.

  FIG. 1 shows a configuration example of the contained chemical substance management system 10. The contained chemical substance management system 10 includes a CPU 11, a memory 12, a storage device 13, an input device 14, an output device 15, a communication interface 16, and the like. The storage device 13 stores a program of the management unit 20, and the program of the management unit 20 is read into the memory 12 and executed by the CPU 11. The management unit 20 includes processing units such as a component registration unit 21, a component deletion unit 22, and a component search unit 23. These processing units are executed in response to activation by the user via the input device 14. The

  The storage device 13 stores a series master database 200, a series management database 300, a calculation formula master database 400, a variable master database 500, a parts information database 600, and a contained chemical substance information database 700 used by the management unit 20. . A work area used by the management unit 20 is secured in the memory 12 together with the program of the management unit 20.

  The input device 14 and the output device 15 only need to be able to input and output information to and from the contained chemical substance management system 10, and may be integrated devices. The communication interface 16 is used for communication with a parts purchasing system configured in another computer.

  The configuration of each database stored in the storage device 13 and used by the management unit 20 will be described. In the description, for example, information to be identified is called a number, such as a series number for identifying a series product or a part number for identifying a component, but the information to be identified is a so-called identifier.

  FIG. 2 shows an example of the series master database 200. The series master database 200 stores a series name 202 and an application calculation formula 204 for obtaining the chemical substance content of the series corresponding to the series number 201 that identifies the series. Types and management numbers that are identifiers for identifying individual parts are different, but those having the same materials and substances and their contents are called series or series products. Specifically, the series products have the same type, but have different model values due to different characteristic values. In other words, a group of parts of the same type that share a common calculation formula for determining the content of chemical substances is called a series product. Here, in order to simplify the explanation, a description will be given as one application calculation formula 204 corresponding to the series number 201. However, there are a plurality of types of chemical substances whose contents are obtained corresponding to the series number 201. When there are a plurality of applicable calculation formulas corresponding to the type of, the column of chemical substance is provided, and the applicable calculation formula is stored corresponding to the chemical substance.

  FIG. 3 shows an example of the series management database 300. The series management database 300 stores the part number 302 of the part included in the series corresponding to the series number 301. In FIG. 3, for example, the series number 301 is a series of S-001, and the part number 302 is X-01-A-1, X-01-A-2, X-01-A-3, and X-01. -Indicates that parts of A-4 are included.

  FIG. 4 shows an example of the calculation formula master database 400. The calculation formula master database 400 stores the calculation formula 402 corresponding to the calculation formula number 401 that specifies the calculation formula used by the contained chemical substance management system 10 to obtain the content of the chemical substance. The calculation formula master database 400 includes unnecessary calculation formulas, but does not extremely increase the capacity. Therefore, the calculation formula master database 400 is not used at present, but has been used in the past or may be used in the future. An expression may be included.

  FIG. 5 shows an example of the variable master database 500. The variable master database 500 stores the definitions of variables used in the calculation formula 402 stored in the calculation formula master database 400. The variable master database 500 stores a variable number 501, a variable 502, a variable name 503, and a variable unit 504 that identify each variable in association with each other.

  The definition of the variable in the variable master database 500 is applied to the calculation formula 402 in the calculation formula master database 400 specified by the application calculation formula 204 in the series master database 200 to determine the chemical substance content. For example, the calculation formula 402 whose calculation formula number 401 is default is PM * (C / 100) = (part mass) * (substance content / 100) g. As seen in the calculation formula master database 400 and the variable master database 500, the more the same variable 502 is used in a plurality of calculation formulas 402, the larger the capacity of the variable master database 500 can be prevented.

  FIG. 6 shows an example of the component information database 600. The part information database 600 stores a part number 601 that identifies each part, a part name 602, and a part mass 603. In general, in the parts information database 600, attribute information such as price and size input from a purchasing system or the like is also stored in association with the part number 601 but is omitted here.

  FIG. 7 shows an example of the contained chemical substance information database 700. The contained chemical substance information database 700 stores a series number 701, a chemical substance name 702 contained in a part of the series number 701, and a content rate 703 of the chemical substance. Since the contained chemical substance information database 700 in FIG. 7 has records corresponding to the series number 701, the number of series is less than the number of parts (number of records) registered in the parts information database 600. The capacity of the database 700 can be reduced. In addition, when a new series product is to be managed, it is necessary to newly register it in the contained chemical substance information database 700. However, a new part included in a series product already registered in the contained chemical substance information database 700 must be registered. In the case of management, registration in the contained chemical substance information database 700 is not necessary.

  Each process of the component registration unit 21, the component deletion unit 22, and the component search unit 23 included in the management unit 20 will be described.

  FIG. 8 shows a processing flowchart of the component registration unit 21. Information on the parts to be registered is input (step 800). FIG. 9A shows an example screen 900 that is output for inputting component information. Items to be input as the part information are a series name 905, a part name 910, a part number 915, and a part mass 920 of the part to be registered.

  In order to facilitate the input of the series name 905, a series list 950 which is the contents of the series master database 200 is displayed. When inputting the part information included in the series already registered in the contained chemical substance management system 10, the user outputs the series name 905 as shown in FIG. 9B by selecting the corresponding line in the series list 950. To do. When inputting part information of a new series, the user inputs a new series name in the series name 905.

  In response to the input of the series name 905, the part registration unit 21 refers to the series management database 300 and adds the part name 602 and the part mass 603 of the part information database 600 to the list of part numbers 302 of the input series. The corresponding list 960 is output. At this time, the part number 915 attached to the part to which the part information is input is output.

  In the example shown in FIG. 9B, since the part numbers of the resistor 01 series are used up to X-01-A-4 as can be seen from the list 960, the part number 915 assigned to the part to which the part information is input. Indicates X-01-A-5.

  When the user changes the contents output to the part number 915 or the part registered by the part deleting unit 22 described later is deleted, a missing number is generated. In such a case, the missing number may be added to the part number 915 attached to the part for which the part information is input, or the part number next to the last registered part number may be attached.

  The user inputs a part name 910 and a part mass 920 on the part registration screen 900 shown in FIG. 9B.

  When a new series name is input, the list 960 shown in FIG. 9B is not output. An example in which a new series name is input is shown in FIG. 9C. The user inputs the part name 910, the part number 915, the part mass 920, the application calculation formula 925, and the chemical substance contained in the part and its content 930 after the series name 905 is input.

  The application calculation formula 925 outputs a list 970 of application calculation formulas stored in the calculation formula master database 400 and allows the user to select and input. In the case of a new calculation formula, the user inputs the calculation formula into the application calculation formula 925. When a new calculation formula is input, the definition of the variable used in the calculation formula is input. In this case, a list display referring to the variable master database 500 or a user is allowed to select and input, but the description is omitted because it is similar to the input method of the other items described above.

  Returning to FIG. It is determined whether the input component information relates to a new series not stored in the series master database 200 (step 805). If it is not new, that is, if it is the part information of the series stored in the series master database 200, the process branches to step 830.

  If it is the part information regarding the new series, it is determined whether or not the input application formula 925 is in the formula master database 400 (step 810). This determination is equivalent to determining whether the selection is input from the adaptive calculation formula list 970 or the input calculation formula 925 in the example of the component registration screen 900 illustrated in FIG. 9C. If it is not a new calculation formula, the process branches to step 820.

  If the calculation formula is a new calculation formula, the calculation formula input to the application calculation formula 925 of the part registration screen 900 is stored in the calculation formula master database 400 as a new calculation formula number 401 and a new variable is used. For example, a new variable 502, a variable name 503, and a unit 504 of the variable are stored in the variable master database 500 in association with the new variable number 501.

  In the series master database 200, the inputted series name 905 is stored as the series name 202, and the inputted application calculation formula 925 is stored as the application calculation formula 203 together with the series number 201 corresponding to them (step 820). Further, the same series number as the new series number 201 is stored in the series number 301 of the series management database 300. At the same time, the part number 915 on the part registration screen 900 may be input to the part number 302, but is overwritten in step 830 described later.

  The same series number as the new series number 201 stored in the series master database 200 is stored as the series number 701 in the contained chemical substance information database 700. Correspondingly, the chemical substances included in the input parts and their content ratios are stored. 930 is stored as the chemical substance name 702 and the content rate 703 (step 825).

  The entered part number 915 is stored in the part number 302 of the series management database 300, and the entered part number 915 and part name 910 are entered in the part number 601, part name 602, and part mass 603 of the part information database 600. And the component mass 920 are stored (step 830).

  As described above, when the processing of the part registration unit 21 is executed, it is possible to minimize the re-store of information already stored in each database of the contained chemical substance management system 10 and prevent an increase in the capacity of the entire database. it can.

  FIG. 10 shows a processing flowchart of the component deletion unit 22. Information on the parts to be deleted is input (step 1000). FIG. 11A shows a screen example 1100 output for inputting component information. Items to be input as the component information are a series name 1105, a component name 1110, and a component number 1115 of the component to be deleted. Either one of the part name 1110 and the part number 1115 may be input, but both items can be input for ease of user input. Since the method of inputting the component information of the component to be deleted is similar to the above-described component registration, it will be described briefly.

  In order to facilitate the input of the series name 1105, a series list 1130 which is the contents of the series master database 200 is displayed. The user selects a corresponding row in the series list 1130 (a row having a series number or series name including a part to be deleted), thereby outputting a series name 1105 as shown in FIG. 11B.

  In response to the input of the series name 1105, the part deletion unit 22 refers to the series management database 300 and adds the part name 602 and the part mass 603 of the part information database 600 to the list of part numbers 302 of the input series. The corresponding list 1140 is output. The part name 602 and the part mass 603 do not need to be included in the list 1140, but in order to avoid an erroneous input (deletion of part information that should not be deleted) by a user who viewed the list output of only the part number, the part to be deleted The amount of information for selecting is increased.

  The user inputs a part name 1110 or a part number 1115 on the part deletion screen 1100 shown in FIG. 11B. In this input, a part name 1110 and a part number 1115 are output for the part selected by the selection input from the list 1140.

  Returning to FIG. The entered component information is deleted from the component information database 600 and the series management database 300 (step 1005). Specifically, the records of the part information database 600 and the series management database 300 corresponding to the input part number 1115 are deleted.

  It is determined whether there is part information of parts other than the deleted part information in the same series (step 1010). Specifically, it is determined by referring to the series management database 300 whether there is a part number 302 included in the series number 301 of the input series name 1105. If it exists, the process of the component deletion part 22 is complete | finished.

  If not, the record corresponding to the input series number 1105 (series numbers 201 and 701 match) is deleted from the series master database 200 and the contained chemical substance information database 700 (step 1015). The process of the component deletion unit 22 is finished.

  In the processing of the component deletion unit 22, the contents of the calculation formula master database 400 and the variable master database 500 are not deleted even if they can be deleted. This is because the input of calculation formulas and variable definitions is more complicated than general character string input, so the complexity of re-input and the increased capacity of the entire database as described above are small. by.

  The contained chemical substance management system 10 not only manages the chemical substances contained in the parts constituting the product to be put on the market, but also contains the chemicals contained in the parts constituting the product already on the market. Since the substance must also be managed, it is generally possible to avoid executing the processing of the component deletion unit 22 unless it can be confirmed that there is no managed component in the market.

  FIG. 12 shows a processing flowchart of the component search unit 23. The component search unit 23 executes a process for outputting the content of chemical substances in the input component. Information on the parts to be searched is input (step 1200). FIG. 13A shows an example of a screen 1300 output for inputting component information. Items input as the component information are a series name 1305, a component name 1310, and a component number 1315 of the component to be searched. Either one of the part name 1310 and the part number 1315 may be input. However, in the same manner as the processing of the part deleting unit 22, both items can be input for ease of user input. Yes. The method of inputting the component information of the component to be searched is similar to the above-described component registration and component deletion, and will be described briefly.

  In order to facilitate the input of the series name 1305, a series list 1350 that is the contents of the series master database 200 is displayed. The user outputs a series name 1305 as shown in FIG. 13B by selecting a corresponding row in the series list 1350 (a row having a series number or series name including a part to be searched).

  In response to the input of the series name 1305, the part search unit 23 refers to the series management database 300 and adds the part name 602 and the part mass 603 of the part information database 600 to the list of the part numbers 302 of the input series. The corresponding list 1360 is output. It is not necessary to include the part name 602 and the part mass 603 in the list 1140, but in order to avoid an erroneous input (search for part information that does not need to be searched) by a user who sees the list output of only the part number, the part to be searched The amount of information for selecting is increased.

  The user inputs a part name 1110 or a part number 1115 on the part search screen 1300 shown in FIG. 13B. In this input, a part name 1110 and a part number 1115 are output for the part selected by the selection input from the list 1140. In response to the selection input of the part name 1110 or the part number 1115, the contents of the part information database 600 are output (step 1205). Here, as shown in FIG. 13B, this is equivalent to outputting the corresponding component mass of the list 1360 as the component mass 1320. As described above, since various attribute information is generally stored in the component information database 600, the attribute information is also output in such a case.

  With reference to the series master database 200, the application calculation formula 203 corresponding to the series name 1305 is output to the application calculation formula 1325 as shown in FIG. 13C (step 1210).

  With reference to the calculation formula master database 400, the variable master database 500, and the contained chemical substance information database 700, the chemical substance content is calculated (step 1215). Specifically, the series number 201 corresponding to the series name 1305 is acquired from the series master database 200, and the chemical substance name 702 and the content rate 703 of the series number 701 corresponding to the series number 201 are obtained. The chemical substance name 702 is output to the chemical substance name column of the chemical substance 1330 as shown in FIG. 13C.

  On the other hand, the calculation formula 402 of the calculation formula number 401 corresponding to the application calculation formula 1325 is PM * (C / 100) = (part mass) * (substance content / 100) g. Substituting 703, the content of the chemical substance is calculated. The calculation of the content is executed for each chemical substance stored in the contained chemical substance information database 700 corresponding to the series number 701 indicating the series name 1305.

  The calculated chemical substance content is displayed in association with the chemical substance name of the chemical substance 1330 as shown in FIG. 13C. In FIG. 13C, the content rate is also displayed together with the content.

  By executing the processing of the component search unit 23 described above, the user can easily obtain the chemical substance content of the desired component.

  According to the present embodiment, the increase in the capacity of the database of the contained chemical substance management system can be suppressed by paying attention to the presence of materials and substances constituting the parts and series products having the same content rate.

  10: contained chemical substance management system, 11: CPU, 12: memory, 13: storage device, 14: input device, 15: output device, 16: communication interface, 20: management unit, 21: component registration unit, 22: Component deletion unit, 23: component search unit, 200: series master database, 300: series management database, 400: calculation formula master database, 500: variable master database, 600: component information database, 700: contained chemical substance information database.

Claims (3)

The series name of the series product and the chemistry of the series product corresponding to the series identifier that identifies the series product that is a group of parts of the same type that share the same calculation formula for determining the content of the chemical substance A series master database for storing a formula identifier for specifying the formula for obtaining the content of the substance,
A calculation formula master database that stores the calculation formula corresponding to the calculation formula identifier used for obtaining the content of the chemical substance,
Corresponding to the series identifier, a series management database that stores a part identifier that identifies a part included in the series product indicated by the series identifier,
Corresponding to the series identifier, a contained chemical substance information database storing the name of the chemical substance contained in the part included in the series product indicated by the series identifier and the content rate of the chemical substance,
Corresponding to the component identifier, a component information database that stores the name of the component indicated by the component identifier and the mass of the component;
Means for determining whether the registered part information relates to a new series product not stored in the series master database in response to an input of registered part information for registering a new part from the input device;
As a result of the determination, if it relates to the new series product, means for determining whether the input calculation formula identifier included in the registered part information is stored in the calculation formula master database;
As a result of the determination, if the input calculation formula identifier is stored in the calculation formula master database, a new series identifier, a new series name, and an input calculation formula identifier of the new series product included in the registered part information Means for storing in the series master database,
Means for storing the new series identifier in the series management database;
Means for storing the name of the new chemical substance contained in the new part and the content rate of the new chemical substance in the registered part information in association with the new series identifier in the contained chemical substance information database;
Means for storing in the series management database a new part identifier for identifying the new part included in the registered part information in correspondence with the stored new series identifier;
A contained chemical substance management system comprising means for storing the new part identifier, the name of the new part, and the mass of the new part in the part information database. As a result of the determination by the means for determining whether the input calculation formula identifier is stored in the calculation formula master database, if the input calculation formula identifier is not stored in the calculation formula master database, the input calculation formula identifier Correspondingly, the content chemical substance management system according to claim 1, further comprising means for storing a new calculation formula included in the registered part information in the calculation formula master database. In response to search part information for searching for the part from the input device, the name of the part and the mass of the part contained in the search part information and stored in the part information database are output to the output device. Means for outputting,
Means for referring to the series master database and outputting the calculation formula identifier corresponding to the series identifier included in the search component information to the output device;
Applying the content of the chemical substance in the contained chemical substance information database and the mass of the part to the calculation formula indicated by the calculation formula identifier stored in the calculation formula master database, the content of the chemical substance is determined. Means for calculating, and
The contained chemical substance management system according to claim 2, further comprising means for outputting the calculated content of the chemical substance to the output device in association with the name of the chemical substance.

Images