An Extended SQL for Temporal Data Management in Clinical Decision-Support Systems

From Tetherless World Wiki

Jump to: navigation, search

Citation: Amar K. Das and Samson W. Tu and Gretchen P. Purcell and Mark A. Musen. (1992) An Extended SQL for Temporal Data Management in Clinical Decision-Support Systems. In KSL-92-24, 1992.

Publication techreport ( Edit )
type Technical Report
bibtype techreport
Bibtex basics
author Amar K. Das and Samson W. Tu and Gretchen P. Purcell and Mark A. Musen
title An Extended SQL for Temporal Data Management in Clinical Decision-Support Systems
number KSL-92-24
institution Knowledge Systems, AI Laboratory
address Washington, D.C.
year 1992
Bibtex more
Access Paper
abstract We are currently developing a database implementation to support the temporal semantics of medical data for the T-HELPER physician workstation, a data-management and advice system for protocol-based care of patients who have HIV disease. To understand the requirements of a temporal querying language for the database, we have analyzed the types of temporal predicates found in the clinical-trial protocols. We have extended the standard relational data model with new temporal representations and operations to support these querying requirements. We define a history as a relational table that uses real-world time to store both instant-based events and interval-based states. We also develop a set of temporal operations on events and states as the basis for creating a relational algebra for histories. We use the set of algebraic operators to execute an extended SQL that supports protocol data-management requirements.

KSL Technical Report ID: KSL-92-24
Facts about An Extended SQL for Temporal Data Management in Clinical Decision-Support SystemsRDF feed
Abstract We are currently developing a database imp … We are currently developing a database implementation to support the temporal semantics of medical data for the T-HELPER physician workstation, a data-management and advice system for protocol-based care of patients who have HIV disease. To understand the requirements of a temporal querying language for the database, we have analyzed the types of temporal predicates found in the clinical-trial protocols. We have extended the standard relational data model with new temporal representations and operations to support these querying requirements. We define a history as a relational table that uses real-world time to store both instant-based events and interval-based states. We also develop a set of temporal operations on events and states as the basis for creating a relational algebra for histories. We use the set of algebraic operators to execute an extended SQL that supports protocol data-management requirements. rts protocol data-management requirements.
Address Washington, D.C.  +
Author Amar K. Das and Samson W. Tu and Gretchen P. Purcell and Mark A. Musen  +
Bibtype techreport  +
Has author Amar K. Das and Samson W. Tu and Gretchen P. Purcell and Mark A. Musen  +
Has identifier KSL-92-24  +
Has publishing details 1992  +
Has title An Extended SQL for Temporal Data Management in Clinical Decision-Support Systems  +
Has where published KSL-92-24  +
Has year 1992  +
Institution Knowledge Systems, AI Laboratory  +
Ksl tr id KSL-92-24  +
Number KSL-92-24  +
Process note YES  +
Title An Extended SQL for Temporal Data Management in Clinical Decision-Support Systems  +
Year 1992  +
Retrieved from "http://tw.rpi.edu/wiki/An_Extended_SQL_for_Temporal_Data_Management_in_Clinical_Decision-Support_Systems"
Personal tools