Amount of data to store in E-SOH

[lukas-phaf]

We need to define how much data is going to be stored in E-SOH datastore.

We need the following information:

• Storage duration: 24 hours
• Number of stations: 5000?
• Average number of parameter per station:
• Measurement frequency for each parameter:
• Will each station have mostly the same parameters, or very different parameters?

The database design/choice also depends on the number of writes to the database. While the numbers above give the total amount of data to be written per minute, we also need to now if the writes are aggregated or not. Is the data written seperately per parameter, per station, or per country?

As the datastore design might also depend on the number and type of data requests, we should also define those:

• How many queries and of which type should the data store support (for example: x queries of 24 hours worth of observations for a station, and y queries for the last measurement of a station.