JP2018055329A - Manufacturing management system - Google Patents

Abstract

PROBLEM TO BE SOLVED: To improve workability by connecting to a server through a network between clients for respective works and by exchanging mutual information about manufacture.SOLUTION: In a manufacturing management system, also referred to as an IoT-based manufacturing management system, which uses, as clients, an acceptance management apparatus for connecting sensor devices, a measurement management apparatus, and an input management apparatus and comprises a server installed in a network superordinate, the server has a task execution server and a database, receives an event notice transmitted from a management device of each client, and transmits mutual information to related other management devices.SELECTED DRAWING: Figure 1

Description

  The present invention relates to a manufacturing management system for supporting a work of receiving raw materials, a work of measuring the amount thereof, a work of charging a preparation, and the like in a manufacturing process of a product.

In general, various industrial products such as foods and medicines are manufactured by measuring various kinds of raw materials by a necessary amount and blending the measured raw materials. 2. Description of the Related Art In recent years, a manufacturing execution system (MES: Manufacturing Execution System) is used as a system for supporting manufacturing in manufacturing factories that manufacture industrial products. For example, in a measurement process for measuring raw materials in a manufacturing process of industrial products, a measurement management device is used as a manufacturing execution system.

  This management device is a device for managing work such as weighing by an operator. For example, the management device is prepared in advance so that an operator measures a specified raw material by an amount within a specified allowable range. This is a device that displays measurement support information on a monitor and records measurement results based on a prescription master. Here, the prescription master refers to items of raw materials (hereinafter referred to as “basic raw materials”) designated as raw materials to be used in the manufacture of the intended industrial product, measurement target values of basic raw materials, and basic raw materials. This is data in which information such as weighing procedures and blending procedures is registered. Based on this prescription master, the measurement management device displays the name of the raw material to be measured on the monitor, and performs a determination process such as whether the raw material to be measured is correctly measured.

  2. Description of the Related Art As a manufacturing execution system represented by the above-described measurement management apparatus, there is known a system that has functions for preventing work mistakes by an operator and realizing traceability. For example, Patent Document 1 discloses a subdivision input management system that automatically manages a subdivision operation of raw materials and a confirmation operation in the input operation in order to prevent mistakes by an operator.

  On the other hand, in the invention of Patent Document 2, the efficiency of the weighing work when an alternative raw material is used is improved. The weighing management device determines whether or not the identification information of the raw material to be measured matches the identification information of the basic raw material to be weighed, and when the identification information of the raw material to be measured matches the identification information of the basic raw material. Displays the weighing support information that permits the weighing work of the raw material to be weighed, and prohibits the weighing work under the prescribed condition if the identification information of the raw material to be weighed does not match the identification information of the basic raw material. A technique for displaying the weighing support information to be shown is shown.

JP 2001-120193 A Japanese Patent Laying-Open No. 2006-153742

The invention of Patent Document 1 is a weighing operation using a conventional measurement management device, and when there is a change in preparation of raw materials, weighing, etc., the prescription master is quickly changed or a new prescription master is created. In particular, the old technology based on bar code labels has a problem that rework occurs and work efficiency is poor.

  Although the invention of Patent Document 2 aims to improve work efficiency by specializing in such a measurement management device, it does not measure the cooperation with the charging work or the input work as other subsystems. Therefore, until the realization of flexible work in the field, such as checking the stock of raw materials and materials to be input in the preparation process, which is the previous stage, at the weighing site and responding to work changes such as immediate input of weighing could not.

The invention of the present application is a system that can handle various changes of collation any number of times anywhere, without requiring special devices such as conventional exit instructions and transport management, so that it can cope with urgent input instruction changes at a predetermined site. The purpose is to build. According to the recent technical trend, the realization of a manufacturing management system based on the Internet (IoT: Internet Of Things) is an issue.

