Skip to main content
Proceedings of the Annual Symposium on Computer Application in Medical Care logoLink to Proceedings of the Annual Symposium on Computer Application in Medical Care
. 1995:326–330.

Querying temporal clinical databases with different time granularities: the GCH-OSQL language.

C Combi 1, F Pinciroli 1, M Cavallaro 1, G Cucchi 1
PMCID: PMC2579108  PMID: 8563295

Abstract

There is a need for managing temporal clinical information given at different levels of granularity. Different time granularities are also needed in querying clinical 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. It allows storage of clinical information at different and mixed granularities. GCH-OSQL deals with the valid time of clinical information. GCH-OSQL offers also a graphical user-interface. It guides different end users, from expert to naive, to formulate expressive and correct queries.

Full text

PDF
326

Selected References

These references are in PubMed. This may not be the complete list of references from this article.

  1. Kahn M. G., Tu S., Fagan L. M. TQuery: a context-sensitive temporal query language. Comput Biomed Res. 1991 Oct;24(5):401–419. doi: 10.1016/0010-4809(91)90016-p. [DOI] [PubMed] [Google Scholar]
  2. Shahar Y., Musen M. A. RESUME: a temporal-abstraction system for patient monitoring. Comput Biomed Res. 1993 Jun;26(3):255–273. doi: 10.1006/cbmr.1993.1018. [DOI] [PubMed] [Google Scholar]

Articles from Proceedings of the Annual Symposium on Computer Application in Medical Care are provided here courtesy of American Medical Informatics Association

RESOURCES