Data Storage and Maintenance Challenges: The Case of Advanced Metering Infrastructure Systems

12 pages•Published: May 10, 2018

Lucas Pereira, Rodolfo Gonçalves, Filipe Quintal and Nuno Nunes

Abstract

In today’s digital age, massive amounts of data are steadily being generated from various sources, such as smart-phones and social media. Smart-Grids are among the fields that are currently experiencing a burst in the data being generated, in part due to the recent investments in Advanced Metering Infrastructure Systems. In this paper, we present a benchmark between MySQL and MongoDB, when used to store and maintain the data that results from Advanced Metering Infrastructure Systems deployments. Our results show that MongoDB clearly outperforms MySQL for reading operations but at a cost of a much larger database size. As such, when deploying such systems, developers should be aware of this important trade-off that may greatly affect the overall experience.

Keyphrases: benchmark, dataset, energy monitoring, nosql, rdbms

In: Birgit Penzenstadler, Steve Easterbrook, Colin Venters and Syed Ishtiaque Ahmed (editors). ICT4S2018. 5th International Conference on Information and Communication Technology for Sustainability, vol 52, pages 289-300.

Links:	https://easychair.org/publications/paper/bZcp
	https://doi.org/10.29007/x6sn

BibTeX entry

@inproceedings{ICT4S2018:Data_Storage_Maintenance_Challenges,
  author    = {Lucas Pereira and Rodolfo Gonçalves and Filipe Quintal and Nuno Nunes},
  title     = {Data Storage and Maintenance Challenges: The Case of Advanced Metering Infrastructure Systems},
  booktitle = {ICT4S2018. 5th International Conference on Information and Communication Technology for Sustainability},
  editor    = {Birgit Penzenstadler and Steve Easterbrook and Colin Venters and Syed Ishtiaque Ahmed},
  series    = {EPiC Series in Computing},
  volume    = {52},
  publisher = {EasyChair},
  bibsource = {EasyChair, https://easychair.org},
  issn      = {2398-7340},
  url       = {/publications/paper/bZcp},
  doi       = {10.29007/x6sn},
  pages     = {289-300},
  year      = {2018}}

Download PDF Open PDF in browser