Methods Inf Med 2002; 41(02): 89-97
DOI: 10.1055/s-0038-1634291
Original Article
Schattauer GmbH

Clinical Data Retrieval: 25 Years of Temporal Query Management at the University of Vienna Medical School

W. Dorda
1   Section of Medical Information and Retrieval Systems, Department of Medical Computer Sciences, University of Vienna Medical School, Austria
,
W. Gall
1   Section of Medical Information and Retrieval Systems, Department of Medical Computer Sciences, University of Vienna Medical School, Austria
,
G. Duftschmid
1   Section of Medical Information and Retrieval Systems, Department of Medical Computer Sciences, University of Vienna Medical School, Austria
› Author Affiliations
Further Information

Publication History

Received: 27 June 2000

Accepted: 14 September 2001

Publication Date:
07 February 2018 (online)

Summary

Objectives: Today, many clinical information systems include analysis components which allow clinicians to apply a selection of predefined statistical functions that satisfy typical cases. They are mostly to inflexible to handle complex, non-standard problems, however. The focus of this paper, therefore, is to present an approach that enables clinicians to autonomously create ad hoc queries including temporal relations in an interactive environment.

Methods: We developed the query language AMAS, which was specifically customized for users from the medical domain to flexibly retrieve and interpret temporal, clinical data. AMAS provides for a significant temporal expressiveness in data retrieval using timestamped clinical databases and relies on an operator-operand concept for the specification of a query.

Results: Within the last 25 years, four different clinical retrieval systems have been implemented at the Department of Medical Computer Sciences, based on the AMAS query language. Currently, these systems allow access to the medical records of more than 2 million patients. Physicians of 46 different departments at the University of Vienna and Graz Medical Schools have made extensive use of these systems in the course of clinical research and patient care, executing more than 10.000 queries per year.

