Date: Wed, 28 Jul 2004 14:08:11 +0200
From: Karsten Hilbert <Karsten.Hilbert@gmx.net>
To: pgsql-sql@postgresql.org
Subject: Re: surrogate key or not?
Message-ID: <20040728140811.B607@hermes.hilbert.loc>
References: <1090325769.3241.27.camel@dicaprio.akademie1.de>
	<04072711335024.01150@thenilgiris.com>
	<001f01c47442$4dd673a0$7201a8c0@mst1x5r347kymb>
	<0407280744502B.01150@thenilgiris.com>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: <0407280744502B.01150@thenilgiris.com>
User-Agent: Mutt/1.3.22.1i
Re-X-turn-receipt-to: Karsten.Hilbert@gmx.net
Di-X-sposition-Notification-To: Karsten.Hilbert@gmx.net

> 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