IOT Architecture

Topology

The IOT system has been designed to take sensor readings from multiple devices and link them to known cells in laboratories, this can be used to extract live experimental data or for environmental & audit purposes.

Sensor 1
IOT Gateway
Sensor 2
Sensor 3
DataFlow processing
BigQuery IOT Data
Alerts

DB Schema

Sensors send a json packet containing the following fields. This allows a sensor package to send readings from multiple probes at a given time. e.g send the temperature, humidity and battery voltage.

SensorReadingTIMESTAMP timestampSTRING deviceIdSTRING sensor1IdNUMERIC sensor1ValueSTRING sensor2IdNUMERIC sensor2ValueSTRING sensor3IdNUMERIC sensor3Value

(timestamp and deviceId are required fields)