Representing and querying now-relative relational medical data.

Authors:
Luca Anselma
Luca Anselma
Università di Torino
Torino | Italy
Bela Stantic
Bela Stantic
Institute for Integrated and Intelligent Systems
Australia
Paolo Terenziani
Paolo Terenziani
Univ. Piemonte Orientale A. Avogadro
Alessandria | Italy

Artif Intell Med 2018 03 21;86:33-52. Epub 2018 Feb 21.

Computer Science Institute, DISIT, Università del Piemonte Orientale, Alessandria, Italy. Electronic address:

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.

Download full-text PDF

Source
http://dx.doi.org/10.1016/j.artmed.2018.01.004DOI Listing
March 2018
4 Reads

Publication Analysis

Top Keywords

data
9
propose temporal
8
now-relative data
8
"now-relative" data
8
temporal
7
relational
6
applicability general
4
compromise applicability
4
supporting distinction
4
severely compromise
4
general medical
4
query supporting
4
medical context
4
algebraic operators
4
essential assess
4
data essential
4
operators query
4
context "now-relative"
4
time severely
4
true current
4

Similar Publications

Towards an implicit treatment of periodically-repeated medical data.

Stud Health Technol Inform 2010 ;160(Pt 2):1131-5

Institute for Integrated and Intelligent Systems, Griffith Univ., Queensland, Australia.

Temporal information plays a crucial role in medicine, so that in Medical Informatics there is an increasing awareness that suitable database approaches are needed to store and support it. Specifically, a great amount of clinical data (e.g. Read More

View Article
April 2011

Coping efficiently with now-relative medical data.

AMIA Annu Symp Proc 2008 Nov 6:722-6. Epub 2008 Nov 6.

Institute for Integrated and Intelligent Systems, Griffith University, Queensland, Australia.

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. Read More

View Article
November 2008

A temporal query system for protocol-directed decision support.

Authors:
A K Das M A Musen

Methods Inf Med 1994 Oct;33(4):358-70

Section on Medical Informatics, Stanford University School of Medicine,CA.

Chronus is a query system that supports temporal extensions to the Structured Query Language (SQL) for relational databases. Although the relational data model can store time-stamped data and can permit simple temporal-comparison operations, it does not provide either a closed or a sufficient algebra for manipulating temporal data. In this paper, we outline an algebra that maintains a consistent relational representation of temporal data and that allows the type of temporal queries needed for protocol-directed decision support. Read More

View Article
October 1994

An implicit approach to deal with periodically repeated medical data.

Artif Intell Med 2012 Jul 13;55(3):149-62. Epub 2012 Apr 13.

Institute for Integrated and Intelligent Systems, Griffith University, 170 Kessels Road Nathan, Queensland 4111, Australia.

Context: Temporal information plays a crucial role in medicine, so that in medical informatics there is an increasing awareness that suitable database approaches are needed to store and support it. Specifically, a great amount of clinical data (e.g. Read More

View Article
July 2012