A current system allows data-driven hypothesis generation to identify therapeutic candidates for a disease phenotype treatment by identifying drugs and clinical indications associated with lower occurrences of disease-associated phenotype(s) by a drug/drug class. A current system may include a pharmaceutical hierarchical ontology; a phenotype hierarchical ontology; a record database comprising clinical event records; a database mining engine; and a mapping engine. The database mining engine may iteratively progress through a portion of the pharmacological hierarchical ontology and phenotype hierarchical ontology to iteratively select pairs of cohort entries from each ontology; and for each pair of cohort entries, query the clinical record database for matching records. The mapping engine may map each pair of cohort entries into a matrix comprising a drug-event cell for each pair and apply a value thereto representing the number of database records matching items returned by the database mining engine for the corresponding cohort entries.