MIRABEL DW: Managing Complex Energy Data in a Smart Grid

Research output: Contribution to book/anthology/report/conference proceedingBook chapterResearchpeer-review

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.
Original languageEnglish
Title of host publicationTransactions on Large-Scale Data- and Knowledge-Centered Systems XXI : Selected Papers from DaWaK 2012
EditorsAbdelkader Hameurlain, Josef Küng, Roland Wagner, Alfredo Cuzzocrea, Umeshwar Dayal
PublisherSpringer
Publication date17 Jul 2015
Pages48-72
ISBN (Print)978-3-662-47803-5
ISBN (Electronic)978-3-662-47804-2
DOIs
Publication statusPublished - 17 Jul 2015
SeriesLecture Notes in Computer Science
Volume9260
ISSN0302-9743

Fingerprint

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

Cite this

Siksnys, L., Thomsen, C., & Pedersen, T. B. (2015). MIRABEL DW: Managing Complex Energy Data in a Smart Grid. In A. Hameurlain, J. Küng, R. Wagner, A. Cuzzocrea, & U. Dayal (Eds.), Transactions on Large-Scale Data- and Knowledge-Centered Systems XXI: Selected Papers from DaWaK 2012 (pp. 48-72). Springer. Lecture Notes in Computer Science, Vol.. 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. editor / Abdelkader Hameurlain ; Josef Küng ; Roland Wagner ; Alfredo Cuzzocrea ; Umeshwar Dayal. Springer, 2015. pp. 48-72 (Lecture Notes in Computer Science, Vol. 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",
series = "Lecture Notes in Computer Science",
publisher = "Springer",
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",
address = "Germany",

}

Siksnys, L, Thomsen, C & Pedersen, TB 2015, MIRABEL DW: Managing Complex Energy Data in a Smart Grid. in A Hameurlain, J Küng, R Wagner, A Cuzzocrea & U Dayal (eds), Transactions on Large-Scale Data- and Knowledge-Centered Systems XXI: Selected Papers from DaWaK 2012. Springer, Lecture Notes in Computer Science, vol. 9260, pp. 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. ed. / Abdelkader Hameurlain; Josef Küng; Roland Wagner; Alfredo Cuzzocrea; Umeshwar Dayal. Springer, 2015. p. 48-72 (Lecture Notes in Computer Science, Vol. 9260).

Research output: Contribution to book/anthology/report/conference proceedingBook chapterResearchpeer-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

T3 - Lecture Notes in Computer Science

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. In Hameurlain A, Küng J, Wagner R, Cuzzocrea A, Dayal U, editors, Transactions on Large-Scale Data- and Knowledge-Centered Systems XXI: Selected Papers from DaWaK 2012. Springer. 2015. p. 48-72. (Lecture Notes in Computer Science, Vol. 9260). https://doi.org/10.1007/978-3-662-47804-2_3