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