Re: surrogate key or not?

> simpler, as a first stage and easily implemented, give him some way he can
> tag words and phrases he feels important. save these in a table along with a
> foreign key identifying the source. as a second stage keep analysing the
> words and phrases chosen and empirically build up a database of significant
> words and phrases relevant to that specific installation (or doctor), and as
> a third stage, highlight these as he types in the data
Even simpler. Most notes only ever contain those words that are
relevant :-) So what we are doing is matching different parts
of the progress note, eg. when the doctor types "cough,
congested nose, sore throat" as a complaint we pull in the
drugs he ususally prescribes for that condition and the dosages
she ususally uses ...

Karsten
--
GPG key ID E4071346 @ wwwkeys.pgp.net
E167 67FD A291 2BEA 73BD 4537 78B9 A9F9 E407 1346