Business' relevance
Whereas CQ1 starts with an active moiety, and identifies all substances having that common active moiety, CQ2 starts with a substance and identifies the active moiety for the substance. A substance is defined as a matter of defined composition that has discrete existence, whose origin may be biological, mineral or chemical. A moiety is an entity within a substance that has a complete and continuous molecular structure. The strength of a pharmaceutical product is often based on what is referred to as the active moiety of the molecule, responsible for the physiological or pharmacological action of the drug substance. Linking a substance and it's active moiety not only gives immediate clarity on how the substance potentially exerts it's pharmacological activity, but also (due to the way the ontology is modeled) gives an overview of how active moieties can be differently defined under different contexts.
Diagram for model pattern
Diagram 1: Query pattern diagram for SPARQL Query
Test Data
Amlodipine example: https://github.com/edmcouncil/idmp/blob/master/EXT/Examples/AmlodipineExample.rdf
Terlipressin Example: https://github.com/edmcouncil/idmp/blob/master/EXT/Examples/TerlipressinExample.rdf
SPARQL Query
https://github.com/edmcouncil/idmp/blob/master/etc/CQ/Example/uc1_cq2.sparql