Re: surrogate key or not? - Mailing list pgsql-sql

From Karsten Hilbert
Subject Re: surrogate key or not?
Date
Msg-id 20040728140811.B607@hermes.hilbert.loc
Whole thread Raw
In response to Re: surrogate key or not?  (Kenneth Gonsalves <lawgon@thenilgiris.com>)
List pgsql-sql
> 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


pgsql-sql by date:

Previous
From: Karsten Hilbert
Date:
Subject: Re: surrogate key or not?
Next
From: tgl@sss.pgh.pa.us
Date:
Subject: Re: hey