KR100545737B1 - Production informatization system - Google Patents

Abstract

The present invention relates to a production information system that is standardized and packaged to maximize the reuse of various resources while accommodating various features of a manufacturing site. The production information system according to the present invention defines a communication driver 101 for transmitting and receiving data with various communication equipments in the production site, and information generated or managed in the production site by transmitting and receiving data through the communication driver 101. A point manager 102 for collecting, controlling, and providing the application manager 104 to the application manager 104 by connecting the at least one source database to the target database and providing the application manager 104 with integrated storage and management of various types of information. 103 and an application manager 104 that interoperates with the point manager 102 and the database manager 103 to generate an application by arbitrarily controlling the configuration information and the screen of the form in a script manner.

MES, ERP, Production Information System

Description

Production Information System

1 is a block diagram showing a schematic configuration of a production information system according to the present invention.

2 is an exemplary view showing a screen for setting a communication driver according to the present invention.

3A is a conceptual diagram of a system for information integration and sharing of various systems according to the prior art.

3B is a conceptual diagram of a system for information integration using a database manager according to the present invention.

4 is a flowchart illustrating a procedure for associating data of different systems by a database manager according to the present invention.

5 is an exemplary view of a setting screen for creating an application by an application manager according to the present invention.

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

100 Production Information System 101 Communication Driver

102 Point Manager 103 Database Manager

104 Application Manager

The present invention relates to a production information system for a component manufacturing industry including automotive parts, electrical and electronic parts.

More specifically, it collects information in real time from the information source of production status that changes every time according to the rapidly changing business environment and various orders of customers, and connects it with the resources of manager and enterprise resource planning (ERP) system to generate various information generated in the process. It is about a system that can improve customer satisfaction by swiftly dealing with pharmaceuticals to optimally manage production sites and provide customized production information to customers.

Korean Patent Laid-Open Publication No. 2001-58234 discloses a technology related to the introduction and support system of an enterprise resource planning (ERP) system related to a production information system. According to the prior art, the enterprise resource management system selection support system designs a conceptual structure for a logical model and a development system for supporting the introduction and establishment of an enterprise resource management system, and introduces an enterprise resource management system through a conceptual structure design. And comprehensively define the selection stages, and provide guidance and methods for detailed activities and step-by-step linkage plans for specific decision-making process according to the introduction selection reference model and reference model that conceptually define detailed activities and input / output matters. It is designed to support the process directly on the web by setting up the proposed selection guidelines and referencing the results.

On the other hand, the automation equipment of the production process is operated automatically continuously without the operator's intervention, if the failure of the machine will cause a direct damage to the productivity of the production process. In addition, the parts manufacturing industry is highly dependent on the skill of the operator due to the characteristics of the production process, which directly affects the quality of the product according to the input of detailed work results.

However, the workplace of the production site is restricted in the promotion of the production schedule due to the change of production schedule for customer's urgent order, the breakdown of production automation equipment, the suspension of work due to defects and shortage of raw materials of suppliers, and the absence of skilled workers. This occurs, and a problem occurs in the efficient operation of the entire process.

However, there is a problem that delays and inconsistencies in the production site information occur in tasks related to manual management of inventory, rescheduling, and exception handling only by establishing an enterprise resource planning system.

In addition, when a facility is added / changed due to a relocation or expansion of a factory, or when a manufacturing process is changed, a large portion of the production information system has to be replaced or newly constructed.

The present invention is designed to solve such a problem, the information of the production site in real-time information, and integrates the information transmitted from the external system, such as enterprise resource management system through the computer network to analyze and provide work and production site work and The objective is to optimize management.

In addition, the present invention is to provide a production information system that can be reused through a minimum change even in the event of addition or transfer of production equipment, change of manufacturing method through improvement of work or introduction of automated equipment, addition of production products. The purpose.

In addition, another object of the present invention is to provide a production information system that standardizes analysis of production information, user-provided applications, and the like, which vary in accordance with user requirements.

