Integración de un sistema de comunicaciones internet y base de datos, para calcular el consumo de energía mediante la dimerización de la iluminación en el hogar, variado y consultado desde una aplicación.

Abstract

This paper presents the integration of an internet communications system and database, in order to calculate the electric power consumption through the dimerization of home lighting, varied and consulted from an application.

This hybrid application was developed for mobile phones and tablets with Android operating system, allows to modify the luminous intensity of the luminaries of the home or specific space from anywhere with Internet access, It sends requests to a Web server using HTTP Request POST.

For the web server it uses a web service that is developed on Raspbian, which is the operating system of the Raspberry pi 3 matrix. In the web service, everything that has to do with the internet connection is selected, port selection TPC / UDP for the display of the Web page on the mobile or computer, the connection to the database by TCP ports and the configuration of recurring execution macros for obtaining, manipulating and processing data.

The database is developed in SQL Server and fully configured to have access from the Raspberry pi for both data writing and reading them. In the database there are 5 tables configured in which times and percentages of use are stored in real time with a maximum resolution of 10 seconds.

In the interface, queries are made to the database or the intensity of each luminaire is varied independently through an interface. This interface was developed in HTML and CSS using Boostrap as Front-End. The use of JavaScript is essential for communication between the Front-End and the Back-End, which is developed in two languages, Python 3.4 and SQL Server.