[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: [Gnumed-devel] keep testing, or add to main source?
From: |
Karsten Hilbert |
Subject: |
Re: [Gnumed-devel] keep testing, or add to main source? |
Date: |
Thu, 9 Oct 2003 17:21:58 +0200 |
User-agent: |
Mutt/1.3.22.1i |
> > For example, if a patient has gout, and the user types "a", the
> > phrasewheel should return "allopurinol" as its first guess, but
> > if the disease is depression, the guess should be, say, "amitryptaline"
> One way to do this could be to store score-tables for every unique
> combination of the relevant entry fields.
> create table score_gmpw_sql_prescriptions (
> id serial primary key,
> fk_gmpw_sql_test integer not null references gmpw_sql_test(id),
> "user" name not null default CURRENT_USER,
> score bigint not null default 0,
> fk_entry_fields_combination not null references
> gmpw_combinations_prescriptions(id);
> );
>
> create table gmpw_combinations_prescriptions (
> id serial primary key,
> entry_field1_term text default null,
> entry_field2_term text default null,
> ...
> entry_fieldn_term text default null,
> unique(entry_field1_term, entry_field2_term, ...,
> entry_fieldn_term)
> );
Holy cow ! :-)) Am I missing something if I suggest using a
"cookie" text default null column in score_(*)_prescriptions
which is a concatenated string of the appropriate values and
let the widget care about which field the actual values are
taken from in which order ? Of course, without a clear
definition of a separator character (newline ?) this would be
a one-way field (albeit sufficient lest I be mistaken).
> -we must choose the number of relevant entry fields carefully (note that the
> number of possible combinations is (num_of_entry_fields)^(num_of_possible
> terms)).
That's IMHO inherent to the approach and not really avoidable.
> In general IMHO we shouldn't make the phraseweels too smart because this
Absolutely agree !
> will always limit the number of matches found in a certain situation.
The matches needn't be hard limits. If the user keeps typing
after exhausting the matches the match provider can broaden
its search space.
Karsten
--
GPG key ID E4071346 @ wwwkeys.pgp.net
E167 67FD A291 2BEA 73BD 4537 78B9 A9F9 E407 1346
- [Gnumed-devel] keep testing, or add to main source?, syan tan, 2003/10/07
- Re: [Gnumed-devel] keep testing, or add to main source?, Hilmar Berger, 2003/10/07
- Re: [Gnumed-devel] keep testing, or add to main source?, Ian Haywood, 2003/10/08
- Re: [Gnumed-devel] keep testing, or add to main source?, syan tan, 2003/10/08
- Re: [Gnumed-devel] keep testing, or add to main source?, Ian Haywood, 2003/10/09
- Re: [Gnumed-devel] keep testing, or add to main source?, Hilmar Berger, 2003/10/09
- Re: [Gnumed-devel] keep testing, or add to main source?,
Karsten Hilbert <=
- Re: [Gnumed-devel] keep testing, or add to main source?, Hilmar Berger, 2003/10/09
- Re: [Gnumed-devel] keep testing, or add to main source?, Hilmar Berger, 2003/10/09
- Re: [Gnumed-devel] keep testing, or add to main source?, Karsten Hilbert, 2003/10/09
- [Gnumed-devel] Richard's phrase wheel comments, richard terry, 2003/10/09
- Re: [Gnumed-devel] Richard's phrase wheel comments, Horst Herb, 2003/10/09
- Re: [Gnumed-devel] Richard's phrase wheel comments, Elizabeth Dodd, 2003/10/11
- Re: [Gnumed-devel] Richard's phrase wheel comments, richard terry, 2003/10/11
- Re: [Gnumed-devel] Richard's phrase wheel comments, Karsten Hilbert, 2003/10/18
- Re: [Gnumed-devel] keep testing, or add to main source?, Karsten Hilbert, 2003/10/09
- Message not available
- Re: [Gnumed-devel] keep testing, or add to main source?, Karsten Hilbert, 2003/10/09