This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision Last revision Both sides next revision | ||
documentation:cdm:concept_ancestor [2017/08/17 15:20] clairblacketer |
documentation:cdm:concept_ancestor [2017/10/02 19:31] aostropolets |
||
---|---|---|---|
Line 1: | Line 1: | ||
===== CONCEPT_ANCESTOR table ===== | ===== CONCEPT_ANCESTOR table ===== | ||
- | **The CDM documentation is now being housed on [[https://github.com/OHDSI/CommonDataModel/wiki|github]]. The most recent release is [[https://github.com/OHDSI/CommonDataModel/releases/tag/v5.2.-bugfix.1|v5.2]]** | + | **THIS IS OUTDATED. All documentation is now on the [[https://github.com/OHDSI/CommonDataModel/wiki|github wiki]]. Please refer there or to the [[projects:workgroups:cdm-wg|CDM working group]] for more information** |
The CONCEPT_ANCESTOR table is designed to simplify observational analysis by providing the complete hierarchical relationships between Concepts. Only direct parent-child relationships between Concepts are stored in the CONCEPT_RELATIONSHIP table. To determine higher level ancestry connections, all individual direct relationships would have to be navigated at analysis time. The CONCEPT_ANCESTOR table includes records for all parent-child relationships, as well as grandparent-grandchild relationships and those of any other level of lineage. Using the CONCEPT_ANCESTOR table allows for querying for all descendants of a hierarchical concept. For example, drug ingredients and drug products are all descendants of a drug class ancestor. | The CONCEPT_ANCESTOR table is designed to simplify observational analysis by providing the complete hierarchical relationships between Concepts. Only direct parent-child relationships between Concepts are stored in the CONCEPT_RELATIONSHIP table. To determine higher level ancestry connections, all individual direct relationships would have to be navigated at analysis time. The CONCEPT_ANCESTOR table includes records for all parent-child relationships, as well as grandparent-grandchild relationships and those of any other level of lineage. Using the CONCEPT_ANCESTOR table allows for querying for all descendants of a hierarchical concept. For example, drug ingredients and drug products are all descendants of a drug class ancestor. | ||
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^ | ||
+ | |4047584|Lengthening of extraocular muscle|4301351|Surgical procedure|3|6| | ||
+ | |||
+ | the shortest path in concept_relationship will be : | ||
+ | |||
+ | 4047584 Lengthening of extraocular muscle **Is a** 4214521 Strabismus **Is a** | ||
+ | 4132804 Surgical procedure for clinical finding and/or disorder **Is a** 4301351Surgical procedure | ||
+ | |||
+ | the longest: | ||
+ | |||
+ | 4047584 Lengthening of extraocular muscle **Is a** 4214521 Strabismus surgery **Is a** | ||
+ | 4070457 Operation on extraocular muscle **Is a** 4333146 Surgical procedure on orbit **Is a** | ||
+ | 4154279 Surgical procedure on eye region **Is a** 4233946 Operative procedure on head **Is a** | ||
+ | 4301351 Surgical procedure | ||
==== Conventions ==== | ==== Conventions ==== |