KR20060111949A - Interface apparatus of manufacturing execution system - Google Patents

Abstract

A device for interfacing an MES(Manufacturing Execution System) is provided to enable a client PC to use an MES table included in a database by directly calling a program included in a database server without using a specific program or an interface program in the client PC. The database server(200) includes the MES table and an MES table handling part using the MES table. The MES table handing part stores software to update, insert, and delete the MES table included in the database server. The client PCs(220) are connected with the database server by calling the software stored in the MES handling part.

Description

Interface apparatus of Manufacturing Execution System

1 is a block diagram showing a conventional three-tier interface structure.

Figure 2 is a block diagram schematically showing an integrated production management system (MES) interface device according to an embodiment of the present invention.

3 is a diagram showing a structure in the DB server shown in FIG.

<Explanation of symbols for the main parts of the drawings>

200: DB server 202: MES table

204: MES table handling unit 220: client PC

The present invention relates to interface middleware, and more particularly, to an interface device of a manufacturing execution system (MES).

Manufacturing Execution System (MES) is a system for managing process progress, manufacturing performance, and quality control of products manufactured in a manufacturing company, and real-time monitoring and control of shop floor environment. It is a field system that focuses on logistics, work history tracking, status, and defect management.

While the existing ERP system identifies the company's activities through planned production and supply and demand for materials in a middle-down manner, the MES system identifies scheduling and production and supply and demand for production in a bottom-up manner. That's how it is.

Looking at the function of MES system, process progress information monitoring and control, facility control and monitoring, quality information tracking and control, performance information aggregation, warehouse operation management, work in process management, material input management, manpower management, public service management, etc. All information can be said to be integrated management.

The interface of the MES system has a three-tier or two-tier structure. Hereinafter, the interface structure of the conventional MES system will be described.

1 is a block diagram showing a conventional three-tier interface structure.

Referring to FIG. 1, this is composed of a DB server 10, an application server 12, and a client PC 14, and about 5 client PCs 14 per application server 12. It is a structure that can be connected.

In the conventional case, in order to implement the MES system in the above configuration, a specific program must be installed in the application server 12, and a program for a predetermined interface must be installed to interface between the application server 12 and the client PC 14. .

As the specific program, a conventional "InTrack run-time module" is used, and when Intra is installed as a package program for MES of Wonderware Inc., an associated table is created in the DB server 10. .

That is, in order to interface with the InTrack table in the application server 12 and the DB server 10, the aforementioned "InTrack runtime module" must be installed in the application server 12. You must call the intrack function to use the intrack table in the DB server 10.