Production information system according to an embodiment of the present invention for achieving the above object is a communication driver 101 for transmitting and receiving data with various communication equipment of the production site;

A point manager 102 for defining, collecting, and controlling information generated or managed at a production site by transmitting and receiving data through the communication driver 101 and providing it to the application manager 104;

A database manager 103 that connects at least one source database to a target database and provides the point manager 102 or the application manager 104 and stores and manages various kinds of information;

An application manager 104 for interworking with the point manager 102 and the database manager 103 to generate an application by arbitrarily controlling configuration information and a screen of a form in a script manner; It is characterized by including.

According to the above-described configuration, the information on the production site is informed in real time, and the information transmitted from the enterprise resource management system or an external database system is integrated and analyzed and provided through a computer network, thereby optimizing the operation and management of the production site. Will be.

In the production information system according to the present invention, the communication driver 101 is a plurality of equipments for receiving information inputted through various terminals by production sites, factory facilities, various equipments, and manufacturing site users and transmitting control or command signals. Each communication driver is provided for and manages the received information in the form of a tag to improve the convenience of development and maintenance efficiency for the equipment to be added and changed.

The communication driver 101 automatically transmits and receives information through a network, which is a combination of software and hardware on a computer, or transmits and receives data through a network from an automation controller coupled with a sensor in a production site, or is carried by a worker. By receiving data through a wireless terminal, the various communication equipments are driven to transmit and receive data with various communication equipments.

The point manager 102 defines various types of information collected in the form of various tags into physical tags and virtual tags. If the tag information satisfies a predetermined condition, the point manager 102 processes the predetermined event action to be reflected in the application. To control.

In this way, the point manager 102 and the communication driver 101 communicate with each other in communication with various communication equipments in the production site through a network such as the Internet or an intranet. On the other hand, the communication equipment communicating with the communication driver 101 is a production terminal, a PC, a portable I / O terminal, a manufacturing facility having a network function, a PLC facility, and the like, when a new kind of communication equipment is added. It is possible to integrate the production information system according to the present invention by making the communication driver 101 module in the form and adding only the corresponding module.

The database manager 103 is a system for integrating and sharing information with systems such as an enterprise resource planning system, an EAM, and an SCM.

3A is a conceptual diagram of a system for information integration and sharing of various systems according to the prior art.

According to the prior art, a complex network connection relationship is required to integrate various data such as data on the web, spreadsheet data, enterprise resource planning system data, mainframe internal data, and data stored in a data warehouse. In other words, n * (n-1) connections were needed to link n applications or data systems with each other. Such information sharing systems or methods increase the traffic of data, especially when adding a new system to an existing system requires a lot of additional investment in configuration, and the burden of the network increases rapidly. Done. However, the database manager 103 according to the present invention associates information in a plurality of databases and tables with the center of the database manager 103 by using a hub & spoke method, and makes the associated information object and memory. Minimize unnecessary data lookups by handling the comparison process on the fly.

The application manager 104 applies the information provided from the point manager 102 or the database manager 103 to the standard template. When a new user application is required, the application manager 104 defines only the parts that are changed based on the standard template. This will allow you to develop applications for your users. An application refers to a software component that provides a user with a specific form of documents, reports, analysis result data, work order information on a display, and receives and sends instructions and control commands from the user to and from the work site. This configuration allows for efficient maintenance without relying on the programmer's ability.

Hereinafter, exemplary embodiments of the present invention will be described in detail with reference to the accompanying drawings. In the following description of the present invention, if it is determined that a detailed description of related known functions or configurations may unnecessarily obscure the subject matter of the present invention, the detailed description thereof will be omitted.

1 is a block diagram showing the general configuration of a production information system according to the present invention.

The enterprise resource planning (ERP) system is a management system that integrates HR information system, financial information system, and production management system that were operated independently within a company to maximize the utilization of human resources. It is an extension of concepts and functions from material requirement planning (MRP), or MRP MRP II, which was introduced earlier, and is characterized by the pursuit of mutual information integration among all organizational organizations.

