Download PDF
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)

    Permissions and Reprints

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.

Keywords

Clinical retrieval system - temporal querying - time relations - temporal operators - information storage and retrieval
 

  • 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.
    CrossrefPubMedGoogle Scholar
  • 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.
    CrossrefPubMedGoogle Scholar
  • 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.
    CrossrefPubMedGoogle Scholar
  • 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.
    CrossrefPubMedGoogle Scholar
  • 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.
    Google Scholar
  • 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.
    Google Scholar
  • 7 Das AK, Musen MA. A foundational model of time for heterogeneous clinical databases. In: Proc AMIA Annu Fall Symp. 1997: 106-10.
    Google Scholar
  • 8 Kahn MG, Tu S, Fagan LM. TQuery: a context-sensitive temporal query language. Comput Biomed Res 1991; 24: 401-19.
    CrossrefPubMedGoogle Scholar
  • 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
    Google Scholar
  • 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.
    Google Scholar
  • 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.
    CrossrefPubMedGoogle Scholar
  • 12 O’Connor MJ, Tu SW, Musen MA. Representation of temporal indeterminacy in clinical databases. In: Proc AMIA Symp. 2000: 615-9.
    Google Scholar
  • 13 Dolin RH. Modeling the temporal complexities of symptoms. J Am Med Inform Assoc 1995; 2 (Suppl. 05) 323-31.
    CrossrefPubMedGoogle Scholar
  • 14 Vilain M, Kautz H. Constraint propagation algorithms for temporal reasoning. In: Proc AAAI-86: Fifth National Conference on Artificial Intelligence. 1986: 377-82.
    Google Scholar
  • 15 Allen JF, Hayes PJ. A Common-Sense Theory of Time. In: Proc International Joint Conference on Artificial Intelligence. 1985: 528-31.
    Google Scholar
  • 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.
    PubMedGoogle Scholar
  • 17 Navathe SB, Ahmed R. TSQL: A Language Interface for History Databases. In: Proc Temporal Aspects in Information Systems. 1988: 109-22.
    Google Scholar
  • 18 Snodgras RT, Ahn I, Ariav Gadia. et al. TSQL2 Language Specification. SIGMOD RECORD 1994; 23 (Suppl. 01) 65-86.
    CrossrefPubMedGoogle Scholar
  • 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.
    Google Scholar
  • 20 Eisenberg A, Melton J. SQL standardization: the next steps. SIGMOD RECORD 2000; 29 (Suppl. 01) 63-7.
    CrossrefPubMedGoogle Scholar
  • 21 Banhart E, Klaeren H. A Graphical Query generator for Clinical Research Databases. Methods Inf Med 1995; 34: 328-39.
    Article in Thieme ConnectPubMedGoogle Scholar
  • 22 Shahar Y, Musen MA. RESUME: a temporal-abstraction system for patient monitoring. Comput Biomed Res 1993; 26 (Suppl. 03) 255-73.
    CrossrefPubMedGoogle Scholar
  • 23 Das AK, Musen MA. A temporal query system for protocol-directed decision support. Methods Inf Med 1994; 33 (Suppl. 04) 358-70.
    Article in Thieme ConnectPubMedGoogle Scholar
  • 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.
    Google Scholar
  • 25 Shahar Y, Combi C. Timing is everything. Time-oriented clinical information systems. West J Med 1998; 168 (Suppl. 02) 105-13.
    PubMedGoogle Scholar
  • 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.
    PubMedGoogle Scholar
  • 27 Dorda W, Kogler W. WAMAS – Statistische Auswertung einer patientenorientierten Datenbank. Statistical Software Newsletter 1977; 2: 54-58.
    PubMedGoogle Scholar
  • 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.
    Google Scholar
  • 29 Dorda W. WAREL: A System for Retrieval of Clinical Data Considering the Course of Diseases. Methods Inf Med 1989; 28: 133-41.
    Article in Thieme ConnectPubMedGoogle Scholar
  • 30 Dorda W. Data-Screening and Retrieval of Medical Data by the System WAREL. Methods Inf Med 1990; 29: 3-11.
    Article in Thieme ConnectPubMedGoogle Scholar
  • 31 Dorda W, Wrba Th, Duftschmid G. et al. ArchiMed – A Medical Information and Retrieval System. Methods Inf Med 1999; 38: 16-24.
    Article in Thieme ConnectPubMedGoogle Scholar
  • 32 Grabner G. WAMIS – Wiener Allgemeines Medizinisches Informations System. Berlin: Springer; 1986
    Google Scholar
  • 33 Dorda W, Haidl B, Sachs P. Processing Medical Natural Language Data by the System WAREL. Methods Inf Med 1988; 27: 67-72.
    Article in Thieme ConnectPubMedGoogle Scholar
  • 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.
    Google Scholar