Signal Data - Revision history

Salkin at 14:51, 10 October 2022

2022-10-10T14:51:27Z

← Older revision		Revision as of 14:51, 10 October 2022
Line 5:		Line 5:
	Important note: Data stored in [[data_float_h]] is aggregated hourly data.		Important note: Data stored in [[data_float_h]] is aggregated hourly data.

	== Predefined Fields (RooDataServer) ==		== Predefined Fields ([[RooDataServer]]) ==

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

Salkin at 16:12, 8 October 2022

2022-10-08T16:12:58Z

← Older revision		Revision as of 16:12, 8 October 2022
Line 32:		Line 32:

	{{:Float Data Hourly}}		{{:Float Data Hourly}}
	~~-------~~

	~~== 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.~~

Salkin at 16:12, 8 October 2022

2022-10-08T16:12:47Z

← Older revision		Revision as of 16:12, 8 October 2022
Line 31:		Line 31:
	\|}		\|}

	{{Float Data Hourly}}		{{:Float Data Hourly}}
	-------		-------

Salkin at 16:11, 8 October 2022

2022-10-08T16:11:48Z

← Older revision		Revision as of 16:11, 8 October 2022
Line 30:		Line 30:

	\|}		\|}

			{{Float Data Hourly}}
			-------

	== Raw Fields ==		== Raw Fields ==

Salkin at 16:35, 18 September 2022

2022-09-18T16:35:06Z

← Older revision		Revision as of 16:35, 18 September 2022
Line 29:		Line 29:


			\|}

			== 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.
	\|}		\|}

Salkin at 16:30, 18 September 2022

2022-09-18T16:30:18Z

← Older revision		Revision as of 16:30, 18 September 2022
Line 2:		Line 2:

	Various types of signal data has been included in the SICDb dataset. Signal data is saved in [[data_float_h]] table, value reference is found in d_references.		Various types of signal data has been included in the SICDb dataset. Signal data is saved in [[data_float_h]] table, value reference is found in d_references.

			Important note: Data stored in [[data_float_h]] is aggregated hourly data.

	== Predefined Fields (RooDataServer) ==		== Predefined Fields (RooDataServer) ==

Salkin: /* Data Description */

2022-09-11T11:05:29Z

Data Description

← Older revision		Revision as of 11:05, 11 September 2022
Line 1:		Line 1:
	== Data Description ==		== Data Description ==

	Various types of signal data has been included in the SICDb dataset. Signal data is saved in [[data_float_h]] table, value ~~encoding~~ is found in d_references.		Various types of signal data has been included in the SICDb dataset. Signal data is saved in [[data_float_h]] table, value reference is found in d_references.

	== Predefined Fields (RooDataServer) ==		== Predefined Fields (RooDataServer) ==

Salkin: /* Predefined Fields (RooDataServer) */

2022-09-11T11:05:02Z

Predefined Fields (RooDataServer)

← Older revision		Revision as of 11:05, 11 September 2022
Line 19:		Line 19:
	\|-		\|-
	\| SignalHoursUnderX \|\| Amount of hours, where the average signal value is under X \|\| \|\| [[Offsetable\|O]] [[Detailfield\|D]]		\| SignalHoursUnderX \|\| Amount of hours, where the average signal value is under X \|\| \|\| [[Offsetable\|O]] [[Detailfield\|D]]
			\|-
			\| SignalHoursOverX \|\| Amount of hours, where the average signal value is >= X \|\| \|\| [[Offsetable\|O]] [[Detailfield\|D]]
			\|-
			\| SignalHoursBetweenXY \|\| Amount of hours, where the average signal value is >=Min and <Max\|\| \|\| [[Offsetable\|O]] [[Detailfield\|D]]
			\|-
			\| SignalStd \|\| Standard deviation of average hourly values of selected signal\|\| \|\| [[Offsetable\|O]] [[Detailfield\|D]]


	\|}		\|}

Salkin: /* Predefined Fields (RooDataServer) */

2022-09-11T10:58:50Z

Predefined Fields (RooDataServer)

← Older revision		Revision as of 10:58, 11 September 2022
Line 6:		Line 6:

	{\| class="wikitable"		{\| class="wikitable"
	\|+ ~~Caption text~~		\|+ Generic Signal
	\|-		\|-
	! Name !! Description !! Comment !! Type		! Name !! Description !! Comment !! Type
Line 21:		Line 21:

	\|}		\|}


	== Aggregation Description ==		== Aggregation Description ==

Salkin at 10:58, 11 September 2022

2022-09-11T10:58:35Z

← Older revision		Revision as of 10:58, 11 September 2022
Line 2:		Line 2:

	Various types of signal data has been included in the SICDb dataset. Signal data is saved in [[data_float_h]] table, value encoding is found in d_references.		Various types of signal data has been included in the SICDb dataset. Signal data is saved in [[data_float_h]] table, value encoding is found in d_references.

			== Predefined Fields (RooDataServer) ==

			{\| class="wikitable"
			\|+ Caption text
			\|-
			! Name !! Description !! Comment !! Type
			\|-
			\| SignalCountHours \|\| Amount of hours where selected signal data is available\|\| \|\| [[Offsetable\|O]] [[Detailfield\|D]]
			\|-
			\| SignalAvg \|\| Average signal value of selected signal \|\| \|\| [[Offsetable\|O]] [[Detailfield\|D]]
			\|-
			\| SignalMin \|\| Minimum hourly average signal value of selected signal \|\| \|\| [[Offsetable\|O]] [[Detailfield\|D]]
			\|-
			\| SignalMax \|\| Maximum hourly average signal value of selected signal \|\| \|\| [[Offsetable\|O]] [[Detailfield\|D]]
			\|-
			\| SignalHoursUnderX \|\| Amount of hours, where the average signal value is under X \|\| \|\| [[Offsetable\|O]] [[Detailfield\|D]]

			\|}


	== Aggregation Description ==		== Aggregation Description ==