Analyze approximately how many synonyms are used for each compound and whether we should retain multiple names. If so we need a translation table, here is a simple example.
I would suggest we normalize on the Wikidata name for a compound and change instances of synonyms to the preferred name. We may need a synonym table which is an n:1 mapping of synonyms to preferred name.
Analyze approximately how many synonyms are used for each compound and whether we should retain multiple names. If so we need a translation table, here is a simple example.
https://stackoverflow.com/questions/19672708/how-to-arrange-database-for-finding-a-word-by-searching-with-synonyms-that-i-def?rq=1
I would suggest we normalize on the Wikidata name for a compound and change instances of synonyms to the preferred name. We may need a synonym table which is an n:1 mapping of synonyms to preferred name.