Applying object-oriented technologies in modeling and querying temporally oriented clinical databases dealing with temporal granularity and indeterminacy

Authors:
C. Combi;G. Cucchi;F. Pinciroli
Affiliations:
Dipt. di Matematica e Inf., Udine Univ., Italy;-;-
Venue:
IEEE Transactions on Information Technology in Biomedicine
Year:
1997

Citing 0
Cited 13

Temporal granularity for unanchored temporal data

Proceedings of the seventh international conference on Information and knowledge management
Temporal Granularity: Completing the Puzzle

Journal of Intelligent Information Systems
Visualizing Temporal Clinical Data on the WWW

AIMDM '99 Proceedings of the Joint European Conference on Artificial Intelligence in Medicine and Medical Decision Making
Temporal Databases with Null Values

DEXA '00 Proceedings of the 11th International Conference on Database and Expert Systems Applications
HMAP– A temporal data model managing intervals with different granularities and indeterminacy from natural language sentences

The VLDB Journal — The International Journal on Very Large Data Bases
T-ODMG: an ODMG compliant temporal object model supporting multiple granularity management

Information Systems
Temporal reasoning for decision support in medicine

Artificial Intelligence in Medicine
Position paper: Temporal representation and reasoning in medicine: Research directions and challenges

Artificial Intelligence in Medicine
Merging multimedia presentations and semistructured temporal data: a graph-based model and its application to clinical information

Artificial Intelligence in Medicine
Intelligent visualization and exploration of time-oriented data of multiple patients

Artificial Intelligence in Medicine
Intelligent selection and retrieval of multiple time-oriented records

Journal of Intelligent Information Systems
Visually defining and querying consistent multi-granular clinical temporal abstractions

Artificial Intelligence in Medicine
Querying temporal clinical databases on granular trends

Journal of Biomedical Informatics

Quantified Score

Hi-index	0.00

Visualization

Abstract

The need to manage temporal information given at different levels of granularity or with indeterminacy is common to many application areas. Among them, we focus on clinical data management. Different time granularities and indeterminacy are also needed in querying temporal databases. In this paper, we describe GCH-OSQL (Granular Clinical History-Object Structured Query Language), an object-oriented/temporally-oriented extension of SQL. GCH-OSQL is based on an object-oriented temporal data model, GCH-OODM. GCH-OODM allows storage of clinical information at different and mixed granularities or with temporal indeterminacy. GCH-OSQL deals with the valid time of clinical information. The temporal extension of the SELECT construct includes the addition of the TIME-SLICE and MOVING WINDOW clauses, and the capability to reference the temporal dimension of objects in the WHERE and SELECT clauses. Using object-oriented technologies, a system prototype for GCH-OSQL and GCH-OODM has been implemented and applied to data management of follow-up patients after coronary angioplasty intervention.