Hello Tim,
Tuesday, June 05, 2001, 9:31:50 PM, you wrote:
TC> with the full text searching capability across the entire set of
TC> records I believe a practice can build an enormously useful repository
Text search is great of course, but it is only one option from
required for medical data analysis. And, or, not, more than, less
than, between, inlist, isempty and so on are also basic. Search on
on-line constructed expressions like admission_date-discharge_date>5
would also be necessary.
TC> Can you duplicate 'near' searches in context, in SQL? With OIO you
There are search tools in bibliographic systems which allow something
similar with defined number of other words between search terms. But
our tasks rarely are limited with search only. Found stuff has to be
analyzed. Something like across the hospital calculation of safe days
in blondes less or equal 25, with waist less than 65 cm and who lives
not farther than 25 km from my office. Or for instance find answers to
questions like "Do smokers have longer healing period than non-smokers
in open grade III tibial fractures treated with external fixation?"
"How quality of life changes after different managing programs and are
differencies between and inside groups significant?"
TC> What information do you see that is missing from FreePM that would caue
TC> you to make that statement?
Except discussed problems of i18n <:->, IMHO it would be great to
have ad hoc query tools (in FreePM as well in OIO). With more or less
standard design - user can define search conditions (see above ;),
output fields, sort order, output format (comma delimited text or
spreadsheet, PDF/graphs, etc) and, optionally, basic calculations
(average with standard error, min, max, count etc). Actually i would
be happy having any table output which i could open with Excel and use
its Pivot Table, base statistics and chart capabilities. Or process
the table with a statistical package like SPSS or Statistica.
--
Best regards,
Alexander N. Chelnokov
Ural Scientific Institute of Traumatology and Orthopaedics
7, Bankovsky str. Ekaterinburg 620014 Russia
ICQ: 25640913
_______________________________________________
FreePM Support List
[EMAIL PROTECTED]
http://lists.sourceforge.net/lists/listinfo/freepm-discuss
