5. Informatics solutions for electricity consumption and generation

In order to increase the consumer awareness toward energy efficiency, new informatics solutions must be developed and offered by the electricity supplier. An informatics solution for demand management must fulfill the following requirements:


Our proposed informatics solution is part of a research project and it is addressed mainly to household consumers, but it also contains a management consumption module for electricity supplier. The informatics solution contains the following modules: data acquisition from smart metering and smart appliances, models for consumption management and user-friendly interfaces.

#### 5.1. Data management

Data acquisition module extract data from heterogeneous sources such as smart meters and appliances in .csv or .raw format, micro-generation equipment (small photovoltaic panels, wind turbines and electrical vehicles), manual reading done by electricity supplier' employees or via web interfaces. Data are loaded first into local databases (concentrators) via Wi-Fi or RF. From local concentrators, data are synchronized periodically and loaded into a central data stage for proper cleansing and validation. We also designed an extract, transform and load (ETL) patterns for different types of SM and also procedures for extracting data from heterogeneous appliances. After ETL process completes, data are loaded into a central relational database running Oracle Database 12c or MySQL for operational management and then into a data warehouse for advanced analytics.
