System and method for data mining very large drugs and clinical effects databases

A system for transforming cumulative clinical adverse events data into a visual representation for improved understanding of differential clinical outcomes, comprising:

• a pharmacological hierarchical ontology of drug identifications;
• a phenotype hierarchical ontology of clinical adverse effects and clinical indications;
• a clinical record database comprising records containing clinical event information, each record including (a) demographic information for a patient experiencing a clinical event, (b) clinical indication information for the patient experiencing the clinical event, (c) drug identification information associated with the clinical event, (d) adverse reaction information associated with the clinical event, and (e) patient outcome information;
• a database mining engine configured to,
• iteratively progress through at least a selected portion of each of the pharmacological hierarchical ontology and the phenotype hierarchical ontology to iteratively select respective pairs of cohort entries from each of the pharmacological hierarchical ontology and the phenotype hierarchical ontology, and
• for each pair of cohort entries, query the clinical record database for the database records matching the items in the pair of cohort entries;
• and
• a mapping engine configured to,
• map each pair of cohort entries into a data matrix comprising a cell for each pair of cohort entries,
• apply a value associated with a drug-drug-event interaction to each cell which is, at least in part a function of a number of expected occurrences of the drug-drug-event interaction and a number of actual occurrences of the drug-drug-event interaction returned by the mapping engine, and
• provide a visual representation of the data matrix including each mapped pair of cohort entries and each applied value.