JP5706248B2 - Product handling standard creation system and method - Google Patents

Description

  The present invention relates to information processing technology, and in particular, to a system for managing information on products such as dispensing and molded products, information on materials and raw materials (parts), information on contained chemical substances, and the like.

  From the viewpoint of global environmental protection, as represented by the European REACH regulations, regulations on the management of chemical substances (especially harmful substances) are becoming stricter year by year. The handling standards (handling methods) of substances, materials and raw materials used as components (parts) used when manufacturing (generating) products such as preparations and molded products are determined according to the chemical substances contained. ) And danger indicators. Such information is normally managed by a survey sheet (chemical safety data sheet) called MSDS (Material Safety Data Sheet).

  However, since these pieces of information are information for each chemical substance, handling standards (handling methods) and dangers when manufacturing a product that combines multiple elements (parts) are unclear. There are many cases.

  Related to a system that supports management of information such as the above handling standards, as a prior art example, there is JP-A-2001-300500 (Patent Document 1). In Patent Document 1, information (database) such as MSDS, material composition, managed substance, physical property value, emission coefficient, and compound is managed.

JP 2001-300500 A

  In the system of the prior art (for example, Patent Document 1), individual (single unit) handling standards are used for each substance (which is a component) used in manufacturing a product (dispensing / molded product). And information such as hazards are managed and provided. However, a technology for generating and managing information on standards (handling standards, dangers, etc.) related to products configured by combinations thereof has not been disclosed or realized. Therefore, there is a problem that such a product standard requires time and cost, such as a user having to make an independent determination.

  In view of the above, the main object of the present invention is not only the management of handling standard information at the level of existing individual (single) substances, but also products configured by combining these individual (single) substances By providing a system that generates and manages information such as new handling standards to be considered in the case of (dispensing, etc.), it is possible to reduce the effort and cost of system users' judgment, and to manufacture and manage products It is to provide a technology capable of improving the safety in the above.

  In order to achieve the above object, a representative embodiment of the present invention is a system that performs processing for managing information such as products, parts, contained chemical substances, and handling standards using an information processing apparatus (product handling standard creation system). ) And a method, and the like, and having the following configuration.

  In the system of this embodiment, the information processing apparatus includes a component information management function, a product handling standard creation function, a storage unit, and a user interface unit. The user interface unit performs a process of receiving information input operation by the user and outputting information to the user. The storage unit manages management information related to products and parts in a database (DB). The component information management function performs processing for managing information in units of individual components in the storage unit based on user operations. The product handling standard creation function performs processing for managing information in units of products in the storage unit based on user operations, creating handling standard information in units of products, and managing the information in the storage unit.

  The product handling standard creation function acquires and references information for each individual component, which is a component, for the target product based on the user's operation, and compares the handling standard information for each individual part. Common information is automatically generated, handling standard information of the target product is set based on the common information, and the information is output to the user.

  According to a typical embodiment of the present invention, not only management of handling standard information at the level of existing individual substances, but also considerations in the case of products configured by combining these individual substances, etc. By providing a system that generates and manages information such as new handling standards, it is possible to reduce the time and cost of system users' judgment and improve the safety in manufacturing and managing products. it can.

It is a figure which shows the structure of the system (product handling reference | standard preparation system) of one embodiment of this invention. It is a figure which shows the processing flow of the product handling reference | standard preparation function of this Embodiment. It is a figure which shows the structural example of components information DB (12) of this Embodiment. It is a figure which shows the structural example of handling standard DB (13) of this Embodiment. It is a figure which shows the structural example of link information DB (14) of this Embodiment. It is a figure which shows the structural example of contained chemical substance information DB (15) of this Embodiment. It is a figure which shows the product structural example in this Embodiment.

  Hereinafter, based on the drawings (FIGS. 1 to 1), embodiments of the present invention (product handling standard creation system and the like) will be described in detail. Note that components having the same function are denoted by the same reference symbols throughout the drawings for describing the embodiment, and the repetitive description thereof will be omitted.

