documentation:cdm:concept_ancestor
Differences
This shows you the differences between two versions of the page.
| Next revision | Previous revision Next revision Both sides next revision | ||
|
documentation:cdm:concept_ancestor [2014/11/15 03:16] cgreich created |
documentation:cdm:concept_ancestor [2017/08/17 15:20] clairblacketer |
||
|---|---|---|---|
| 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]]** | ||
| - | 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. |
| This table is entirely derived from the CONCEPT, CONCEPT_RELATIONSHIP and RELATIONSHIP tables. | This table is entirely derived from the CONCEPT, CONCEPT_RELATIONSHIP and RELATIONSHIP tables. | ||
documentation/cdm/concept_ancestor.txt ยท Last modified: 2017/10/02 21:29 by aostropolets
Page Tools