The present invention relates to a manufacturing management system including a server connected to a database related to manufacturing information, with at least two management devices among the acceptance management device, the weighing management device, and the input management device connected to the sensor devices as clients. In
The server receives the event notification transmitted from one management device, and updates the database so that the other management device browses and confirms the manufacturing information related to the event. It is.

  In addition, the server enables a general inspection of information from the management device by publishing a list / detailed display of instructions and actual values to the management device based on the database. It is a manufacturing management system.

Further, the database is a manufacturing management system that reports manufacturing results as time-series result data in order to accumulate the status of the sensor device in time series.

  According to the present invention, in a work management apparatus distributed as a client, manufacturing work information can be confirmed at any time by appropriate screen display using information obtained from a server. That is, even when a change work is performed due to a factor of a certain workplace, information can be communicated with the server each time, and the work efficiency and reliability can be improved in cooperation with other work management devices. .

It is a figure which shows the whole structure of the manufacturing management system of this invention. It is a figure which shows schematic structure of the database in embodiment of this invention. It is a figure which shows the transaction of the communication between client / servers in 1st Example of this invention. It is a figure which shows the transaction of the communication between client / servers in 2nd Example of this invention. It is a figure which shows the transaction of the communication between client / servers in 3rd Example of this invention. It is an internal block diagram of the measurement management apparatus (client) 20 concerning one Example of this invention. It is an internal block diagram of the server 100 common to the Example of this invention.

Hereinafter, an embodiment of the present invention will be described with reference to FIG. FIG. 1 shows the overall configuration of the manufacturing management system of the present invention.
Each workplace is roughly divided into three according to the nature, and the management devices are distributed. First, reference numeral 10 denotes an acceptance management device which is related to acceptance work and is located at a place called a cargo handling area. Reference numeral 20 denotes a weighing management device located at a weighing place where raw materials are measured. Reference numeral 30 denotes an input management device located in an input area where raw materials are mixed and packaged. These are clients for the client / server configuration of the configuration of the present invention. A tag reader / writer (11, 21, 31), a measuring instrument (12, 22, 32), and other sensor devices are connected to the lower level of each management device as necessary.

  Each client, which is a management device, is connected by Ethernet (registered trademark) 90, and a gateway 91 like a switch hub is provided there. Then, it is connected to the upper network and connected to the server 100. The server is equipped with a storage disk 200 having a predetermined capacity for the database. The server may be standalone, but rather cloud computing.

  Now, a schematic configuration of the database in the embodiment of the present invention will be described with reference to FIG. The data shown here is collectively referred to as a database in the present application. First, manufacture is performed according to the prescription master 111, and is identified by its lot ID. In addition, the arrow in this figure means the link relationship between databases.

Next, the case where the lot ID is 01 is taken as an example. The lot information 112 is viewed. Where,
―List of raw materials 1 and 2
-As a recipe, the procedure for prescribing the blending method,
-As information from the sensor device, information such as the amount received, the amount charged, and the inlet is specified. This is information on the production order.

  The lot information 112 is linked to the sensor history data 120. The data transition of stock raw materials 1 and 2, the data transition of charged raw materials 1 and 2, and the statuses of input ports A and B are stored there. The time stamp (TimeStamp) is appropriately marked with an interval or time when an event occurs. For example, the value of TimeStamp0 is the latest value. These records are accumulated by the query addition function to the database.

  Further, from the lot information 112, the order file 130 for the production is stored as a database by the server 100. The order file 130 can be viewed or modified by the client at any time. Similarly, a performance document File 140 is created based on the sensor history data 120. Note that these files are easy to become familiar with a database when described in a meta language (XML) which is a Web technology. A style sheet is appropriately prepared for display and can be displayed on the client browser. The above data group is generically called a database.

  In this example, as shown in FIG. 3, a description will be given of a mutual cooperation transaction between the execution step S10 from the acceptance management apparatus 10, the execution step S100 of the server 100, and the execution step S110 of the database manager (DBMS). In this example, it is confirmed whether or not the necessary raw materials are prepared for the actual input operation at the input site.

 First, an event that a raw material was received from the acceptance management device 10 by a truck or the like occurred (step S11, the same applies hereinafter). Then, the acceptance management device 10 transmits a message to that effect to the server 100 (S12). The identification of the material type may be performed by reading an IC tag, a barcode attached to a material bag or the like, or a key input of the material identification code.

  Since the server 100 increases the stock material due to arrival, the server 100 executes database query processing for that purpose (S101), and the query communication is indicated by S102. Specifically, it is performed in accordance with the SQL definition and can be designed in various ways, but here, the data of the stock material in the sensor history data 120 is searched and the process of updating it is performed.

  The stock quantity is updated (increased) by the DBMS 110 (S111). A completion notification to that effect is returned (S112). Receiving this, the server 100 performs a process of updating the inventory table (corresponding to the record book File 140 shown in FIG. 2) (S103). The table itself is also stored in the storage disk 200.

  Then, if the acceptance management device 10 receives the completion notification (S104), it can check the inventory table display related to the results (S13). However, this is not different from a stand-alone acceptance management device. However, when the weighing management device 20 of another client appears here, the feature of the present invention is shown.

