Extending temporal databases to deal with telic/atelic medical data

Paolo Terenziani, Richard Thomas Snodgrass, Alessio Bottrighi, Mauro Torchio, Gianpaolo Molino

Research output: Contribution to journalArticle

14 Citations (Scopus)

Abstract

Objective: In this paper, we aim at defining a general-purpose data model and query language coping with both "telic" and "atelic" medical data. Background: In the area of Medical Informatics, there is an increasing realization that temporal information plays a crucial role, so that suitable database models and query languages are needed to store and support it. However, despite the wide range of approaches in the area, in this paper we show that a relevant class of medical data cannot be properly dealt with. Methodology: We first show that data models based on the "point-based" semantics, which is (implicitly or explicitly) assumed by the totality of temporal database approaches, have several limitations when dealing with "telic" data. We then propose a new model (based on the "interval-based" semantics) to cope with such data, and extend the query language accordingly. Results: We propose a new three-sorted model and a query language to properly deal with both "telic" and "atelic" medical data (as well as non-temporal data). Our query language is flexible, since it allows one to switch from "atelic" to "telic" data, and vice versa. Conclusion: In this paper, we demostrate the feasibilty of a database approach copying with both telic and atelic data as needed in several (medical) applications.

Original languageEnglish (US)
Pages (from-to)113-126
Number of pages14
JournalArtificial Intelligence in Medicine
Volume39
Issue number2
DOIs
StatePublished - Feb 2007

Fingerprint

Query languages
Language
Databases
Semantics
Data structures
Medical Informatics
Copying
Medical applications
Switches

Keywords

  • Data semantics
  • Relational data model
  • Telic/atelic clinical data
  • Temporal databases
  • TSQL2-like query language

ASJC Scopus subject areas

  • Artificial Intelligence
  • Medicine(all)

Cite this

Extending temporal databases to deal with telic/atelic medical data. / Terenziani, Paolo; Snodgrass, Richard Thomas; Bottrighi, Alessio; Torchio, Mauro; Molino, Gianpaolo.

In: Artificial Intelligence in Medicine, Vol. 39, No. 2, 02.2007, p. 113-126.

Research output: Contribution to journalArticle

Terenziani, Paolo ; Snodgrass, Richard Thomas ; Bottrighi, Alessio ; Torchio, Mauro ; Molino, Gianpaolo. / Extending temporal databases to deal with telic/atelic medical data. In: Artificial Intelligence in Medicine. 2007 ; Vol. 39, No. 2. pp. 113-126.
@article{5e82ea28397f4e11abce56f0fc33574a,
title = "Extending temporal databases to deal with telic/atelic medical data",
abstract = "Objective: In this paper, we aim at defining a general-purpose data model and query language coping with both {"}telic{"} and {"}atelic{"} medical data. Background: In the area of Medical Informatics, there is an increasing realization that temporal information plays a crucial role, so that suitable database models and query languages are needed to store and support it. However, despite the wide range of approaches in the area, in this paper we show that a relevant class of medical data cannot be properly dealt with. Methodology: We first show that data models based on the {"}point-based{"} semantics, which is (implicitly or explicitly) assumed by the totality of temporal database approaches, have several limitations when dealing with {"}telic{"} data. We then propose a new model (based on the {"}interval-based{"} semantics) to cope with such data, and extend the query language accordingly. Results: We propose a new three-sorted model and a query language to properly deal with both {"}telic{"} and {"}atelic{"} medical data (as well as non-temporal data). Our query language is flexible, since it allows one to switch from {"}atelic{"} to {"}telic{"} data, and vice versa. Conclusion: In this paper, we demostrate the feasibilty of a database approach copying with both telic and atelic data as needed in several (medical) applications.",
keywords = "Data semantics, Relational data model, Telic/atelic clinical data, Temporal databases, TSQL2-like query language",
author = "Paolo Terenziani and Snodgrass, {Richard Thomas} and Alessio Bottrighi and Mauro Torchio and Gianpaolo Molino",
year = "2007",
month = "2",
doi = "10.1016/j.artmed.2006.08.003",
language = "English (US)",
volume = "39",
pages = "113--126",
journal = "Artificial Intelligence in Medicine",
issn = "0933-3657",
publisher = "Elsevier",
number = "2",

}

TY - JOUR

T1 - Extending temporal databases to deal with telic/atelic medical data

AU - Terenziani, Paolo

AU - Snodgrass, Richard Thomas

AU - Bottrighi, Alessio

AU - Torchio, Mauro

AU - Molino, Gianpaolo

PY - 2007/2

Y1 - 2007/2

N2 - Objective: In this paper, we aim at defining a general-purpose data model and query language coping with both "telic" and "atelic" medical data. Background: In the area of Medical Informatics, there is an increasing realization that temporal information plays a crucial role, so that suitable database models and query languages are needed to store and support it. However, despite the wide range of approaches in the area, in this paper we show that a relevant class of medical data cannot be properly dealt with. Methodology: We first show that data models based on the "point-based" semantics, which is (implicitly or explicitly) assumed by the totality of temporal database approaches, have several limitations when dealing with "telic" data. We then propose a new model (based on the "interval-based" semantics) to cope with such data, and extend the query language accordingly. Results: We propose a new three-sorted model and a query language to properly deal with both "telic" and "atelic" medical data (as well as non-temporal data). Our query language is flexible, since it allows one to switch from "atelic" to "telic" data, and vice versa. Conclusion: In this paper, we demostrate the feasibilty of a database approach copying with both telic and atelic data as needed in several (medical) applications.

AB - Objective: In this paper, we aim at defining a general-purpose data model and query language coping with both "telic" and "atelic" medical data. Background: In the area of Medical Informatics, there is an increasing realization that temporal information plays a crucial role, so that suitable database models and query languages are needed to store and support it. However, despite the wide range of approaches in the area, in this paper we show that a relevant class of medical data cannot be properly dealt with. Methodology: We first show that data models based on the "point-based" semantics, which is (implicitly or explicitly) assumed by the totality of temporal database approaches, have several limitations when dealing with "telic" data. We then propose a new model (based on the "interval-based" semantics) to cope with such data, and extend the query language accordingly. Results: We propose a new three-sorted model and a query language to properly deal with both "telic" and "atelic" medical data (as well as non-temporal data). Our query language is flexible, since it allows one to switch from "atelic" to "telic" data, and vice versa. Conclusion: In this paper, we demostrate the feasibilty of a database approach copying with both telic and atelic data as needed in several (medical) applications.

KW - Data semantics

KW - Relational data model

KW - Telic/atelic clinical data

KW - Temporal databases

KW - TSQL2-like query language

UR - http://www.scopus.com/inward/record.url?scp=33846435761&partnerID=8YFLogxK

UR - http://www.scopus.com/inward/citedby.url?scp=33846435761&partnerID=8YFLogxK

U2 - 10.1016/j.artmed.2006.08.003

DO - 10.1016/j.artmed.2006.08.003

M3 - Article

C2 - 17027241

AN - SCOPUS:33846435761

VL - 39

SP - 113

EP - 126

JO - Artificial Intelligence in Medicine

JF - Artificial Intelligence in Medicine

SN - 0933-3657

IS - 2

ER -