Abstract
Time is a multifaceted phenomenon that developers of clinical decision-support systems can model at various levels of complexity. An unresolved issue for the design of clinical databases is whether the underlying data model should support interval semantics. In this paper, we examine whether interval-based operations are required for querying protocol-based conditions. We report on an analysis of a set of 256 eligibility criteria that the T-HELPER system uses to screen patients for enrollment in eight clinical-trial protocols for HIV disease. We consider three data-manipulation methods for temporal querying: the consensus query representation Arden Syntax, the commercial standard query language SQL, and the temporal query language TimeLineSQL (TLSQL). We compare the ability of these three query methods to express the eligibility criteria. Seventy nine percent of the 256 criteria require operations on time stamps. These temporal conditions comprise four distinct patterns, two of which use interval-based data. Our analysis indicates that the Arden Syntax can query the two non-interval patterns, which represent 54% of the temporal conditions. Timepoint comparisons formulated in SQL can instantiate the two non-interval patterns and one interval pattern, which encompass 96% of the temporal conditions. TLSQL, which supports an interval-based model of time, can express all four types of temporal patterns. Our results demonstrate that the T-HELPER system requires simple temporal operations for most protocol-based queries. Of the three approaches tested, TLSQL is the only query method that is sufficiently expressive for the temporal conditions in this system.
Full text
PDF
Selected References
These references are in PubMed. This may not be the complete list of references from this article.
- Das A. K., Musen M. A. A temporal query system for protocol-directed decision support. Methods Inf Med. 1994 Oct;33(4):358–370. [PubMed] [Google Scholar]
- Hripcsak G., Ludemann P., Pryor T. A., Wigertz O. B., Clayton P. D. Rationale for the Arden Syntax. Comput Biomed Res. 1994 Aug;27(4):291–324. doi: 10.1006/cbmr.1994.1023. [DOI] [PubMed] [Google Scholar]
- Huff S. M., Berthelsen C. L., Pryor T. A., Dudley A. S. Evaluation of an SQL model of the HELP patient database. Proc Annu Symp Comput Appl Med Care. 1991:386–390. [PMC free article] [PubMed] [Google Scholar]
- Kahn M. G., Fagan L. M., Tu S. Extensions to the time-oriented database model to support temporal reasoning in medical expert systems. Methods Inf Med. 1991;30(1):4–14. [PubMed] [Google Scholar]
- Kahn M. G. Modeling time in medical decision-support programs. Med Decis Making. 1991 Oct-Dec;11(4):249–264. doi: 10.1177/0272989X9101100403. [DOI] [PubMed] [Google Scholar]
- McDonald C. J., Tierney W. M., Overhage J. M., Martin D. K., Wilson G. A. The Regenstrief Medical Record System: 20 years of experience in hospitals, clinics, and neighborhood health centers. MD Comput. 1992 Jul-Aug;9(4):206–217. [PubMed] [Google Scholar]
- McGraw S. E., Miller N. W., Caesar N. B. Doctors must review referral and business relationships. N J Med. 1992 Feb;89(2):129–132. [PubMed] [Google Scholar]
- Musen M. A., Carlson R. W., Fagan L. M., Deresinski S. C., Shortliffe E. H. T-HELPER: automated support for community-based clinical research. Proc Annu Symp Comput Appl Med Care. 1992:719–723. [PMC free article] [PubMed] [Google Scholar]
- Tu S. W., Kemper C. A., Lane N. M., Carlson R. W., Musen M. A. A methodology for determining patients' eligibility for clinical trials. Methods Inf Med. 1993 Aug;32(4):317–325. [PubMed] [Google Scholar]