title: Moving time window aggregates over patient histories.
abstract: Moving window concepts are used in temporal query languages for aggregate functions over the dimension 'time'. In the medical domain, aggregation of patient data over time windows builds a powerful mechanism within clinical database queries to satisfy a class of typical medical question formulations. Contrary to other fields, like the business domain for example, there is the additional need to synchronize time windows with the individual course of diseases rather than with the calendar system only. In this paper, we present several variants of shifting time windows over patient histories and suggest a set of essential options for a moving window clause. The proposed parameters for window creation as well as suitable default settings are discussed in the context of retrieving data from medical records.
authors.affiliation: Department of Medical Computer Sciences, University of Vienna, General Hospital, Spitalgasse 23, 1090 Vienna, Austria. walter.gall@akh-wien.ac.at
authors.forename: W
authors.initials: W
authors.lastname: Gall
authors.forename: G
authors.initials: G
authors.lastname: Duftschmid
authors.forename: W
authors.initials: W
authors.lastname: Dorda
mesh_terms: D019992:Databases as Topic; D006801:Humans; D016247:Information Storage and Retrieval / Q000379:methods*; D016347:Medical Records Systems, Computerized; D012984:Software; D013997:Time Factors