Common scheme for data interaction between host computer and MES

With the continuous improvement of modern industrial automation, the data exchange between the host computer and MES (Manufacturing Execution System) has become an important part of enterprise production management. In order to realize the informatization and intelligence of the production process, improve the production efficiency and product quality, the data exchange between the host computer and MES needs to choose the appropriate scheme. This article will introduce several commonly used schemes for your reference.

一、File method

File mode is a more traditional way of data exchange, and its advantages are simple and easy to implement. The host computer or MES can periodically generate text files or Excel, XML and other format files, and transfer the files to each other through FTP, Email and other ways. After receiving the document, the other party should deal with it according to the content of the document.

The drawback of the file approach is that it is less efficient to transfer and error-prone. In addition, the format of the file, transmission mode and so on need to be strictly regulated by both parties, otherwise it is prone to data loss or inconsistency.

二、Database mode

The database mode is to use the relational database (such as MySQL, Oracle, etc.) to realize the data interaction between the host computer and MES. The host computer or MES can read and write the database through SQL statements to achieve data sharing.

The advantage of the database approach is that the data storage is standardized and easy to manage. In addition, data integrity and consistency can be ensured through database transaction processing. The disadvantage is that the deployment and maintenance cost of the database is high, and it has certain requirements for the network bandwidth.

三、TCP/IP mode

TCP/IP means that the host computer and MES exchange data through TCP/IP protocol. The host computer or MES can use Socket programming to achieve bidirectional transmission of data.

TCP/IP mode has the advantages of fast transmission speed and high efficiency. The disadvantages are that both parties need to agree on the data format and transmission protocol, and data loss or inconsistency may occur when the network is unstable.

四、WebService approach

WebService is a kind of service architecture based on XML. It is not limited by language and platform, and can call each other between different languages. The host computer and MES can exchange data through WebService to realize cross-platform and cross-language data sharing.

The advantage of WebService is cross-platform, cross-language, easy integration. The disadvantage is that the WebService needs to be defined and deployed in detail, which is relatively complex to implement.

五、RESTful API approach

RESTful API is a lightweight WebService architecture based on HTTP protocol, which is simple and easy to implement. The host computer and MES can exchange data through RESTful API to achieve data sharing.

The advantage of the RESTful API approach is that it is simple and easy to implement. The disadvantage is that RESTful apis require detailed definition and deployment, which is relatively complex to implement.

Conclusion

The common schemes of data interaction between the host computer and MES include file mode, database mode, TCP/IP mode, WebService mode and RESTful API mode. Different schemes have their advantages and disadvantages, which need to be selected according to the specific situation. In practical applications, the combination of various schemes may be used for data interaction between the host computer and MES to achieve the best effect of data interaction.