search

opensensorhub / osh-core

OpenSensorHub Core Modules
http://docs.opensensorhub.org
Mozilla Public License 2.0
32 stars 16 forks source link

Store observation data more efficiently in H2 store #162

Open alexrobin opened 3 years ago

alexrobin commented 3 years ago

ObsData objects are currently stored as-is which is very redundant since the FOI ID and UID are stored every time. We should store only results and get FOI and datastream ID from the parent series.

Obs parameters and geometry could be stored in a separate table and fetched only when needed.

alexrobin commented 2 years ago

Some improvements have been made since UIDs are not stored with each obs anymore. We could still avoid storing the FOI and datastream internal IDs since we can get them from the series.