Conclusions: We discuss a list of 20 issues that represent the most essential lessons we have learned in the development of the four systems mentioned above. Amongst others, our experiences indicate that the operator-operand concept allows an intuitive specification of complex, temporal queries. Further, customization to different user classes, based on their statistical background, is essential.

 
  • References

  • 1 McDonald CJ, Overhage JM, Tierney WM. et al. The Regenstrief Medical Record System: a quarter century experience. Int J Med Inf 1999; 54: 225-53.
  • 2 Nigrin DJ, Kohane IS. Temporal expressiveness in querying a time-stamp-based clinical database. J Am Med Inform Assoc 2000; 7 (Suppl. 02) 152-63.
  • 3 Gall W, Heinzl H, Sachs P. Extracting a Statistical Data Matrix from Electronic Patient Records. Comput Meth Prog Bio 2001; 66 2-3 153-66.
  • 4 Combi C, Shahar Y. Temporal reasoning and temporal data maintenance in medicine: issues and challenges. Comput Biol Med 1997; 27 (Suppl. 05) 353-68.
  • 5 Hripcsak G, Clayton PA, Pryor P, Haug O, Wigerz J, Lei Van der. The Arden Syntax for Medical Logic Modules. In: Proc Annu Symp Comput Appl Med Care. 1990: 200-4.
  • 6 Das AK, Musen MA. A comparison of the temporal expressiveness of three database query methods. In: Proc Annu Symp Comput Appl Med Care. 1995: 331-7.
  • 7 Das AK, Musen MA. A foundational model of time for heterogeneous clinical databases. In: Proc AMIA Annu Fall Symp. 1997: 106-10.
  • 8 Kahn MG, Tu S, Fagan LM. TQuery: a context-sensitive temporal query language. Comput Biomed Res 1991; 24: 401-19.
  • 9 Wiederhold G, Jajodia S, Litwin W. Integrating Temporal Data in a Heterogenous Environment. In: Tansel A, Clifford J, Gadia S, Jajodia S, Segev A, and Snodgrass R. eds. Temporal Databases: Theory, Design and Implementation. Benjamin/Cummings; 1993
  • 10 Combi C, Pinciroli F, Cavallaro M, Cucchi G. Querying temporal clinical databases with different time granularities: the GCH-OSQL language. In: Proc Annu Symp Comput Appl Med Care. 1995: 326-30.
  • 11 Combi C, Cucchi G, Pinciroli F. Applying object-oriented technologies in modeling and querying temporally oriented clinical databases dealing with temporal granularity and indeterminacy. IEEE Trans Inf Technol Biomed 1997; 1 (Suppl. 02) 100-27.
  • 12 O’Connor MJ, Tu SW, Musen MA. Representation of temporal indeterminacy in clinical databases. In: Proc AMIA Symp. 2000: 615-9.
  • 13 Dolin RH. Modeling the temporal complexities of symptoms. J Am Med Inform Assoc 1995; 2 (Suppl. 05) 323-31.
  • 14 Vilain M, Kautz H. Constraint propagation algorithms for temporal reasoning. In: Proc AAAI-86: Fifth National Conference on Artificial Intelligence. 1986: 377-82.
  • 15 Allen JF, Hayes PJ. A Common-Sense Theory of Time. In: Proc International Joint Conference on Artificial Intelligence. 1985: 528-31.
  • 16 Pissinou N, Snodgrass R. Towards an Infrastructure for temporal Databases: Report of an Invitational ARPA/NSF Workshop. SIGMOD RECORD 1994; 23 (Suppl. 01) 35-50.
  • 17 Navathe SB, Ahmed R. TSQL: A Language Interface for History Databases. In: Proc Temporal Aspects in Information Systems. 1988: 109-22.
  • 18 Snodgras RT, Ahn I, Ariav Gadia. et al. TSQL2 Language Specification. SIGMOD RECORD 1994; 23 (Suppl. 01) 65-86.
  • 19 Snodgrass RT, Bohlen MH, Jensen CS, Steiner A. Transitioning temporal support in TSQL2 to SQL3. In: Etzion O, Jajodia S, Sripada S. eds. Temporal Databases – Research and Practice, Lectures Notes in Computer Sciences. Springer: Berlin Germany.; 1998: 150-94.
  • 20 Eisenberg A, Melton J. SQL standardization: the next steps. SIGMOD RECORD 2000; 29 (Suppl. 01) 63-7.
  • 21 Banhart E, Klaeren H. A Graphical Query generator for Clinical Research Databases. Methods Inf Med 1995; 34: 328-39.
  • 22 Shahar Y, Musen MA. RESUME: a temporal-abstraction system for patient monitoring. Comput Biomed Res 1993; 26 (Suppl. 03) 255-73.
  • 23 Das AK, Musen MA. A temporal query system for protocol-directed decision support. Methods Inf Med 1994; 33 (Suppl. 04) 358-70.
  • 24 Nguyen JH, Shahar Y, Tu SW, Das AK, Musen MA. A temporal database mediator for protocol-based decision support. In: Proc AMIA Annu Fall Symp. 1997: 298-302.
  • 25 Shahar Y, Combi C. Timing is everything. Time-oriented clinical information systems. West J Med 1998; 168 (Suppl. 02) 105-13.
  • 26 Gall W, Sachs P, Duftschmid G, Dorda W. A retrieval system for the selection and statistical analysis of clinical data. Med Inform 1999; 24 (Suppl. 03) 201-12.
  • 27 Dorda W, Kogler W. WAMAS – Statistische Auswertung einer patientenorientierten Datenbank. Statistical Software Newsletter 1977; 2: 54-58.
  • 28 Wolf W, Dorda W, Sachs P, Graber E. WAMAS: On Line Evaluation of a Medical Database Under Consideration of Time-Relations. In: Begon F. eds. Annals of the World Association for Medical Informatics. 1981: 231-5.
  • 29 Dorda W. WAREL: A System for Retrieval of Clinical Data Considering the Course of Diseases. Methods Inf Med 1989; 28: 133-41.
  • 30 Dorda W. Data-Screening and Retrieval of Medical Data by the System WAREL. Methods Inf Med 1990; 29: 3-11.
  • 31 Dorda W, Wrba Th, Duftschmid G. et al. ArchiMed – A Medical Information and Retrieval System. Methods Inf Med 1999; 38: 16-24.
  • 32 Grabner G. WAMIS – Wiener Allgemeines Medizinisches Informations System. Berlin: Springer; 1986
  • 33 Dorda W, Haidl B, Sachs P. Processing Medical Natural Language Data by the System WAREL. Methods Inf Med 1988; 27: 67-72.
  • 34 Froeschl KA, Grossmann W, Dorda W, Sachs P. The WAMASTEX User-Interaction-Design – The Case of Metric Paired Sample Data. In: Proc Soft Stat 93, Advances in Statistical Software 4. Stuttgart: Fischer.; 1994: 125-32.