Applying object-oriented technologies in modeling and querying temporally oriented clinical databases dealing with
C Combi1, G Cucchi, F Pinciroli
1Dipartimento di Matematica e Informatica, Università degli Studi di Udine, Italy. combi@dimi.uniud.it
Abstract:
The need of managing 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.
More Related Videos
Related Concept Videos
Issues And Trends In Healthcare Delivery System
Cost Containment
Payment for healthcare services has historically promoted adoption of costly and often unnecessary or inefficient...
Methods of Documentation II: POMR
Methods of Documentation VI: Case Management Model
For example, a patient with a chronic illness...
Health Information Technology and Healthcare Information System
Health Information Technology, commonly called HIT, integrates advanced information systems and technology in healthcare settings. Its primary functions include:
Model Approaches for Pharmacokinetic Data: Compartment Models
Two primary types of compartment models are recognized: mammillary and catenary. The more...
Introduction To Survival Analysis
The primary goal of survival analysis is to estimate survival time—the time until a...