[Summary]
The system of this embodiment (FIG. 1) includes information on products (dispensing, molded products, etc.), information on individual (single) substances / materials (components) that constitute the products, and contained in the components. Information on chemical substances to be used and information on handling standards according to the chemical substances are managed, and operations such as setting and reference can be performed by the system user (U).

  In this system, handling standards set for individual parts (“child parts”) based on the management function (part information management function 21) of information on chemical substances contained in individual parts as a base (system component) Based on such information, information such as handling standards (newly generated) in the product (“parent part”) unit composed of the combination of these parts is created and managed efficiently. U) has a mechanism (product handling standard creation function 11) to be provided.

  In this system, information on the individual parts (child parts) and information on the product (parent parts) are managed simultaneously. For this reason, in this system, a part table (BOM: Bills Of Material) structure is incorporated into the information management (DB of the storage unit 2), and a part (a parent-child relation) in a product / part configuration ( Information on each parent part and child part) is managed in detail, and the versatility of common parts is ensured. The product handling standard creation function 11 creates a new handling for the upper (parent) part (product) based on the information such as the handling standard for each lower (child) part (product) and the configuration management information by the BOM. Generate reference information.

  The “parts” (“product”, etc.) in this description includes not only the field of machinery and the like but also substances and materials in various fields including chemistry. In addition, “parts” (“product” or the like) may be upper (parent) or lower (child) in a hierarchical relationship (referred to as parent parts, child parts, etc.).

[System configuration]
In FIG. 1, the example of a structure of the system of this Embodiment is shown. The system (product handling standard creation system) 10 includes an information processing apparatus 1. A system user (U) can use (operate) the information processing apparatus 1 to perform work related to reference and management of product information including product handling standard information. The information processing apparatus 1 (the present system 10) can be realized by, for example, a PC or a server. When realized by a server, the server is accessed from a user (U) terminal via a network and receives service processing by the server.

  The information processing apparatus 1 uses a known element such as a processor, a memory, a disk, a bus, a communication I / F device, an input device, an output device, and the like by executing processing of a software program (program of the present embodiment). Implement various functions (11 etc.).

  The information processing apparatus 1 includes a product handling standard creation function 11, a part information management function 21, a storage unit 2, a user I / F unit 3, and the like. The storage unit 2 includes a DB (database) such as a component information DB 12, a handling standard DB 13, a link information DB 14, and a contained chemical substance information BD15. The storage unit 2 (and 11 etc.) stores and manages the data information of each DB based on the product / part configuration management by the BOM structure. In addition, about the data information of DB, it is good also as a form which reads / writes the data information managed outside the information processing apparatus 1. FIG.

  The user I / F unit 3 provides a user interface of the system 10. The user (U) inputs information (for example, product handling standards) to the information processing apparatus 1 (handling standard creation function 11, parts information management function 21, etc.) of the system 10 via the user I / F unit 3. The information output by the system 10 is referred to. The user I / F unit 3 can be realized by a device such as an input device (keyboard, mouse, etc.), an output device (display, etc.), a communication I / F device, and the like included in the information processing device 1 and its control processing. The user I / F unit 3 may be an interface using, for example, a Web screen, and displays various types of product / part information on the screen based on the data information in the storage unit 2. For example, the user I / F unit 3 may display information such as a table of the handling standard DB 13 as illustrated in FIG. 4 on a screen viewed by the user (U) so that the user I / F unit 3 can check the information.

  The product handling standard creation function 11 or the like receives the request (input) of the user (U) through the user I / F unit 3, performs processing using the data information of the DB of the storage unit 2, and the processing result Are stored in the DB of the storage unit 2 and displayed on the screen of the output device, for example, via the user I / F unit 3. Thereby, the user (U) can refer to product handling standard information and the like.

  The component (child component) information management function 21 is a processing function for managing information on individual (single component) components (child components), including a contained chemical substance information management function. This function (21) can also be realized by applying an existing function / system or the like (known technology), and is used as a base (system component) of the system 10. Of course, 11 and 21 may be integrated into one new function. For example, the function (21) may be a function that collects and acquires external public information (for example, MSDS) and maintains the DB of the storage unit 2.

  The component (child component) information management function 21 manages information not at the parent component (product) level but at the individual (single component) component (child component) level. Information management of the level of the parent part (product) is performed by the product handling standard creation function 11 (may be collectively performed by 21). The component (child component) information management function 21 provides the user (U) with a function of reading and writing (setting) information for each individual component in the storage unit 2. Using this function (21), for example, the contained chemical substance information in units of child parts can be set in the contained chemical substance information DB 15. Further, it is possible to set attribute information for each child component in the component information DB 12. In addition, handling standard information for each child component can be set in the handling standard DB 13.

  Specifically, the product (parent part) handling standard creation function 11 includes a target product (parent part) information input unit 11A, a component (child part) information acquisition / reference unit 11B, a common information determination / generation unit 11C, and a target product ( This is a configuration having a parent part) reference information setting / output unit 11D, and the like. The processing content of each part will be described in a flow (FIG. 2) described later. In the product (parent part) handling standard creation function 11, as the main processing, the handling standard of the target product (parent part) specified by the user (U) is used while using the data information of each DB in the storage unit 2. Create (generate) information.

