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: Simplified version showing the linking of a substance to an active moiety. The property "has active moiety" uses a shortcut for the pattern shown in Figure 2.
Diagram 2: Linking a substance to an active moiety. This patterns allows traversing the model to find all substances that participate in some substance constituency whose active moiety role is played by some moiety (which in the regulatory context is another substance). * A substance constituency defines some substance based on its relationship(s) to some other substance (ingredient) or moiety, potentially in some amount, in some context.
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