Difference between revisions of "Float Data Hourly"
Jump to navigation
Jump to search
| Line 1: | Line 1: | ||
{| class="wikitable" | {| class="wikitable" | ||
|+ Caption text | |+ Caption text | ||
|- | |- | ||
! Name !! Description !! Comment | ! Name !! Type !!Description !! Comment | ||
|- | |- | ||
| CaseID || Case identifier || | | CaseID || Integer|| Case identifier || | ||
|- | |- | ||
| DataID || Reference | | DataID || Reference || || | ||
|- | |- | ||
| Offset || Time in seconds after admission || | | Offset || Integer|| Time in seconds after admission || | ||
|- | |- | ||
| Val || Value || | | Val || Float || Value || The unit (if applicable) is found in d_references | ||
|- | |- | ||
| cnt || Amount of values aggregated || | | cnt || Integer || Amount of values aggregated || | ||
|- | |- | ||
| rawdata || List of 60 floats containing raw data || Due to excessive storage needs minute values have been aggregated. | | rawdata || Blob || List of 60 floats containing raw data || Due to excessive storage needs minute values have been aggregated. | ||
|} | |} | ||
| Line 23: | Line 22: | ||
Raw values are saved in field data_float_h.rawdata, being a list of bytes. (IEEE 754 Single(4 bytes), LittleEndian) | Raw values are saved in field data_float_h.rawdata, being a list of bytes. (IEEE 754 Single(4 bytes), LittleEndian) | ||
<nowiki><noinclude> | |||
The recommended way to access this data is using our provided software ([[Get Started]]). An example on how to deserialize the raw_data field can be found [[Deserialize Raw Data|here]]. | The recommended way to access this data is using our provided software ([[Get Started]]). An example on how to deserialize the raw_data field can be found [[Deserialize Raw Data|here]]. | ||
</noinclude></nowiki> | |||
Metavision does, in database, not differentiate between qualitative (i.e. blood pressure) and quantitative (i.e. drainage volume) data, this was done programatically saving the sum instead of average. | Metavision does, in database, not differentiate between qualitative (i.e. blood pressure) and quantitative (i.e. drainage volume) data, this was done programatically saving the sum instead of average. | ||
Revision as of 19:50, 31 October 2022
| Name | Type | Description | Comment |
|---|---|---|---|
| CaseID | Integer | Case identifier | |
| DataID | Reference | ||
| Offset | Integer | Time in seconds after admission | |
| Val | Float | Value | The unit (if applicable) is found in d_references |
| cnt | Integer | Amount of values aggregated | |
| rawdata | Blob | List of 60 floats containing raw data | Due to excessive storage needs minute values have been aggregated. |
Aggregation Description
Most signal data is averaged. The field data_float_h.cnt describes the amount of values aggregated. It is to be expected that the first signal values have less than 60 data points, as it is quite unlikely (1:60) that signal starts on minute 0.
Raw values are saved in field data_float_h.rawdata, being a list of bytes. (IEEE 754 Single(4 bytes), LittleEndian) <noinclude> The recommended way to access this data is using our provided software ([[Get Started]]). An example on how to deserialize the raw_data field can be found [[Deserialize Raw Data|here]]. </noinclude> Metavision does, in database, not differentiate between qualitative (i.e. blood pressure) and quantitative (i.e. drainage volume) data, this was done programatically saving the sum instead of average.