In a Spine DB, different parameter_value types are included in a separate column, e.g. time_series for a time series, array, etc.
separate the value column into these type specific tables, replace the blobs with a row-range(s), or equivalent
type specific tables can then be regular tables (no BLOBs), and we can now query them
how to support multiple dimensions (multi-index) for map data? Currently map data type is mostly used (afaict) to represent time_series with multi-index, check if there are other uses.
In a Spine DB, different
parameter_valuetypes are included in a separate column, e.g.time_seriesfor a time series,array, etc.valuecolumn into these type specific tables, replace the blobs with a row-range(s), or equivalentBLOBs), and we can now query themmapdata? Currentlymapdata type is mostly used (afaict) to representtime_serieswith multi-index, check if there are other uses.