MIRABEL DW

Managing Complex Energy Data in a Smart Grid

Publikation: Bidrag til bog/antologi/rapport/konference proceedingBidrag til bog/antologiForskningpeer review

Resumé

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 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 how specialized variants of the generic schema can be used by different node types while we maintain compatibility and consistency between them. Finally, we present typical queries from the energy domain and a performance study.
OriginalsprogEngelsk
TitelTransactions on Large-Scale Data- and Knowledge-Centered Systems XXI : Selected Papers from DaWaK 2012
RedaktørerAbdelkader Hameurlain, Josef Küng, Roland Wagner, Alfredo Cuzzocrea, Umeshwar Dayal
ForlagSpringer
Publikationsdato17 jul. 2015
Sider48-72
ISBN (Trykt)978-3-662-47803-5
ISBN (Elektronisk)978-3-662-47804-2
DOI
StatusUdgivet - 17 jul. 2015
NavnLecture Notes in Computer Science
Vol/bind9260
ISSN0302-9743

Fingerprint

Data warehouses
Information management
Data structures
Time series
Railroad cars
Energy utilization
Electricity
Scheduling

Citer dette

Siksnys, L., Thomsen, C., & Pedersen, T. B. (2015). MIRABEL DW: Managing Complex Energy Data in a Smart Grid. I A. Hameurlain, J. Küng, R. Wagner, A. Cuzzocrea, & U. Dayal (red.), Transactions on Large-Scale Data- and Knowledge-Centered Systems XXI: Selected Papers from DaWaK 2012 (s. 48-72). Springer. Lecture Notes in Computer Science, Bind. 9260 https://doi.org/10.1007/978-3-662-47804-2_3
Siksnys, Laurynas ; Thomsen, Christian ; Pedersen, Torben Bach. / MIRABEL DW : Managing Complex Energy Data in a Smart Grid. Transactions on Large-Scale Data- and Knowledge-Centered Systems XXI: Selected Papers from DaWaK 2012. red. / Abdelkader Hameurlain ; Josef Küng ; Roland Wagner ; Alfredo Cuzzocrea ; Umeshwar Dayal. Springer, 2015. s. 48-72 (Lecture Notes in Computer Science, Bind 9260).
@inbook{e0572c90a0b74dd6995523ae29f2e44f,
title = "MIRABEL DW: Managing Complex Energy Data in a Smart Grid",
abstract = "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 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 how specialized variants of the generic schema can be used by different node types while we maintain compatibility and consistency between them. Finally, we present typical queries from the energy domain and a performance study.",
author = "Laurynas Siksnys and Christian Thomsen and Pedersen, {Torben Bach}",
year = "2015",
month = "7",
day = "17",
doi = "10.1007/978-3-662-47804-2_3",
language = "English",
isbn = "978-3-662-47803-5",
pages = "48--72",
editor = "Abdelkader Hameurlain and Josef K{\"u}ng and Roland Wagner and Alfredo Cuzzocrea and Umeshwar Dayal",
booktitle = "Transactions on Large-Scale Data- and Knowledge-Centered Systems XXI",
publisher = "Springer",
address = "Germany",

}

Siksnys, L, Thomsen, C & Pedersen, TB 2015, MIRABEL DW: Managing Complex Energy Data in a Smart Grid. i A Hameurlain, J Küng, R Wagner, A Cuzzocrea & U Dayal (red), Transactions on Large-Scale Data- and Knowledge-Centered Systems XXI: Selected Papers from DaWaK 2012. Springer, Lecture Notes in Computer Science, bind 9260, s. 48-72. https://doi.org/10.1007/978-3-662-47804-2_3

MIRABEL DW : Managing Complex Energy Data in a Smart Grid. / Siksnys, Laurynas; Thomsen, Christian; Pedersen, Torben Bach.

Transactions on Large-Scale Data- and Knowledge-Centered Systems XXI: Selected Papers from DaWaK 2012. red. / Abdelkader Hameurlain; Josef Küng; Roland Wagner; Alfredo Cuzzocrea; Umeshwar Dayal. Springer, 2015. s. 48-72 (Lecture Notes in Computer Science, Bind 9260).

Publikation: Bidrag til bog/antologi/rapport/konference proceedingBidrag til bog/antologiForskningpeer review

TY - CHAP

T1 - MIRABEL DW

T2 - Managing Complex Energy Data in a Smart Grid

AU - Siksnys, Laurynas

AU - Thomsen, Christian

AU - Pedersen, Torben Bach

PY - 2015/7/17

Y1 - 2015/7/17

N2 - 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 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 how specialized variants of the generic schema can be used by different node types while we maintain compatibility and consistency between them. Finally, we present typical queries from the energy domain and a performance study.

AB - 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 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 how specialized variants of the generic schema can be used by different node types while we maintain compatibility and consistency between them. Finally, we present typical queries from the energy domain and a performance study.

U2 - 10.1007/978-3-662-47804-2_3

DO - 10.1007/978-3-662-47804-2_3

M3 - Book chapter

SN - 978-3-662-47803-5

SP - 48

EP - 72

BT - Transactions on Large-Scale Data- and Knowledge-Centered Systems XXI

A2 - Hameurlain, Abdelkader

A2 - Küng, Josef

A2 - Wagner, Roland

A2 - Cuzzocrea, Alfredo

A2 - Dayal, Umeshwar

PB - Springer

ER -

Siksnys L, Thomsen C, Pedersen TB. MIRABEL DW: Managing Complex Energy Data in a Smart Grid. I Hameurlain A, Küng J, Wagner R, Cuzzocrea A, Dayal U, red., Transactions on Large-Scale Data- and Knowledge-Centered Systems XXI: Selected Papers from DaWaK 2012. Springer. 2015. s. 48-72. (Lecture Notes in Computer Science, Bind 9260). https://doi.org/10.1007/978-3-662-47804-2_3