|
Efficient Data Storage & Retrieval of Electricity Consumption Data (B)Status: AbgeschlossenBackgroundThis student project is a part of our our ongoing project Innovative Services based on Smart Meters, in which we collaborate with two Swiss energy providers. Within the last year, we instrumented multiple test households with different sensors, measuring values such as the electricity consumption of each household, occupancy, or consumption of individual appliances. The underlying technology has been developed in previous student projects: "Smart meters in the field - A sensor framework for a real world deployment" and "Integrating submeters to individually monitor appliances".ChallengeIn the context of the projects, we collect massive amounts of data in real time on our server. In total, this accounts for roughly 150MB of data per day, which must be stored, analyzed, and retrieved in real time. Our system relies on a MySQL database, which is easy to set up and interact with. However, to achieve scalability for future deployments, we are actively investigating NoSQL databases, which are based on key-value storage of data records.ObjectivesThe goal of this project is to realize a smart energy data storage system based on the data we collected (and are still collecting) in our test households. This contains the following steps:
Image source: https://smoothspan.files.wordpress.com/2011/07/nosql-databases.png Contact/Ansprechpartner: Christian Beckel |
  |
