[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Gnumed-devel] Difficulty collapsing drug companies' substances
From: |
Jim Busser |
Subject: |
[Gnumed-devel] Difficulty collapsing drug companies' substances |
Date: |
Tue, 04 Jan 2011 20:26:13 -0800 |
Progress report…
I am not sure if my observation is specific to Canada, but it seems that the
drug companies may be providing their identifying data (to government) in a
form like
Brand name
Ingredient 1
Ingredient 2…
Strength (real number)
Units (string)
and that the composition of all strings is completely arbitrary. The
ingredients are named with all variety of salts, and any number of other
arbitrary clarifiers, causing these to be indexed as distinct entities in the
source tables, and this prevents any reliable matching to INN (even in the same
language). It also confounds efforts to lookup and assign (other than manually)
an ATC to many of ingredients. Eric's FreeToolBox module will at least help.
Units are also arbitrary… for example
%
%/W/W
G/100G
MG/G
Strengths can be arbitrary… slight annoyances including
2% vs
2.0% vs
2.00%
but at least these are computable and I am better learning SQL as I explore
this :-)
-- Jim
- Re: [Gnumed-devel] Re: GNUmed substance schema was Re: GNUmed and FreeDiams, (continued)
- Message not available
- [Gnumed-devel] Re: TODO 0.9: component/substance PRW, Karsten Hilbert, 2011/01/14
- Re: [Gnumed-devel] Re: GNUmed substance schema was Re: GNUmed and FreeDiams, Jim Busser, 2011/01/05
- Re: [Gnumed-devel] Re: GNUmed substance schema was Re: GNUmed and FreeDiams, Karsten Hilbert, 2011/01/05
- Re: [Gnumed-devel] Re: GNUmed substance schema was Re: GNUmed and FreeDiams, Jim Busser, 2011/01/05
- Re: [Gnumed-devel] Re: GNUmed substance schema was Re: GNUmed and FreeDiams, Karsten Hilbert, 2011/01/05
- Re: [Gnumed-devel] Re: GNUmed substance schema was Re: GNUmed and FreeDiams, Jim Busser, 2011/01/05
- Re: [Gnumed-devel] Re: GNUmed substance schema was Re: GNUmed and FreeDiams, Karsten Hilbert, 2011/01/05
- Re: [Gnumed-devel] Re: GNUmed substance schema was Re: GNUmed and FreeDiams, Karsten Hilbert, 2011/01/06
- [Gnumed-devel] Difficulty collapsing drug companies' substances,
Jim Busser <=
- [Gnumed-devel] Re: Difficulty collapsing drug companies' substances, Karsten Hilbert, 2011/01/05
- Re: [Gnumed-devel] GNUmed substance schema was Re: GNUmed and FreeDiams, Karsten Hilbert, 2011/01/03
- Message not available
- Re: [Gnumed-devel] Re: GNUmed and FreeDiams, Karsten Hilbert, 2011/01/12
- Re: [Gnumed-devel] Re: GNUmed and FreeDiams, Karsten Hilbert, 2011/01/01