OBJECTIVES: The authors designed and implemented a clinical data mart composed of an integrated information retrieval (IR) and relational database management system (RDBMS). DESIGN: Using commodity software, which supports interactive, attribute-centric text and relational searches, the mart houses 2.8 million documents that span a five-year period and supports basic IR features such as Boolean searches, stemming, and proximity and fuzzy searching. MEASUREMENTS: Results are relevance-ranked using either "total documents per patient" or "report type weighting." RESULTS: Non-curated medical text has a significant degree of malformation with respect to spelling and punctuation, which creates difficulties for text indexing and searching. Presently, the IR facilities of RDBMS packages lack the features necessary to handle such malformed text adequately. CONCLUSION: A robust IR+RDBMS system can be developed, but it requires integrating RDBMSs with third-party IR software. RDBMS vendors need to make their IR offerings more accessible to non-programmers.
OBJECTIVES: The authors designed and implemented a clinical data mart composed of an integrated information retrieval (IR) and relational database management system (RDBMS). DESIGN: Using commodity software, which supports interactive, attribute-centric text and relational searches, the mart houses 2.8 million documents that span a five-year period and supports basic IR features such as Boolean searches, stemming, and proximity and fuzzy searching. MEASUREMENTS: Results are relevance-ranked using either "total documents per patient" or "report type weighting." RESULTS: Non-curated medical text has a significant degree of malformation with respect to spelling and punctuation, which creates difficulties for text indexing and searching. Presently, the IR facilities of RDBMS packages lack the features necessary to handle such malformed text adequately. CONCLUSION: A robust IR+RDBMS system can be developed, but it requires integrating RDBMSs with third-party IR software. RDBMS vendors need to make their IR offerings more accessible to non-programmers.
Authors: Qing T Zeng; Jonathan Crowell; Robert M Plovnick; Eunjung Kim; Long Ngo; Emily Dibble Journal: J Am Med Inform Assoc Date: 2005-10-12 Impact factor: 4.497
Authors: Joseph L Goulet; Joseph Erdos; Sue Kancir; Forrest L Levin; Steven M Wright; Stanlie M Daniels; Lynnette Nilan; Amy C Justice Journal: Med Care Date: 2007-01 Impact factor: 2.983
Authors: Lisa Seyfried; David A Hanauer; Donald Nease; Rashad Albeiruti; Janet Kavanagh; Helen C Kales Journal: Int J Med Inform Date: 2009-06-27 Impact factor: 4.046
Authors: Catherine E Muehlenbein; J Russell Hoverman; Stephen K Gruschkus; Michael Forsyth; Clara Chen; William Lopez; Anthony Lawson; Heather J Hartnett; Gerhardt Pohl Journal: J Cancer Epidemiol Date: 2011-05-02
Authors: Herman D Tolentino; Michael D Matters; Wikke Walop; Barbara Law; Wesley Tong; Fang Liu; Paul Fontelo; Katrin Kohl; Daniel C Payne Journal: BMC Med Inform Decis Mak Date: 2007-02-12 Impact factor: 2.796
Authors: Ranier Bustamante; Ashley Earles; James D Murphy; Alex K Bryant; Olga V Patterson; Andrew J Gawron; Tonya Kaltenbach; Mary A Whooley; Deborah A Fisher; Sameer D Saini; Samir Gupta; Lin Liu Journal: Med Care Date: 2019-10 Impact factor: 2.983
Authors: Irena Spasić; Daniel Schober; Susanna-Assunta Sansone; Dietrich Rebholz-Schuhmann; Douglas B Kell; Norman W Paton Journal: BMC Bioinformatics Date: 2008-04-29 Impact factor: 3.169