[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
"ate)"
"chloride" , "bromide", "sodium" , "malate", "sulfate", "besylate",
"mesylate", "mesilate", "hydrate", "calcium", "nitrate", "tartrate",
"acetate", "gluconate", "phosphate"
-- Jim
- Re: [Gnumed-devel] Re: GNUmed and FreeDiams, (continued)
- Re: [Gnumed-devel] Re: GNUmed and FreeDiams, Karsten Hilbert, 2011/01/01
- Re: [Gnumed-devel] Re: GNUmed and FreeDiams, Jim Busser, 2011/01/01
- Re: [Gnumed-devel] Re: GNUmed and FreeDiams, Jim Busser, 2011/01/01
- Re: [Gnumed-devel] Re: GNUmed and FreeDiams, Karsten Hilbert, 2011/01/02
- Re: [Gnumed-devel] Re: GNUmed and FreeDiams, Jim Busser, 2011/01/02
- [Gnumed-devel] GNUmed substance schema was Re: GNUmed and FreeDiams, Jim Busser, 2011/01/03
- [Gnumed-devel] Re: GNUmed substance schema was Re: GNUmed and FreeDiams,
Jim Busser <=
- [Gnumed-devel] Re: GNUmed substance schema was Re: GNUmed and FreeDiams, Jim Busser, 2011/01/03
- Re: [Gnumed-devel] Re: GNUmed substance schema was Re: GNUmed and FreeDiams, Eric Maeker, 2011/01/03
- Re: [Gnumed-devel] Re: GNUmed substance schema was Re: GNUmed and FreeDiams, Jim Busser, 2011/01/04
- Re: [Gnumed-devel] Re: GNUmed substance schema was Re: GNUmed and FreeDiams, Karsten Hilbert, 2011/01/04
- Re: [Gnumed-devel] Re: GNUmed substance schema was Re: GNUmed and FreeDiams, Karsten Hilbert, 2011/01/04
- Re: [Gnumed-devel] Re: GNUmed substance schema was Re: GNUmed and FreeDiams, Jim Busser, 2011/01/04
- Re: [Gnumed-devel] Re: GNUmed substance schema was Re: GNUmed and FreeDiams, Karsten Hilbert, 2011/01/04
- Re: [Gnumed-devel] Re: GNUmed substance schema was Re: GNUmed and FreeDiams, Jim Busser, 2011/01/04
- Re: [Gnumed-devel] Re: GNUmed substance schema was Re: GNUmed and FreeDiams, Karsten Hilbert, 2011/01/04
- Re: [Gnumed-devel] Re: GNUmed substance schema was Re: GNUmed and FreeDiams, Jim Busser, 2011/01/04