[Data information]
As data information (general product information (component information)) handled by the system 10, information indicated by each DB (12, 13, 14, 15) of the storage unit 2 is included. In the component information DB 12 (for example, FIG. 3), attribute information for each product / component is managed (having parent component attribute information and child component attribute information). The handling standard DB 13 (example: FIG. 4) manages handling standard information for each product / part (having parent part standard information and child part standard information). In the link information DB 14 (example: FIG. 5), based on the BOM structure, information (part structure information) including a parent-child relationship (hierarchical structure) between a product and a part (child part) that is an element constituting the product (parent part) ). In the contained chemical substance information DB 15 (example: FIG. 6), information on chemical substances contained in each part (child part) is managed (including child part-containing chemical substance information).

[processing]
The main processing contents by the product handling standard creation function 11 of the system 10 will be described with reference to FIG. S1 etc. represent processing steps. Hereinafter, in the information processing apparatus 1, the user (U) performs an operation while looking at the screen via the user I / F unit 3, and based on this, processing by the product handling reference creation function 11 is performed. As a premise, it is assumed that information (including handling standard information) is set for each individual component using the component information management function 21.

  (S1) For the system 10 (product handling standard creation function 11), the user inputs information such as designation of a target product (parent part) for which a handling standard is newly generated and instructions thereof. The target product information input unit 11A performs this input (acceptance) process (for example, the user inputs information using the items and buttons displayed on the screen, or the information from the items displayed automatically) To select information). In accordance with this input (acceptance), the processing of the product handling standard creation function 11 is executed as follows.

  (S2) The component (child component) information acquisition / reference unit 11B stores information on the component (child component) related to the target product (parent component) specified in S1 in each DB {12, 13 , 14, 15}. 11B refers to, for example, the identification information (part number) of the target product (parent part) from the part information DB 12 (for example, FIG. 3), and uses it as a key from the link information DB 14 (for example, FIG. 5). With reference to the relationship (configuration information) of the child parts, identification information (part number) and the like of the child parts (respectively) that are constituent elements of the target product are acquired. And the attribute information of a child component (each) is acquired from component information DB12 by using them as a key. 11B refers to the handling standard DB 13 (FIG. 4) and refers to the handling standard information of the unit of each of the child parts (each) registered (set) in the DB.

  (S3) The common information determination / generation unit 11C includes each item (for example, toxicity) in the handling standard information (handling standard information corresponding to the contained chemical substance) of the child parts (each) of the handling standard DB 13 (FIG. 4) of S3 above. ), Information that satisfies a logical predetermined condition (common information) is determined, and the information is generated. In the present embodiment, an AND (logical product) condition is determined as a predetermined condition and extracted as common information.

  For example, in the product configuration example of FIG. 7 (corresponding to the example of FIG. 5), the child part 1 (A002-1) and the child part 2 (A005-1) are related to the parent part 1 (A001-1) that is the target product. In addition, it has a configuration such as having child parts (A003-1, A004-1, A006-1, etc.) for each child part 1 and 2, and between the items of handling standard information of these child parts (each), By determining the AND condition, handling standard information that is common information is extracted.

  In another embodiment, as the predetermined condition, an OR (logical sum) condition in information on a child part of the target product (parent part) may be determined and information may be extracted.

  (S4) The target product (parent part) standard information setting / outputting unit 11D uses the handling standard information (common information) generated for each item of the handling standard information in the processing result of S4 as the target product (parent part). ) In the handling standard DB 13 (parent part standard information). 11D outputs (screen display) information including the parent part reference information to the user (U) via the user I / F unit 3.

  As described above, the user (U) can newly create and refer to the handling standard information of the target product by the product handling standard creation function 11. The output (screen display, etc.) is a screen that displays not only the handling standard information of the target product but also various related information such as attribute information, parent-child relationship, and contained chemical substance information based on the DB of the storage unit 2. May be displayed.

