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

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.

DOI: 10.1109/4233.640654

8 Figures and Tables

Statistics

01020'99'01'03'05'07'09'11'13'15'17
Citations per Year

62 Citations

Semantic Scholar estimates that this publication has 62 citations based on the available data.

See our FAQ for additional information.

Cite this paper

@article{Combi1997ApplyingOT, title={Applying object-oriented technologies in modeling and querying temporally oriented clinical databases dealing with temporal granularity and indeterminacy}, author={Carlo Combi and Giancarlo Cucchi and Francesco Pinciroli}, journal={IEEE Transactions on Information Technology in Biomedicine}, year={1997}, volume={1}, pages={100-127} }