Float Data Hourly - Revision history

Salkin: Replaced content with "{{:Data Description Data Float h}}"

2022-10-31T19:52:47Z

Replaced content with "{{:Data Description Data Float h}}"

← Older revision		Revision as of 19:52, 31 October 2022
Line 1:		Line 1:
			{{:Data Description Data Float h}}
	{~~\| class="wikitable"~~
	~~\|+ Caption text~~
	\|-
	~~! 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.~~

Salkin at 19:51, 31 October 2022

2022-10-31T19:51:08Z

← Older revision		Revision as of 19:51, 31 October 2022
Line 22:		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>		<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~~>		</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.		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.

Salkin at 19:50, 31 October 2022

2022-10-31T19:50:31Z

← Older revision		Revision as of 19:50, 31 October 2022
Line 1:		Line 1:
	~~== Raw Fields of data_float_h ==~~

	{\| class="wikitable"		{\| class="wikitable"
	\|+ Caption text		\|+ Caption text
	\|-		\|-
	! Name !! Description !! Comment		! Name !! Type !!Description !! Comment
	\|-		\|-
	\| CaseID \|\| Case identifier \|\|		\| CaseID \|\| Integer\|\| Case identifier \|\|
	\|-		\|-
	\| DataID \|\| Reference ~~stored in d_references~~ \|\| ~~DataID=ReferenceGlobalID~~		\| 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.

	~~== Known Limitations ==~~
	~~=== 0 Values ===~~
	All values were aggregated to hourly average values. As in many cases Metavision saves 0 values during signal loss times instead of NULL aggregating these would significantly influence statistics. Think about a patient with constant MAP of 60 is disconnected for 15min, aggregating would result in a average MAP of 45. For this reason 0 values were set to NULL and ignored. This behaviour is expected to represent in nearly all cases the most likely value.

	~~In very special cases, like cardioplegia, where 0 would be a correct pulse rate, expect values to be missing. Contact developer in case you need this data.~~

Salkin at 16:19, 8 October 2022

2022-10-08T16:19:57Z

← Older revision		Revision as of 16:19, 8 October 2022
Line 23:		Line 23:

	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)

			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]].

	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.

Salkin at 16:13, 8 October 2022

2022-10-08T16:13:18Z

← Older revision		Revision as of 16:13, 8 October 2022
Line 1:		Line 1:
	== Raw Fields ==		== Raw Fields of data_float_h ==

	{\| class="wikitable"		{\| class="wikitable"

Salkin: Created page with "== Raw Fields == {| class="wikitable" |+ Caption text |- ! Name !! Description !! Comment |- | CaseID || Case identifier || |- | DataID || Reference stored in d_references || DataID=ReferenceGlobalID |- | Offset || Time in seconds after admission || |- | Val || Value || |- | cnt || Amount of values aggregated || |- | rawdata || List of 60 floats containing raw data || Due to excessive storage needs minute values have been aggregated. |} == Aggregation Descr..."

2022-10-08T16:11:24Z

Created page with "== Raw Fields == {| class="wikitable" |+ Caption text |- ! Name !! Description !! Comment |- | CaseID || Case identifier || |- | DataID || Reference stored in d_references || DataID=ReferenceGlobalID |- | Offset || Time in seconds after admission || |- | Val || Value || |- | cnt || Amount of values aggregated || |- | rawdata || List of 60 floats containing raw data || Due to excessive storage needs minute values have been aggregated. |} == Aggregation Descr..."

New page

== Raw Fields ==

{| class="wikitable"
|+ Caption text
|-
! Name !! Description !! Comment
|-
| CaseID || Case identifier ||
|-
| DataID || Reference stored in d_references || DataID=ReferenceGlobalID
|-
| Offset || Time in seconds after admission ||
|-
| Val || Value ||
|-
| cnt || Amount of values aggregated ||
|-
| rawdata || 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)

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.

== Known Limitations ==
=== 0 Values ===
All values were aggregated to hourly average values. As in many cases Metavision saves 0 values during signal loss times instead of NULL aggregating these would significantly influence statistics. Think about a patient with constant MAP of 60 is disconnected for 15min, aggregating would result in a average MAP of 45. For this reason 0 values were set to NULL and ignored. This behaviour is expected to represent in nearly all cases the most likely value.

In very special cases, like cardioplegia, where 0 would be a correct pulse rate, expect values to be missing. Contact developer in case you need this data.