Intelligent Energy Data Warehouse: What Challenges?

The RIDER -Réseau et Inter connectivité Des Energies classiques et Renouvelables (Network and Inter-Connectivity of Classical and Renewable Energies) project gathers a pool of university laboratories, national and international companies to design intelligent energy management platforms. We present here our contribution on designing data warehouse architectural models for massive and heterogeneous data, to be integrated in a multi-building intelligent energy management platform. Although a lot of work has been done on the subject, present tools and techniques still do not cover all the challenges we face when confronted to real time energy-related data management. This paper presents an overview of the related research work on data streams, data warehousing and ETL (Extract Transform Load) processes. ETL data exceptions will be our main point of focus. This critical subject has been rather left aside in research works so far.