Application of Information Technology: Metadata-driven Ad Hoc Query of Patient Data: Meeting the Needs of Clinical Studies

Clinical study data management systems (CSDMSs) have many similarities to clinical patient record systems (CPRSs) in their focus on recording clinical parameters. Requirements for ad hoc query interfaces for both systems would therefore appear to be highly similar. However, a clinical study is concerned primarily with collective responses of groups of subjects to standardized therapeutic interventions for the same underlying clinical condition. The parameters that are recorded in CSDMSs tend to be more diverse than those required for patient management in non-research settings, because of the greater emphasis on questionnaires for which responses to each question are recorded separately. The differences between CSDMSs and CPRSs are reflected in the metadata that support the respective systems' operation, and need to be reflected in the query interfaces. The authors describe major revisions of their previously described CSDMS ad hoc query interface to meet CSDMS needs more fully, as well as its porting to a Web-based platform.

[1]  Luis N. Marenco,et al.  Reengineering a database for clinical trials management: lessons for system architects. , 2000, Controlled clinical trials.

[2]  Prakash M. Nadkarni,et al.  Data Extraction and Ad Hoc Query of an Entity– Attribute–Value Database , 2000 .

[3]  Cynthia Brandt,et al.  Generation of pedigree diagrams for web display using scalable vector graphics from a clinical trials database , 2001, AMIA.

[4]  Isaac S. Kohane,et al.  Data mining by clinicians , 1998, AMIA.

[5]  T A Pryor,et al.  Evaluation of an SQL model of the HELP patient database. , 1991, Proceedings. Symposium on Computer Applications in Medical Care.

[6]  David F. Lobach,et al.  Medical data mining: knowledge discovery in a clinical data warehouse , 1997, AMIA.

[7]  Clement T. Yu,et al.  The measurement of term importance in automatic indexing , 1981, J. Am. Soc. Inf. Sci..

[8]  Henry C. Chueh,et al.  Visual query tool for finding patient cohorts from a clinical data warehouse of the partners HealthCare system , 2000, AMIA.

[9]  George Hripcsak,et al.  A Generalized Relational Schema for an Integrated Clinical Patient Database. , 1990 .

[10]  P J Haug,et al.  HELP the next generation: a new client-server architecture. , 1994, Proceedings. Symposium on Computer Applications in Medical Care.

[11]  P M Nadkarni,et al.  CHRONOMERGE: an application for the merging and display of multiple time-stamped data streams. , 1998, Computers and biomedical research, an international journal.

[12]  Isaac S. Kohane,et al.  Scaling a data retrieval and mining application to the enterprise-wide level , 1999, AMIA.

[13]  Joel H. Saltz,et al.  A graphical tool for ad hoc query generation , 1998, AMIA.

[14]  Erik Thomsen,et al.  OLAP Solutions - Building Multidimensional Information Systems , 1997 .

[15]  Ping Wang,et al.  Theater-Style Demonstration: The Web Enabled IHC Enterprise Data Warehouse for Clinical Process Improvement and Outcomes Measurement , 1997, AMIA.

[16]  George Hripcsak,et al.  Using Metadata to Integrate Medical Knowledge in a Clinical Information System , 1990 .

[17]  Perry L. Miller,et al.  Application of Technology: Managing Attribute-Value Clinical Trials Data Using the ACT/DB Client-Server Database System , 1998, J. Am. Medical Informatics Assoc..

[18]  W. H. Inmon,et al.  Data Warehouse Performance , 1998 .

[19]  Cynthia Brandt,et al.  WebEAV: automatic metadata-driven generation of web interfaces to entity-attribute-value databases. , 2000, Journal of the American Medical Informatics Association : JAMIA.

[20]  Tony Mason,et al.  Lex & Yacc , 1992 .