[Part information DB]
FIG. 3 shows an example of the data structure of the component information DB 12. Items (columns) managed in this table include a part number, a part name, a part type, a representative part number, a part mass, a part volume, and the like. The part number is unique identification information of the part. The part name is the name of the part. The component type is type information of the component. The representative part number is the part number of the representative part of the part. The component mass is mass information of the component. The component volume is volume information of the component.

[Handling standard DB]
FIG. 4 shows an example of the data structure of the handling standard DB 13. Items to be managed include part numbers (same as above) and information such as skin irritation, acute toxicity, handling temperature, etc. (handling standards according to contained chemical substances and information on indicators related to danger). The detailed contents of these standards (items) vary depending on the chemical substances contained.

[Link Information DB]
FIG. 5 shows an example of the data structure of the link information DB 14. Items to be managed include a part number, a parent part number, the number, and the like. The part number is the part number of the child part. The parent part number is the part number of the parent part for the child part. The number is the number of the child parts.

  FIG. 7 shows an example of the product configuration (parent-child relationship) corresponding to the example of FIG. A-001-1 (parent part 1) has A-002-1 (child part 1) and A-005-1 (parent part 2) as components. In addition, A-002-1 is the parent component as a component (subpart) A-003-1 (subpart 3) (number: 3), A-004-1 (subpart 4) (number : 2) A-005-1 has A-006-1 (child component 5) as a component (child component). Each of the child parts (for example, child parts 3, 4, and 5) has handling standards corresponding to the contained chemical substances, for example, standards a, b, and c. The reference X of the parent part 1 can be obtained by determining the AND condition from the reference a, b, c, etc. of each child part of the component of the parent part 1.

[Contained chemical substance information DB]
FIG. 6 shows an example of the data structure of the contained chemical substance information DB 15. Items to be managed include a part number (same as above), chemical substance name, content, content unit, and the like. The chemical substance name is information on the name of the chemical substance contained in the part. The content and unit are information on the content and unit of the chemical substance.