Enterprise Asset Management (EAM) system, in conjunction with enterprise resource planning (ERP) in the field of facility maintenance, has the function of CMMS such as facility use planning, improvement, maintenance, work management improvement, and facility life extension. It refers to a system that operates in conjunction with all enterprise resource planning systems (ERPs) throughout production, accounting and human resources.

Meanwhile, the production information system according to the present invention defines various types of information in the form of a tag and manages and analyzes them in an integrated manner. In order to define a tag, the tag is distinguished and managed, and at least one field indicating the characteristics of the tag is defined, and a subsystem or a program in the production information system transmits and receives a tag according to the above standardized definition. By managing, managing, and controlling the system, functions such as linkage with the production site and information collection are implemented. Meanwhile, as a field for defining a tag indicating various information is regularly standardized, even if a new component, for example, a factory facility or an operator terminal, is additionally changed, a newly added facility or the like is operated according to the tag specification. It is possible to collect and analyze the data from the added equipment.

The tag is a physical tag for defining information collected from an actual communication device or information to be transmitted to the communication device, and a virtual tag generated by the point manager 102 according to the physical tag information. It is composed of

The communication driver 101 is a driving program for communicating with a physical communication device, and is separately developed for each type of communication device, and a driver written in a DLL form may be brought and used as a plug-in module. One DLL consists of a number of sub-functions to perform a specific function, and look at MakeData.dll as an example of a communication driver module in the form of a DLL that is generally written.

Typedef struct

void (WINAPI * init) (void);

void (WINAPI * unload) (void);

bool (WINAPI * open) (BSTR ip, long portno, BSTR extrainfo);

void (WINAPI * close) (BSTR ip, long portno, BSTR extrainfo);

long (WINAPI * readinfo_count) (void);

BSTR (WINAPI * doReceive) (BSTR station No, BSTR datatype, BSTR readinfo);

BOOL (WINAPI * doSend) (BSTR stationNo, BSTR memType, BSTR dataType, long startAddress, long cnt, BSTR writevalue);

void (WINAPI * make_new) (BSTR memType, long startAddress, long readcount, long index);

void (WINAPI * make_add) (BSTR memType, long startAddress, long readcout, long index);

void (WINAPI * make_readinfo) (long index, BSTR * commstr, BSTR * indexstr, long indexcount);

 refexport_t;

As such, the individual driver modules constituting the communication driver 101 include a plurality of functions as in the above example. The make_new function is designed to compose a communication frame. It sets the data type and memory type in units of tags, and when the memory type of the current tag changes according to the first tag read or the newly read tag. To be called. The make_add function is called when the memory type is the same as the previous tag in the process of retrieving the tag values. In addition, readinfo_count and make_readinfo function inform makedata.dll of the communication frame configured through make_new or make_add. After reading all the tag values, makedata.dll calls the ActiveX DLL function. doReceive and doSend are called when reading data with the communication port open, or when writing data to the device.

By creating DLL files with several sub functions as described above, it is possible to communicate by driving various communication devices, and when new communication devices are added, new driver modules can be added to the system to enable communication. .

2 is an exemplary view showing a screen for setting the communication driver 101 according to the present invention.

As described above, in order to use the communication driver 101 prepared to communicate with a specific communication device, a device must be defined by specifying values for fields predetermined for each communication target device to be connected. Preferably, the point manager 102 according to the present invention defines and registers a communication device and a communication driver 101 connected thereto, and a device type (Device) for defining a communication driver and its characteristics for registration of communication equipment. Type), Device ID indicating the identification number of the communication target device, IP indicating the Internet address, Port indicating the port number, Reset Port number and Station number (Station which can be used in case of PLC) No), it defines BaseScanRate which represents standard scan speed by communication equipment. By doing so, the production information system according to the present invention defines a driver for communicating with the communication target device and the communication target device to communicate with the communication target device and collect information.

