Re: surrogate key or not?

On Tuesday 27 July 2004 02:04 am, Karsten Hilbert wrote:

> One thing we ARE looking for in our records is the ability to
> find groups of patients by arbitrary criteria since one day
> I'll have to find all my patients whose father took a statine,
> whose second-born child suffered a bout of neutropenia 2 weeks
> after birth and who started being on the pill at age 14.
> Because they'll have a 3fold increased risk of lung embolus.
> Unless monitored for clotting factors every 6 months. Which I
> will have to do from now on. Get my point ?  :-)

couldnt you do something like, let them write the 'long flaky text', and at 
the same time mark a certain number of key words or key phrases which could 
be stored and retrieved?

-- 
regards
kg

http://www.onlineindianhotels.net - hotel bookings reservations in over 4600 
hotels in India
http://www.ootygolfclub.org