Design and Development of a Relational Database Management System (RDBMS) with Open Source Tools for the Processing of Data Monitored in a Set of Photovoltaic (PV) Plants

Abstract

The objective of this work has been to implement an orderly, accessible, fast and space-saving storage system that allows the transfer to a Relational Database Management System (RDBMS) of all the data corresponding to the monitoring of a set of photovoltaic (PV) systems whose behaviour is to be analysed. The RDBMS consists of a series of linked databases, enabling all PV system information to be stored, and it is scalable so it can be expanded depending on the number of installations to be studied. The data recorded in the plants are found in a large number of very disaggregated files, and with different measured parameters, different formats, nomenclatures, or units of measurement, so the developed system is responsible for homogenising all the information for storage. For this purpose, a procedure has been developed to carry out the automatic transfer of all the data recorded in their corresponding databases. In addition, in this work, a web application called S·lar 2 has been developed to facilitate selective access to all the data once stored in the corresponding tables. This application, which is connected to the designed databases, allows the storage and management of the information coming from the PV plants, in order to determine, among other things, the operation mode of each of the components of these facilities. Using the data already organised, it has also been possible to establish a system for comparing the production of inverters within the same plant in order to have a tool that allows the quick and visual detection of possible deviations between them and thus detect malfunctions in any of the components. The whole procedure has been carried out using free software, such as Maria DB and Python.