Representing and querying now-relative relational medical data.

Journal: Artificial intelligence in medicine
Published Date:

Abstract

Temporal information plays a crucial role in medicine. Patients' clinical records are intrinsically temporal. Thus, in Medical Informatics there is an increasing need to store, support and query temporal data (particularly in relational databases), in order, for instance, to supplement decision-support systems. In this paper, we show that current approaches to relational data have remarkable limitations in the treatment of "now-relative" data (i.e., data holding true at the current time). This can severely compromise their applicability in general, and specifically in the medical context, where "now-relative" data are essential to assess the current status of the patients. We propose a theoretically grounded and application-independent relational approach to cope with now-relative data (which can be paired, e.g., with different decision support systems) overcoming such limitations. We propose a new temporal relational representation, which is the first relational model coping with the temporal indeterminacy intrinsic in now-relative data. We also propose new temporal algebraic operators to query them, supporting the distinction between possible and necessary time, and Allen's temporal relations between data. We exemplify the impact of our approach, and study the theoretical and computational properties of the new representation and algebra.

Authors

  • Luca Anselma
    Dipartimento di Informatica, Università degli Studi di Torino, Corso Svizzera 185, 10149 Torino, Italy. Electronic address: anselma@di.unito.it.
  • Luca Piovesan
    Computer Science Institute, Dipartimento di Scienze e Innovazione Tecnologica, Università del Piemonte Orientale, Viale Teresa Michel 11, 15121 Alessandria, Italy. Electronic address: luca.piovesan@uniupo.it.
  • Bela Stantic
    Institute for Integrated and Intelligent Systems, Griffith University, Queensland, Australia. Electronic address: b.stantic@griffith.edu.au.
  • Paolo Terenziani
    Computer Science Institute, DISIT, Univ. Piemonte Orientale, Alessandria, Italy.