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

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.