Moving time window aggregates over patient histories

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.

[1]  Christian S. Jensen,et al.  Transitioning Temporal Support in TSQL2 to SQL3 , 1997, Temporal Databases, Dagstuhl.

[2]  Ramez Elmasri,et al.  TSQL2 language specification , 1994, SGMD.

[3]  C. Chute,et al.  Exploration and exploitation of clinical databases. , 1995, International journal of bio-medical computing.

[4]  C Combi,et al.  Temporal reasoning and temporal data maintenance in medicine: Issues and challenges , 1997, Comput. Biol. Medicine.

[5]  F Pinciroli,et al.  Querying temporal clinical databases with different time granularities: the GCH-OSQL language. , 1995, Proceedings. Symposium on Computer Applications in Medical Care.

[6]  W. Dorda.  WAREL; a system for retrieval of clinical data considering the course of diseases. , 1989, Methods of information in medicine.

[7]  Jim Melton,et al.  SQL standardization: the next steps , 2000, SGMD.

[8]  Richard T. Snodgrass,et al.  Aggregates in the Temporal Query Language TQuel , 1993, IEEE Trans. Knowl. Data Eng..

[9]  Sushil Jajodia,et al.  Temporal Databases: Theory, Design, and Implementation , 1993 .

[10]  F Pinciroli,et al.  Supporting temporal queries on clinical relational databases: the S-WATCH-QL language. , 1996, Proceedings : a conference of the American Medical Informatics Association. AMIA Fall Symposium.

[11]  M A Musen,et al.  A comparison of the temporal expressiveness of three database query methods. , 1995, Proceedings. Symposium on Computer Applications in Medical Care.

[12]  Y Shahar,et al.  Time-oriented Clinical Information Systems Time-oriented Clinical Information Systems * , 1997 .

[13]  Isaac S. Kohane,et al.  Application of Information Technology: Temporal Expressiveness in Querying a Time-stamp - based Clinical Database , 2000, J. Am. Medical Informatics Assoc..

[14]  Lawrence M. Fagan,et al.  TQuery: a context-sensitive temporal query language. , 1991, Computers and biomedical research, an international journal.

[15]  Shamkant B. Navathe,et al.  TSQL: A Language Interface for History Databases , 1987, Temporal Aspects in Information Systems.

[16]  W Gall,et al.  A retrieval system for the selection and statistical analysis of clinical data. , 1999, Medical informatics and the Internet in medicine.

[17]  Gio Wiederhold,et al.  Structured organization of clinical data bases , 1899, AFIPS '75.