Clinical data retrieval: 25 years of temporal query management at the University of Vienna Medical School.
OBJECTIVE
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 time-stamped 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 on intuitive specification of complex, temporal queries. Further, customization to different user classes, based on their statistical background, is essential.
Dorda
W
W
Section of Medical Information and Retrieval Systems, Department of Medical Computer Sciences, University of Vienna Medical School, Austria. wolfgang.dorda@akh-wien.ac.at
Gall
W
W
Duftschmid
G
G
D001317:Austria; D020000:Decision Support Systems, Clinical; D006801:Humans; D016247:Information Storage and Retrieval; D011381:Programming Languages; D013997:Time Factors; D014584:User-Computer Interface