Diseño e implementación de un prototipo de historiador de proceso industrial de código abierto: desarrollo de aplicaciones de supervisión industrial de código abierto para el laboratorio de redes industriales.

Abstract

The need to collect data resulting from the operation of a certain industrial process, as well as the need to be able to make records of the same, for the generation of histories that help to optimize the process in question, forces the industrial sector to supply itself with a Data Historian software; in a practical way too known as Process Data Historian. Currently there are several tools that seek to satisfy these needs, however, the cost of acquiring your license can reach high values ​​depending on its benefits. In the present work, an application software is designed and implemented, which acts as a Process Historian, mainly using the free and open source software language JavaScript and the PostgreSQL database engine. A data server is incorporated that allows easy coupling between the application and the different client devices using SQL-type queries such as reading or writing, as well as the MQTT, SQL queryes, and Modbus TCP protocols. There is a graphical interface GUI, where all the information associated with the configuration, monitoring, operation and maintenance of the data flow is centralized. All the software developed, as well as its dependencies and the database engine are contained in a virtual execution environment to facilitate the work of installation and deployment. In this way, it seeks to benefit SMEs by providing an open source and lower cost alternative to business historian applications. The validation of the operation of the application is carried out based on the performance and deployment tests carried out.