The measurement management device 20 arbitrarily executes step S20. There, an inventory inquiry is made (S21). Therefore, the server 100 communicates with the server 100 (S22), and further communication is performed between the server 100 and the DBMS 110, and the measurement management device 20 can check the stock on its own screen.

  By doing in this way, even if there is a stock arrival from the acceptance management device 10, the measurement management device 20 can check and process the stock of the raw material and, if necessary, the stock amount of the alternative raw material. become.

  In the following example, as shown in FIG. 4, the mutual cooperation transaction between the execution step S20 from the measurement management device 20, the execution step S100 of the server 100, and the execution step S110 of the database manager (DBMS) will be described. In this example, an immediate loading operation is instructed in the weighing station, and the labor for printing a conventional barcode label or the like is saved, and the operation is quickly performed.

 First, a predetermined raw material measurement event occurred from the measurement management device 20 (step S21). Then, the measurement management device 20 transmits a message to that effect to the server 100 (S22). The identification of the raw material is as described above.

  The server 100 executes a database query process for preparing the measured raw material preparation (S101), and the query communication is indicated by S102. Specifically, it is performed by a process of retrieving and updating the raw material data.

  The DBMS 110 updates (increases) the charged raw materials (S111). On the other hand, the raw material is subtracted from the stock quantity, and a completion notice to that effect is returned (S112). Receiving this, the server 100 performs a process of updating the instruction table (corresponding to the instruction file 130 shown in FIG. 2) (S103). The table itself is stored in the storage disk 200.

  Then, when receiving the completion notification (S104), the weighing management device 20 can confirm the instruction table and be ready to start the input (S23). Then, another client input management device 30 appears here.

The input management device 30 arbitrarily executes step S30. There, the execution of the instruction is confirmed (S31). For this purpose, communication is performed with the server 100, and updates are performed between the server 100 and the DBMS 110, and the input management device 20 can execute input on its own screen.

  By doing in this way, it becomes possible for the input management device 30 to immediately input the measured materials that have been procured on-site as appropriate, without recreating a new order.

  In this example, as shown in FIG. 5, a description will be given of a mutual cooperation transaction between the execution step S30 from the input management device 30, the execution step S100 of the server 100, and the execution step S110 of the database manager (DBMS). In this example, it is assumed that there are a plurality of input ports of the input pot 33, particularly for normal weighing to input operations. It is an example which shows expansion of a sensor structure.

 First, a predetermined raw material input was requested from the input management device 30 (step S31). Then, the input management device 30 transmits a message to that effect to the server 100 (S32). The identification of the raw material is as described above.

  The server 100 executes a database query process for preparing to input the raw material (S101). Query communication is indicated by S102. Specifically, the process is performed by retrieving and updating the raw material data, but it is necessary to check whether the work is appropriate in relation to the inlet.

  The DBMS 110 reads the input raw material data (S111). A completion notification to that effect is returned (S112). Receiving this, the server 100 checks the lot information 112 and the sensor history data 120 and performs a process of checking whether the main input corresponds to the correct raw material and the input port (S103). A response of OK or NG is returned (S104).

  Then, when the input management device 30 receives the result OK notification (S104), the input management device 30 starts input into a desired input port (S33). In the case of NG, an error is notified as appropriate. Then, another client's measurement management device 20 appears here.