Meanwhile, the point manager 102 includes a tag manager that manages tag information according to a function, and an event manager that generates and manages an event according to a condition of the tag information.

Tag Manager defines physical tags and virtual tags. To define a physical tag, a tag name (TagName), a tag description (TagDesc) having a unique value, a device type (DeviceType) indicating a driver for a communication target device, a bit, a character as a basic transmission unit of data for communication Data type (DataType) to define word, number, etc., Device ID indicating communication device identification number, Memory type indicating memory type of PLC when using PLC, Read / write mode of tag. Fields such as a tag type for definition and a start address for defining a start memory address for communication must be defined.

To define a virtual tag, define the tag name and tag description as defined in the physical tag, and specify the device type and device ID as temporary status. In addition, in the case of a virtual tag, a calculation formula for defining a tag operation using physical tag information or the like can be prepared. The tag operation is defined to perform a procedure such as calculating a result value, calculating a logical value, or converting a value according to a calculation formula written in a script or the like, and by processing and analyzing various kinds of information in this way, Information can be generated. As a script for specifying such a tag operation, a Visual Basic script (VBScripti) or the like can be used. In this way, the information obtained from the physical tag is processed through the tag operation specified in the virtual tag, so as to manage production orders for ordering production at the production site, monitor the process at the manufacturing site, and check the progress of the process. Information related to management, quality control, facility management for detecting and maintaining facilities, process management, and productivity analysis for analyzing productivity by processing various data can be delivered to the application and finally provided to users. Will be.

The Event Manager generates an event when a specific tag satisfies a specific condition and causes the production information system to perform a specific task (event action). To do this, you must first define EventEnable, which indicates the activation of the event, and EventAction, which is the task to be processed when the event occurs. These event actions can define tasks such as executing a specific script function or processing information according to a formula, notification of information, and storage.

3B is a conceptual diagram of a system for information integration using the database manager 103 according to the present invention.

The database manager 103 is a tool for the integration of information between multiple systems. The database manager 103 according to the present invention integrates information using a hub & spoke method. Hub-and-spoke systems are used by companies such as IBM to integrate enterprise application systems, with a centralized structure for integrating data.

4 is a flowchart illustrating a procedure for associating data of different systems by the database manager 103 according to the present invention.

Referring to FIG. 4, the database manager 103 defines a database in which data is to be shared with each other and performs setting for connection (S401), defines a source-side database (S402), and defines a target-side database. In step S403, the source-side database and the target-side database are linked.

The database manager 103 must first define a database to be used for linking information between systems. To do this, set the database type first. Preferably, the database system usable in the present invention may include various relational databases, databases such as Oracle, MS SQL, DB2, MS ACCESS, and Excel, text files, or CSV files. In addition to the database type, in order to define the database and configure the connection between the databases, a number of fields including the OLE DB provider, the user connecting to the database, or the password for connecting to the database must be specified. The OLE DB provider is an access connector for connecting multiple databases. It can support Excel and MDB files using Microsoft Jet 3.51 OLE DB Providedr, and it can support MS SQL and DB2 when using the Microsoft OLE DB Provider for ODBC driver. Can be. On the other hand, to support Oracle, use Microsoft OLE DB Provider for Oracle. To connect text file or CSV file, use Microsoft Text Driver as connection connector.

When the definition and connection setup of the database for linking the information of two or more different systems are completed, the source and target databases of the database to be connected are designated to share and link information in both databases. do. The two databases linked in this way are mainly interfaced with each other in two ways. First, in the case of the collection method, the source and target data are stored in memory in a batch to perform operations. While it can be minimized, it requires a lot of hardware memory. On the other hand, in the case of data search, if one or more data is retrieved from the target database when the source data is needed, the execution speed is fast and the amount of memory required is reduced while data traffic is required. This is characterized by an increase. In this way, users can get the information they need from a variety of databases and use it and gain integrated control.

5 is an exemplary view of a setting screen for creating an application by the application manager 104 according to the present invention.