In addition, in the interface between the application server 12 and the client PC 14, in order to interface with the table generated by the InTrack package to the DB server 10, the client PC 14 and the application server 12 in a queue manner. For this purpose, MSMQ (Microsoft's Message Queue) is generally used.

However, in the case of the conventional three-layer interface structure, there is a drawback that no work can be generated at the production site due to unstable data loss due to instability of the MSMQ.

In order to overcome this disadvantage, a two-tier interface structure may be used.

It is composed of DB server and client PC, and DB server and client PC are directly connected. Therefore, the above-mentioned "InTrack Runtime Module" program is installed for each client PC. It is a structure that enables the interface with the InTrack table in the server.

In this case, unlike the structure shown in FIG. 1, since the application server is not provided, the MSMQ for the interface between the application server and the client PC is not used, thereby ensuring system stability by overcoming the existing interface failure problem, but for each client PC. The disadvantage is that the system build cost is increased because the "Intrack Runtime Module" must be installed.

The present invention has been made to overcome the above disadvantages, and does not install a specific program ("Intrack runtime module") or an interface program (MSMQ) on a client PC, and is provided in a DB server directly at the client PC. It is an object of the present invention to provide an integrated production management system (MES) interface device that allows the use of the MES table provided in the DB by directly using the program.

In order to achieve the above object, the interface device of the integrated production management system according to an embodiment of the present invention comprises a DB server and a plurality of client PCs connected to the DB server (Manufacturing Execution System: In the interface device of the MES, the DB server is characterized in that it comprises a MES table and the MES table handling unit that can use the MES table.

Here, the MES table handling unit stores predetermined software for updating, inserting, and deleting the MES table in the DB server, and the plurality of client PCs store the MES table. Called predetermined software stored in the handling unit (Call) characterized in that connected to the DB server.

Hereinafter, exemplary embodiments of the present invention will be described in detail with reference to the accompanying drawings.

FIG. 2 is a block diagram schematically illustrating an integrated production management system (MES) interface device according to an embodiment of the present invention, and FIG. 3 is a diagram illustrating a structure in the DB server shown in FIG. 2.

The present invention is an integrated production management system (MES) interface middleware device using a two-tier interface structure as shown in FIG. 2, and unlike a conventional two- or three-layer interface structure, a client Instead of installing a specific program (" intrack runtime module ") or an interface program (MSMQ) on the PC 220, the client PC 220 directly calls a predetermined program provided in the DB server 200 directly ( By using the call), it is characterized in that the integrated production management system (MES) interface device to be able to use the MES table 202 provided in the DB server 200.

2 and 3, the integrated production management system (MES) interface device according to the present invention is composed of a DB server 200 and a client PC 220, the DB server 200 and the client PC. 220 is directly connected.

In particular, in the present invention, the MES table handling unit 204 is provided in the DB server 200 so that the client PC 220 can use the MES table 202 in the DB server 200. By connecting to the MES table handling unit 204 provided in the DB server 200 at 220, as a result, an interface between the client PC 220 and the MES table 202 in the DB server 200 becomes possible. Structure.

At this time, the MES table handling unit 204 includes a predetermined software for handling the MES table 202 in the DB server 200 such as update, insert, delete, and the like. Characterized in that it is stored.

The predetermined software may consist of coding as described below in one embodiment.

PROCEDURE IN_LOT_COMPLETE (ERRBUF OUT VARCHAR2

, X_WIP_ID IN VARCHAR2-Lot ID

, X_ROUTE_NAME IN VARCHAR2-Route configured on the SMD UI.

, X_ROUTE_STEP_NAME IN VARCHAR2-Route Step configured on the SMD UI.

, X_OPERATION_NAME IN VARCHAR2-Operation set on the SMD UI.

, X_LOCATION IN VARCHAR2-Location set on SMD UI.

, X_DISPOSITION IN VARCHAR2-Disposition Code

-, X_FORCE IN VARCHAR2-

-, X_PULLABLE IN VARCHAR2-Pullable Check Code. Y / N (defualt)

)

 IS

  X_LOG_BUF VARCHAR2 200;

  X_TRANSID VARCHAR2 (17);

  EX_COMPLETE_ERROR EXCEPTION;

XN_NEXT_STEP VARCHAR2 (30);

XN_NEXT_STEP_OPERATION VARCHAR2 (30);

X_MATERIALNAME VARCHAR2 (80);

N_PRIMARYQTY FLOAT;

CURSOR C_MATERIAL IS

   SELECT USL.PRODUCT_NAME PRODUCT_NAME

       FROM U_SMD_LOT USL

      , LOT L

WHERE USL.WORK_ORDER = WORK_ORDER

AND L.LOTID = X_WIP_ID;

   N_PRIMARYQTY FLOAT

According to the present invention, compared with the conventional structure shown in FIG. 1, since the interface between the client PC and the application server is unnecessary, MSMQ is not used to secure system stability without the problem of the interface to prevent the occurrence of no work and the client. Speed up the interface between PC and DB server.

In addition, it is possible to use the MES table provided in the DB server without installing the InTrack runtime module on the client PC, thereby reducing the system cost by overcoming the license cost burden.

According to the present invention, there is no need to install a specific program on the client PC by placing a new function that handles the MES table only in the DB server, and also requires no interface program such as MSMQ to be installed on the client PC. The advantage is that it can be maximized.

Claims (3)

In the interface device of a manufacturing execution system (MES) consisting of a DB server and a plurality of client PCs connected to the DB server, The DB server is an interface device of the integrated production management system, characterized in that it comprises a MES table and the MES table handling unit that can use the MES table. The method of claim 1, The MES table handling unit stores predetermined software for updating, inserting, and deleting the MES table in the DB server. Device. The method of claim 1, And the plurality of client PCs are connected to the DB server by calling predetermined software stored in the MES table handling unit.

Images