[Top][All Lists]

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

[Gnumed-devel] Re: GNUmed substance schema was Re: GNUmed and FreeDiams

From: Jim Busser
Subject: [Gnumed-devel] Re: GNUmed substance schema was Re: GNUmed and FreeDiams
Date: Mon, 03 Jan 2011 11:20:22 -0800

On 2011-01-02, at 10:01 PM, Jim Busser wrote:

>> I *could* script a replacement of the [substance] names, keying on the ATCs…
> … however in some cases this would make the substance name less informative,

Even if I did not *globally* replace the substance names prior to import into 
GNUmed, the 21148 originally indistinct substances, upon

        SELECT DISTINCT molecule_name || " " || amount || " " || units

boils down to less than a third (6802) which IMO become quite manageable, 
because a phrasewheel would quickly limit them after 3 characters, e.g. "ram… " 
would list

        "RAMIPRIL 1.25 MG"
        "RAMIPRIL 10.0 MG"
        "RAMIPRIL 15.0 MG"
        "RAMIPRIL 2.5 MG"
        "RAMIPRIL 5.0 MG"

On further review, on the question of collapsing substance name variants, I 
found a saner way to do it, which is to collapse them only in the presence of a 
salt component because – where the salt is relevant – it already forms part of 
the official INN e.g. the following are INN salts

        calcium chloride
        calcium gluconate
        ferrous fumarate

and relevant en_CA strings to collapse will be

        "chloride" , "bromide", "sodium" , "malate", "sulfate", "besylate",
        "mesylate", "mesilate", "hydrate", "calcium", "nitrate", "tartrate",
        "acetate", "gluconate", "phosphate"

-- Jim

reply via email to

[Prev in Thread] Current Thread [Next in Thread]