Application manager (103) is a system that allows you to control the configuration information and screen of the form arbitrarily during program execution and output the output to the screen in order to increase the reusability of the already developed application form (Form) to be. The application manager 104 may easily create a new form by recalling a template form already stored and reusing it, deleting it, or adding or changing a function inside the form. Application forms of the production information system according to the present invention may include work orders, product history management, facility failure monitoring or prevention, productivity analysis, resource status management, quality control, and automatic control of field equipment. If necessary, external files or executable files can be configured as applications. In this way, by creating an application that can interface with the user in a specified manner according to the user's needs, the user can obtain desired information from the factory's production equipment and transmit commands required for control of the production process to the production equipment through the application. It will be possible.

Meanwhile, the application manager 104 manages user-specific setting information through a web server, so that even if a user's terminal, for example, a mobile terminal such as a PC or a PDA is changed or replaced, the application manager 104 may work at any time according to the same environment setting information for each user. Stores and manages environment setting information for each user so that they can be executed.

The application manager 104 may use a script for generating, controlling, and processing a form, and may preferably follow the VBScript grammar.

According to the above-described configuration, information is collected and controlled from production sites such as factory facilities and workers' terminals, integrated by reading information from external systems such as enterprise resource management systems, and analyzed and provided through a computer network. The effect is to optimize the work and management of the site.

In addition, according to the above-described configuration, the communication driver 101 without reconfiguring the entire production information system even when the production method is changed or the production product is changed by adding or relocating a production facility, improving work or introducing an automated facility, and adding a production product. Adding a module, adding a template form, or defining a database that can be integrated and managed can provide an efficient production information system.

In addition, according to the above-described configuration, by using a standardized form or by analyzing a variety of production information, user-provided applications, or by reconfiguring the standardized form with a simple operation, a production information system with low maintenance, management and maintenance costs It will be effective to provide.

The present invention has been described above with reference to preferred embodiments, but is not limited thereto, and is interpreted by the appended claims, which are intended to cover many modifications that will be apparent to those skilled in the art without departing from the scope of the present invention. Should be done.

Claims (9)

A communication driver 101 for transmitting and receiving data to and from various communication devices in the production site; A point manager 102 for defining, collecting, and controlling information generated or managed at a production site by transmitting and receiving data through the communication driver 101 and providing it to the application manager 104; A database manager 103 that connects at least one source database to a target database and provides the application manager 104 with integrated storage and management of various types of information; An application manager 104 for interworking with the point manager 102 and the database manager 103 to generate an application by arbitrarily controlling configuration information and a screen of a form in a script manner; Production information system comprising a. The method of claim 1, The communication driver 101 is a production information system, characterized in that written in the form of a plug-in module. The method of claim 1, The communication driver 101 automatically transmits and receives information through a network on a computer, transmits and receives data through a network from an automated controller coupled with a sensor, or receives data through a wireless terminal. Production information system, characterized in that for transmitting and receiving. The method of claim 1, The point manager 102, A tag manager for managing a physical tag for defining and managing information related to an actual communication device, a virtual tag arbitrarily generated for management or use purposes; An event manager that processes a predefined event action when a physical tag or a virtual tag defined by the tag manager is a specific condition; Production information system comprising a. The method of claim 1, The database manager 103, A production information system, characterized by defining at least one data table on another system, integrating at least one source database into a target database. The method of claim 5, The type of source data that can be defined by the database manager 103 includes at least one of a relational database, an MDB, an Excel file, and a text file. The method of claim 1, The application manager 104, Production information system, characterized in that for setting the user-specific permissions, defining and controlling at least one field for the form to be scripted. The method of claim 7, wherein The application manager 104, Production information system characterized by reading, registering and setting the form in the form of a plug-in module from an external executable file. The method according to claim 1, wherein The application generated by the application manager 104, Production information system, characterized in that for at least one of production order management, production management, quality control, equipment management, process management, productivity analysis.

Images