Abstract
In a microgrid environment, it’s suitable to store data obtained from the different devices that make up the microgrid in order to have the ability to perform a detailed data analysis later. This article will detail the process followed to store the data that has been collected through the monitoring and control software ‘Home Assistant’ in the microgrid of the CEDER-CIEMAT (Renewable Energy Center in Soria, Spain). The structure of the storage system created for a robust storage of data in the DBMS (Database Management System) MariaDB will be detailed and how to correct the different typical errors that are made in the development process of this storage system. Aspects the operation of the connection between Home Assistant and MariaDB, the configuration to establish communication with each other correctly and the organization of the different structures to be formed in the database created using the programming language SQL (Structured Query Language). It will detail the performance offered by this system together with the transformed data that has been generated for further analysis. Due to the emergence of new storage systems that are better adapted to the field of microgrids, the different alternatives that can be used will be described, which may replace the system developed to improve it.
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
Similar content being viewed by others
References
Miraz, M.H., Ali, M., Excell, P.S., Picking, R.: A review on internet of things (IOT), internet of everything (IOE) and internet of Nano things (IONT). In: 2015 Internet Technologies and Applications (ITA), pp. 219–224 (2015). https://doi.org/10.1109/ITechA.2015.7317398
Weber, R.H., Weber, R.: Introduction, pp. 1–22. Springer, Heidelberg (2010). https://doi.org/10.1007/978-3-642-11710-7_1
Hossein Motlagh, N., Mohammadrezaei, M., Hunt, J., Zakeri, B.: Internet of things (IOT) and the energy sector. Energies 13(2), 404 (2020). https://doi.org/10.3390/en13020494. https://www.mdpi.com/1996-1073/13/2/494
Liu, X., Ansari, N.: Toward green IoT: energy solutions and key challenges. IEEE Commun. Mag. 57(3), 104–110 (2019). https://doi.org/10.1109/MCOM.2019.1800175
Bedi, G., Venayagamoorthy, G.K., Singh, R., Brooks, R.R., Wang, K.C.: Review of internet of things (IoT) in electric power and energy systems. IEEE Internet of Things J. 5(2), 847–870 (2018). https://doi.org/10.1109/JIOT.2018.2802704
Zubieta, L.E.: Power management and optimization concept for DC microgrids. In: 2015 IEEE First International Conference on DC Microgrids (ICDCM), pp. 81–85 (2015). https://doi.org/10.1109/ICDCM.2015.7152014
Islam, M., Lee, H.H.: Microgrid communication network with combined technology. In: 2016 5th International Conference on Informatics, Electronics and Vision (ICIEV), pp. 423–427 (2016). https://doi.org/10.1109/ICIEV.2016.7760039
Hatziargyriou, N.: The microgrids concept. In: Microgrids: Architectures and Control, pp. 1–24 (2014). https://doi.org/10.1002/9781118720677.ch01
Asiminidis, C., Georgiadis, I., Syndoukas, D., Kokkonis, G., Kontogiannis, S.: Performance evaluation on encrypted - non encrypted database fields containing IOT data. In: Proceedings of the 23rd International Database Applications and Engineering Symposium, IDEAS 2019. Association for Computing Machinery, New York, NY, USA (2019). https://doi.org/10.1145/3331076.3331097
Rautmare, S., Bhalerao, D.M.: MySQL and NoSQL database comparison for IOT application. In: 2016 IEEE International Conference on Advances in Computer Applications (ICACA), pp. 235–238 (2016). https://doi.org/10.1109/ICACA.2016.7887957
Reetishwaree, S., Hurbungs, V.: Evaluating the performance of SQL and NoSQL databases in an IOT environment. In: 2020 3rd International Conference on Emerging Trends in Electrical, Electronic and Communications Engineering (ELECOM), pp. 229–234 (2020). https://doi.org/10.1109/ELECOM49001.2020.9297028
Ming, D., Tian, X., Lei, W.: Research of real-time database system for microgrid. In: The 2nd International Symposium on Power Electronics for Distributed Generation Systems, pp. 708–712 (2010). https://doi.org/10.1109/PEDG.2010.5545839
Mariadb foundation (2019). https://mariadb.org/
Izquierdo-Monge, O., et al.: Conversion of a network section with loads, storage systems and renewable generation sources into a smart microgrid. Appl. Sci. 11(11), 5012 (2021). https://doi.org/10.3390/app11115012. https://www.mdpi.com/2076-3417/11/11/5012
Pi, R.: Raspberry Pi 4 model B specifications. https://www.raspberrypi.org/products/raspberry-pi-4-model-b/specifications/
Home Assistant. https://www.home-assistant.io/
Author information
Authors and Affiliations
Corresponding author
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2022 Springer Nature Switzerland AG
About this paper
Cite this paper
Izquierdo-Monge, O., Martin-Jimenez, G., Peña-Carro, P. (2022). Development and Improvement of a Data Storage System in a Microgrid Environment with HomeAssistant and MariaDB. In: Nesmachnow, S., Hernández Callejo, L. (eds) Smart Cities. ICSC-Cities 2021. Communications in Computer and Information Science, vol 1555. Springer, Cham. https://doi.org/10.1007/978-3-030-96753-6_19
Download citation
DOI: https://doi.org/10.1007/978-3-030-96753-6_19
Published:
Publisher Name: Springer, Cham
Print ISBN: 978-3-030-96752-9
Online ISBN: 978-3-030-96753-6
eBook Packages: Computer ScienceComputer Science (R0)