An Alternative Relational OLAP Modeling Approach
DaWaK 2000 Proceedings of the Second International Conference on Data Warehousing and Knowledge Discovery
A UML profile for the conceptual modelling of data-mining with time-series in data warehouses
Information and Software Technology
Advanced Data Warehouse Design: From Conventional to Spatial and Temporal Applications
Advanced Data Warehouse Design: From Conventional to Spatial and Temporal Applications
Multidimensional Databases and Data Warehousing
Multidimensional Databases and Data Warehousing
Multi-dimensional aggregation for temporal data
EDBT'06 Proceedings of the 10th international conference on Advances in Database Technology
Data management in the MIRABEL smart grid system
Proceedings of the 2012 Joint EDBT/ICDT Workshops
Aggregating and disaggregating flexibility objects
SSDBM'12 Proceedings of the 24th international conference on Scientific and Statistical Database Management
Daisy: the center for data-intensive systems at Aalborg University
ACM SIGMOD Record
Visualizing complex energy planning objects with inherent flexibilities
Proceedings of the Joint EDBT/ICDT 2013 Workshops
Towards the automated extraction of flexibilities from electricity time series
Proceedings of the Joint EDBT/ICDT 2013 Workshops
Research challenges for energy data management (panel)
Proceedings of the Joint EDBT/ICDT 2013 Workshops
Hi-index | 0.00 |
In the MIRABEL project, a data management system for a smart grid is developed to enable smarter scheduling of energy consumption such that, e.g., charging of car batteries is done during night when there is an overcapacity of green energy from windmills etc. Energy can then be requested by means of flex-offers which define flexibility with respect to time, amount, and/or price. In this paper, we describe MIRABEL DW, a data warehouse (DW) for the management of the large amounts of complex energy data in MIRABEL. We present a unified schema that can manage data both at the level of the entire electricity network and at the level of individual nodes, such as a single consumer node. The schema has a number of complexities compared to typical DW schemas. These include facts about facts and composed non-atomic facts and unified handling of different kinds of flex-offers and time series. We also discuss alternative data modeling strategies and present typical queries from the energy domain and a performance study.