Coping efficiently with now-relative medical data

In Medical Informatics, there is an increasing awareness that temporal information plays a crucial role, so that suitable database approaches are needed to store and support it. Specifically, most clinical data are intrinsically temporal, and a relevant part of them are now-relative (i.e., they are valid at the current time). Even if previous studies indicate that the treatment of now-relative data has a crucial impact on efficiency, current approaches have several limitations. In this paper we propose a novel approach, which is based on a new representation of now, and on query transformations. We also experimentally demonstrate that our approach outperforms its best competitors in the literature to the extent of a factor of more than ten, both in number of disk accesses and of CPU usage.

[1]  Christian S. Jensen,et al.  On the semantics of “now” in databases , 1996, TODS.

[2]  Hans-Peter Kriegel,et al.  The R*-tree: an efficient and robust access method for points and rectangles , 1990, SIGMOD '90.

[3]  Jan Chomicki,et al.  Temporal Query Languages: A Survey , 1994, ICTL.

[4]  Christian S. Jensen,et al.  Layered Temporal DBMS: Concepts and Techniques , 1997, DASFAA.

[5]  Christian S. Jensen,et al.  Modification semantics in now-relative databases , 2004, Inf. Syst..

[6]  Samson W. Tu,et al.  The Chronus II temporal database mediator , 2002, AMIA.

[7]  Mark A. Musen,et al.  A foundational model of time for heterogeneous clinical databases , 1997, AMIA.

[8]  Christopher Murray Oracle spatial user guide and reference , 2002 .

[9]  Richard T. Snodgrass,et al.  The TSQL2 Temporal Query Language , 1995 .

[10]  Alan R. Simon,et al.  Sql: 1999 Understanding Relational Language Components , 2002 .

[11]  R James,et al.  Survey and critique of time and medical records. , 1995, Medinfo. MEDINFO.

[12]  Gultekin Özsoyoglu,et al.  Temporal and Real-Time Databases: A Survey , 1995, IEEE Trans. Knowl. Data Eng..

[13]  Yuval Shahar,et al.  The Temporal Aspects of Clinical Guidelines , 2008, Computer-based Medical Guidelines and Protocols.

[14]  Vassilis J. Tsotras,et al.  Comparison of access methods for time-evolving data , 1999, CSUR.

[15]  Paolo Terenziani,et al.  A modular approach for representing and executing clinical guidelines , 2001, Artif. Intell. Medicine.

[16]  M A Musen,et al.  A Temporal Query System for Protocol-Directed Decision Support , 1994, Methods of Information in Medicine.

[17]  llsoo Ahn,et al.  Temporal Databases , 1986, Computer.