The measurement management device 20 arbitrarily executes step S20. There, the result is confirmed (S21). For this purpose, communication is performed with the server 100, and updates are further performed between the server 100 and the DBMS 110, and the measurement management device 20 can confirm the results of the main input operation on its own screen.

  As described above, it is complicated to execute a predetermined recipe by inputting a plurality of raw materials from an appropriate input port. Conventionally, it is complicated to prepare a plurality of instructions, but only increases the data items of the input port. Thus, it is easy to perform in the manufacturing management system. The addition of such data items is an advantage of the database configuration.

<Other implementation explanation>
Next, the functional configuration will be described in both the client and the server. First, in FIG. 6, an internal configuration of the client (measurement management device) 20 is described. The device may be a PC or a tablet computer.

  The I / O interface unit 24 that communicates with the tag reader / writer 21 and the measuring instrument 22 is connected to the central processing unit 23 and communicates information of the sensor device.

  The central processing unit 23 has a primary storage unit 25 and prepares for communication with the server 100. An event message processing unit 26 that processes an actual event message and a network communication unit 27 that communicates the message to the server 100 are provided.

  In addition, a browser function unit 28 is provided for screen display and operation, and performs various operations, display of instructions, display of performance data, and the like.

  Next, FIG. 7 shows a functional configuration of the server 100. The server 100 has a storage disk 200 inside or outside. A DBMS 110 is used to control the storage disk 200. It is free to use one function inside the server of the DBMS 110 or a separate server. The server is composed of a computer with higher functionality than the client.

  The central processing unit 103 of the server 100 includes a network communication unit 101 that performs communication with lower-level clients, and a presentation layer data processing unit 102 that processes the message data. This is because sensor information connected on an IoT basis can be handled with a unified format code.

  The communication with the DBMS 110 of the server 100 is directly performed by the query processing unit 109, but is performed by a protocol according to the DB definition unit 108 related to SQL.

  It has a file creation unit 104 for instructions / results, and converts it into a save format for the DBMS 110. Furthermore, the Web server unit 105 is included so as to contribute to the browser function of the client, but this may also be provided separately.

  In addition, the manufacturing management system may be equipped with a warehouse management device, a shipping management device, or the like as a work management device. However, if there are at least two work management device clients, it is a subject of the present invention.

The above description has been made mainly on the production management system for foods, drugs, etc., but it is an IoT-based system that is also useful for other production management systems. It should be noted that various applications and modifications are within the scope of the present invention.

DESCRIPTION OF SYMBOLS 10 ... Acceptance management apparatus 20 ... Measurement management apparatus 30 ... Input management apparatus 11, 21, 31 ... Tag reader / writer 12, 22, 32 ... Measuring instrument 33 ... Input pot 90 ...・ Ethernet 91 ・ ・ ・ Gateway 100 ・ ・ ・ Server 200 ・ ・ ・ Storage disk

Claims (3)

In a production management system comprising a server connected to a database related to production information, with at least two management devices of the acceptance management device, the weighing management device, and the input management device each connected to a sensor device as a client,
The server receives the event notification transmitted from one management device, and updates the database so that the other management device browses and confirms the manufacturing information related to the event. The manufacturing management system according to claim 1,
The server displays a list and detailed display of instructions and results based on the database,
A manufacturing management system characterized in that information can be browsed from the management device by publishing on the management device on the Web. In the manufacturing management system according to claim 1 or 2,
The database is a manufacturing management system for reporting manufacturing results as time-series result data in order to accumulate the status of the sensor device in time series.

Images