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.
This is a preview of subscription content, log in via an institution to check access.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
References
Bauer, A., Hümmer, W., Lehner, W.: An alternative relational OLAP modeling approach. In: Kambayashi, Y., Mohania, M., Tjoa, A.M. (eds.) DaWaK 2000. LNCS, vol. 1874, p. 189. Springer, Heidelberg (2000)
Boehm, M., et al.: Data management in the MIRABEL smart grid system. In: Proceedings of EDBT/ICDT Workshops (2012)
Böhlen, M.H., Gamper, J., Jensen, C.S.: Multi-dimensional aggregation for temporal data. In: Ioannidis, Y., Scholl, M.H., Schmidt, J.W., Matthes, F., Hatzopoulos, M., Böhm, K., Kemper, A., Grust, T., Böhm, C. (eds.) EDBT 2006. LNCS, vol. 3896, pp. 257–275. Springer, Heidelberg (2006)
Chang, F., et al.: Bigtable: a distributed storage system for structured data. TOCS 26(2), 205–218 (2008)
Elmasri, R., Navathe, S.B.: Fundamental of Database Systems, 4th edn. Addison Wesley, Boston (2004)
European Network of Transmission System Operators for Electricity. The Harmonised Electricity Market Role Model, version 2011–01. www.ebix.org/Documents/role_model_v2011_01.pdf as of 03 March 2014
Introduction to Business Requirements and Information Models. www.ebix.org/documents/Introduction%20to%20ebIX%20Models%200.0.D.pdf as of 03 March 2014
IEC61970-301 Ed. 2, Energy management system application program interface (EMS-API) - Part 301: Common information model (CIM) base, International Electrotechnical Commission (2009)
Jensen, C.S., Pedersen, T.B., Thomsen, C.: Multidimensional Databases and Data Warehousing. Morgan & Claypool, San Rafael (2010)
Konsman, M.J., Rumph, F.J.: MIRABEL Deliverable 2.3: Final data model, specification of request and negotiation messages and contracts. https://www.db.inf.tu-dresden.de/miracle/publications/D2.3.pdf as of 03 March 2014
Malinowski, E., Zimányi, E.: Advanced Data Warehouse Design From Conventional to Spatial and Temporal Applications. Springer, Heidelberg (2009)
Melton, J., Simon, A.R.: SQL:1999 Understanding Relational Language Components. Morgan Kaufmann, Boston (2001)
www.meregio.de/en/ as of 03 March 2014
As of 03 March 2014. www.mirabel-project.eu/
www.postgresql.org as of 03 March 2014
Šikšnys, L., Khalefa, M.E., Pedersen, T.B.: Aggregating and disaggregating flexibility objects. In: Ailamaki, A., Bowers, S. (eds.) SSDBM 2012. LNCS, vol. 7338, pp. 379–396. Springer, Heidelberg (2012)
Siksnys, L., Thomsen, C., Pedersen, T.B.: MIRABEL DW: managing complex energy data in a smart grid. In: Cuzzocrea, A., Dayal, U. (eds.) DaWaK 2012. LNCS, vol. 7448, pp. 443–457. Springer, Heidelberg (2012)
Song, I-Y., et al.: An analysis of many-to-many relationships between fact and dimension tables in dimensional modeling. In: Proceedings of DMDW (2001)
Yu, B., et al.: On managing very large senor-network data using bigtable. In: Proceedings of CCGrid (2012)
Zubcoff, J., Pardillo, J., Trujillo, J.: A UML profile for the conceptual modelling of data-mining with time-series in data warehouses. Inf. Softw. Technol. 51(6), 977–992 (2008)
Author information
Authors and Affiliations
Corresponding author
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2015 Springer-Verlag Berlin Heidelberg
About this chapter
Cite this chapter
Šikšnys, L., Thomsen, C., Pedersen, T.B. (2015). MIRABEL DW: Managing Complex Energy Data in a Smart Grid. In: Hameurlain, A., Küng, J., Wagner, R., Cuzzocrea, A., Dayal, U. (eds) Transactions on Large-Scale Data- and Knowledge-Centered Systems XXI. Lecture Notes in Computer Science(), vol 9260. Springer, Berlin, Heidelberg. https://doi.org/10.1007/978-3-662-47804-2_3
Download citation
DOI: https://doi.org/10.1007/978-3-662-47804-2_3
Published:
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-662-47803-5
Online ISBN: 978-3-662-47804-2
eBook Packages: Computer ScienceComputer Science (R0)