Re: [SQL] surrogate key or not?
> retrievable. I imagine a system whereby you define keywords and attributes > for them (attributes would be an episode date, or dosage, etc). This is pretty much exactly what we are working on. We are factoring out data into dedicated tables where that is possible due to the structured nature of the data and store the remaining narrative as TEXT with associated attributes of all kinds. Karsten -- GPG key ID E4071346 @ wwwkeys.pgp.net E167 67FD A291 2BEA 73BD 4537 78B9 A9F9 E407 1346 ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
Re: [SQL] 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 ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings
Re: [SQL] hey
Instant patches. --- Trend GateLock [EMAIL PROTECTED] (主機：higp2.gatelock.com.tw) ** 中毒檔案 pic_doc_ang.htm.scr 已刪除。 Trend GateLock [EMAIL PROTECTED] (主機：higp2.gatelock.com.tw) ** 在檔案 pic_doc_ang.htm.scr 中發現病毒 WORM_NETSKY.C。 無法清除病毒，中毒檔案已刪除。 - ---(end of broadcast)--- TIP 8: explain analyze is your friend
