I am looking to get the ‘Chemical Structure’ class’ tree hierarchy from both the RELATIONSHIP and CONCEPT table joined.
I’ve queried for the ‘Chemical Structure’ concept class and the ‘Is a’ relationships to get the child-parent relationships of the tree/graph. While doing so, I realized that some of the concepts in CONCEPT_ID_1 and CONCEPT_ID_2 are invalid (D), but the ‘Is a’ relationship still shows as valid. What is the reason for this?
I would think that if, a ‘Chemical Structure’ concept gets invalidated in the CONCEPT table, its ‘Is a’ and ‘subsumes’ relationships would get invalidated as well. At least the ‘subsumes’ relationship should get deleted. Given that this concept got deleted, its children would not exist anymore. Is this logic correct?
Thank you for any clarification.