Epidemiological Modeling of COVID-19, Using the MySQL Database Connection, with Different Platforms such as: Excel, MATLAB® and Node-RED

The monitoring of massive data in the industrial field and even more so of health in Zone 7, specifically those related to the COVID-19 pandemic, are relevant in the decision-making and relevant actions that lead to the minimization of cases of on-site contagion. This article presents an integration of three platforms such as Excel, Matlab, and Node-RED, using the MySQL database, to simulate COVID-19 scenarios, based on static data and dynamic data. The collection of random data from the MySQL database has been built in Node-RED, and through a panel, the information regarding the population susceptible to contagion, infected and recovered is displayed. Using randomization functions in the mathematical model based on COVID-19 data sources and applying the Node-RED interface and previous treatment of the data, visualization, and alerts of the variables of interest of the proposed model have been developed. The methodology used in this study provides promising results for the prediction of the infection rate and recovery rate due to the COVID-19 pandemic.