search

ERNI-CoP-IoT / dust-measurement-network

Dust Measurement Network - air pollution data measurement
https://dmn.azurewebsites.net/
MIT License
1 stars 0 forks source link

ProdREQ - Read data taken by detector from the Time Series DB #6

Open dniklaus opened 3 years ago

dniklaus commented 3 years ago

Issue by dniklaus Mon Jul 23 14:40:13 2018 Originally opened as https://github.com/ERNICommunity/dust-measurement-network/issues/2

ID: ProdREQ-01

Break down

  1. DB Schema:
    • time series of data
    • detector ID
    • detector location
    • predictions
    • prediction-actual data
  2. Use entity FW for bringing data to app

Notes

Actions

To be done before or during the event

dniklaus commented 3 years ago

Comment by mareklinka Thu Aug 30 11:18:33 2018

As far as I understand it, the influx DB has been decided on, no? If the BE team can live with Influx, I'm fine with it.

@yohny Can you confirm you are expecting Influx?

dniklaus commented 3 years ago

Comment by yohny Thu Aug 30 12:16:12 2018

Yes, we expect sensor data to be present in Influx db. From there we will take them to SQL (just a bit more agregated for our purposes) and enhance them with additional properties neeeded for Machine learning.

dniklaus commented 3 years ago

Comment by mareklinka Thu Aug 30 12:33:31 2018

Very well, marking the timeseries DB research as closed and reassigning this to the BE team. @yohny please forward this to whoever should be working on this.