GUS Schema >> RAD::HQSpecificity (subclass of RAD::AnalysisResult )

This view of AnalysisResultImp is for the results of analyses done with the H-Q specificity protocol. The output of such an analysis consists of a tree (e.g. based on an anatomical hierarchy) for each (composite) element examined, where the nodes of the tree store the values for the global and local Shannon entropy and weights.

Light yellow rows indicate columns provided from the superclass.

column nulls? type description
ANALYSIS_RESULT_ID no NUMBER(12,0) primary key Edit
SUBCLASS_VIEW no STRING(27) name of the view Edit
ANALYSIS_ID no RAD::Analysis (NUMBER(8,0) )FK to Analysis. The analysis this result refers to. Edit
TABLE_ID Core::TableInfo (NUMBER(5,0) ) Edit
ROW_ID NUMBER(12,0) Edit
NODE_NUMBER NUMBER(8,0) The number corresponding to the node in the tree to which these results refer. Edit
PARENT_NODE_NUMBER NUMBER(8,0) The number corresponding to the node in the tree which is the parent of the current node. Edit
LEAF_COUNT NUMBER(8,0) The number of leaf nodes at or below this node. Is one for every leaf node and strictly greater than one otherwise (assuming the tree has no 'only' children). Edit
H_G FLOATThe value of the global Shannon entropy at the current node, i.e. the entropy w.r.t. the leaves in the tree. Edit
H_L FLOATThe value of the local Shannon entropy at the current node, i.e. the entropy w.r.t. the immediate children of this node. Edit
I_G FLOATThe value of the global Shannon information at the current node, i.e., the information content w.r.t. the leaves of the tree. This is a derived value computed from h_g and node_number and stored for efficiency. Edit
W FLOATThe weight of the current node. Edit
MINUS_LOG2_W FLOATThe negative log (base 2) of w. Derived quantity stored for query efficiency. Edit
EXPRESSION_LEVEL FLOAT Edit
MAX_EXPRESSION_LEVEL_BELOW FLOAT Edit

Child tables:

Subclasses: