This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision | ||
documentation:cdm:concept_ancestor [2017/09/25 14:58] clairblacketer |
documentation:cdm:concept_ancestor [2017/10/02 21:29] (current) aostropolets |
||
---|---|---|---|
Line 11: | Line 11: | ||
|min_levels_of_separation|Yes|integer|The minimum separation in number of levels of hierarchy between ancestor and descendant concepts. This is an attribute that is used to simplify hierarchic analysis.| | |min_levels_of_separation|Yes|integer|The minimum separation in number of levels of hierarchy between ancestor and descendant concepts. This is an attribute that is used to simplify hierarchic analysis.| | ||
|max_levels_of_separation|Yes|integer|The maximum separation in number of levels of hierarchy between ancestor and descendant concepts. This is an attribute that is used to simplify hierarchic analysis.| | |max_levels_of_separation|Yes|integer|The maximum separation in number of levels of hierarchy between ancestor and descendant concepts. This is an attribute that is used to simplify hierarchic analysis.| | ||
+ | |||
+ | |||
+ | A path between two concepts can be characterized by the sequence of relationships that need to be traversed in order to reach a descendant concept from an ancestor concept. | ||
+ | |||
+ | For example, for concepts | ||
+ | |||
+ | ^descendant_concept_id^descendant_concept_name^ancestor_concept_id^ancestor_concept_name^min_levels_of_separation^max_levels_of_separation^ | ||
+ | |313217|Atrial fibrillation|321588|Heart disease|3|4| | ||
+ | |||
+ | the shortest path in concept_relationship will be : | ||
+ | |||
+ | 313217 Atrial fibrillation **Is a** 4226399 Fibrillation **Is a** | ||
+ | 44784217 Cardiac arrhythmia **Is a** 321588 Heart disease | ||
+ | |||
+ | the longest: | ||
+ | |||
+ | 313217 Atrial fibrillation **Is a** 4068155 Atrial arrhythmia **Is a** | ||
+ | 4248028 Supraventricular arrhythmia **Is a** 44784217 Cardiac arrhythmia **Is a** | ||
+ | 321588 Heart disease | ||
+ | |||
+ | {{:documentation:cdm:concept_ancestor.png?200|}} | ||
==== Conventions ==== | ==== Conventions ==== | ||
Line 17: | Line 38: | ||
* Only valid and Standard Concepts participate in the CONCEPT_ANCESTOR table. It is not possible to find ancestors or descendants of deprecated or Source Concepts. | * Only valid and Standard Concepts participate in the CONCEPT_ANCESTOR table. It is not possible to find ancestors or descendants of deprecated or Source Concepts. | ||
* Usually, only Concepts of the same Domain are connected through records of the CONCEPT_ANCESTOR table, but there might be exceptions. | * Usually, only Concepts of the same Domain are connected through records of the CONCEPT_ANCESTOR table, but there might be exceptions. | ||
- |