[Effects]
As described above, according to the present embodiment, not only management of handling standard information at the level of existing individual (single unit) parts by the parts information management function 11 for the user (U), Provided is a function (product handling standard creation function 11) for generating and managing information such as useful new handling standards to be considered at the level of products configured by combining these parts. As a result, the user's (U) judgment effort and cost can be reduced, and in handling, manufacturing and management of products, more rigorous management and risk reduction by grasping danger are realized. Can be improved.

  As mentioned above, the invention made by the present inventor has been specifically described based on the embodiment. However, the present invention is not limited to the embodiment, and various modifications can be made without departing from the scope of the invention. Needless to say.

  The present invention can be used for product management and production management systems.

  DESCRIPTION OF SYMBOLS 1 ... Information processing apparatus, 2 ... Memory | storage part, 3 ... User I / F part, 10 ... This system (product handling standard creation system), 11 ... Handling standard creation function, 11A ... Target product (parent part) information input part, 11B: Component (child component) information acquisition / reference unit, 11C: Common information determination / generation unit, 11D: Target product (parent component) standard information setting / output unit, 12: Component information DB, 13: Handling standard DB, 14 ... Link information DB, 15 ... Contained chemical substance information DB, 21 ... Parts (child parts) information management function.

Claims (2)

A system that performs information processing to manage information on a product, individual parts that constitute the product, and chemical substances contained in the part, using an information processing device,
The information processing apparatus has a parts information management function, a product handling standard creation function, a storage unit, and a user interface unit,
The user interface unit performs a process of receiving information input operation by a user and outputting information to the user,
The storage unit manages management information related to the products and parts in a database,
The component information management function performs processing for managing information in units of the individual components in the storage unit based on the operation of the user,
The product handling standard creation function manages information in the product unit in the storage unit based on the operation of the user, creates handling standard information in the product unit, and manages the information in the storage unit Process,
The product handling standard creation function acquires / references information for each individual component that is a component of the target product from the storage unit based on the user's operation, and handles handling standard information for each individual part. compared to automatically generate common information, have row processing for output to set the handling reference information products user the information by the common information,
The storage unit includes attribute information for each product, attribute information for each individual part, handling standard information for each product, handling standard information for each individual part, and the product and the product. Storing information including link information for managing a parent-child relationship including a hierarchical relationship with a component as an element to be performed based on a BOM structure, and information on a chemical substance contained in each individual component,
The product handling standard creation function is
A first processing unit for inputting information on the target product designated by the user;
A second processing unit that acquires and references information including handling standard information for each individual component that is a component of the target product from the storage unit;
A third processing unit that generates the common information by comparing whether or not a logical predetermined condition is satisfied by comparing items of handling standard information for each individual component;
A fourth processing unit configured to set the common information in the storage unit as handling standard information of the target product and perform processing for outputting the information to the user;
The product handling standard creation function is characterized in that the product handling standard creation function determines an AND condition as a predetermined condition for generating the common information . A method of performing information processing using an information processing device to manage information on a product, individual parts constituting the product, and chemical substances contained in the part,
In the processing of the information processing apparatus,
A processing step for setting information including handling standard information in units of individual parts in a storage unit based on a user's operation;
A processing step for accepting an information input operation by a user and inputting information of a target product for which handling standard information is to be created;
For the target product, a processing step for acquiring and referring to information for each individual component that is a component from the storage unit;
A processing step of acquiring / referring information including handling standard information for each individual component that is a component of the target product from the storage unit;
A step of generating the common information by comparing whether or not a logical predetermined condition is satisfied by comparing items of handling standard information for each individual component;
The common information is set in the storage unit as the handling reference information of products, possess a processing step of outputting the information to the user, and
The storage unit includes attribute information for each product, attribute information for each individual part, handling standard information for each product, handling standard information for each individual part, and the product and the product. Storing information including link information for managing a parent-child relationship including a hierarchical relationship with a component as an element to be performed based on a BOM structure, and information on a chemical substance contained in each individual component,
In the processing of the information processing apparatus,
A first processing step of inputting information of the target product designated by the user;
A second processing step of acquiring / referring from the storage unit information including handling standard information for each individual component that is a component of the target product;
A third processing step of generating the common information by comparing whether or not a logical predetermined condition is satisfied by comparing items of handling standard information for each individual component;
Setting the common information as handling standard information of the target product in the storage unit, and performing a process of outputting the information to the user,
In the processing of the information processing apparatus, a product handling reference creation method , wherein an AND condition is determined as a predetermined condition for generating the common information .

Images