Related Experiment Video
Updated: Aug 15, 2026

Temporal Ordering of Dynamic Expression Data from Detailed Spatial Expression Maps
Published on: February 9, 2017
Querying temporal clinical databases with different time granularities: the GCH-OSQL language
C Combi1, F Pinciroli, M Cavallaro
1Dipartimento di Bioingegneria del Politecnico di Milano.
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.
More Related Videos
07:26Executing Complexity-Increasing Queries in Relational (MySQL) and NoSQL (MongoDB and EXist) Size-Growing ISO/EN 13606 Standardized EHR Databases
Published on: March 19, 2018
09:43Databases to Efficiently Manage Medium Sized, Low Velocity, Multidimensional Data in Tissue Engineering
Published on: November 22, 2019
Related Concept Videos
Introduction To Survival Analysis
The primary goal of survival analysis is to estimate survival time—the time until a...
Comparing the Survival Analysis of Two or More Groups