Explorando esquemas de dados SCADA para fins de automação residencial

Abstract

One topic that has attracted attention in recent years in the software market is residential automation. With the high availability of technology, it became increasingly feasible to implement control policies and obtain information about a particular residence, in real time, in the palm of your hands. An essential tool in cases is SCADA, a system through which it is possible to implement the control of residential components and monitor the behavior of these components remotely via the browser. SCADA systems are widely used in industry, in power distribution systems, academy, etc. One gap, however, is related to how data is stored and manipulated in SCADA. In general, this type of application spends a greater concern with control and monitoring policies, while data manipulation is sometimes only a complement to the software. It is common that data manipulation in SCADA systems is no more than the construction of reports and alarms. This work aims to explore the structure of the database within a SCADA system. It will be emphasized how this framework stores data and what can be done with them using SCADA's own resources. This will be illustrated by means of a residential prototype. Later, it will be shown how the SCADA data schema can be better exploited with advanced programming features such as triggers and procedures, and how these features can be integrated with process control to, for example, trigger equipment automatically according to certain preconditions established for the residence.