Jove
Visualize
Contact Us
JoVE
x logofacebook logolinkedin logoyoutube logo
ABOUT JoVE
OverviewLeadershipBlogJoVE Help Center
AUTHORS
Publishing ProcessEditorial BoardScope & PoliciesPeer ReviewFAQSubmit
LIBRARIANS
TestimonialsSubscriptionsAccessResourcesLibrary Advisory BoardFAQ
RESEARCH
JoVE JournalMethods CollectionsJoVE Encyclopedia of ExperimentsArchive
EDUCATION
JoVE CoreJoVE BusinessJoVE Science EducationJoVE Lab ManualFaculty Resource CenterFaculty Site
Terms & Conditions of Use
Privacy Policy
Policies

Related Experiment Videos

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

IEEE Transactions on Information Technology in Biomedicine : a Publication of the IEEE Engineering in Medicine and Biology Society
|June 1, 1997
PubMed
Summary

Related Concept Videos

You might also read

Related Articles

Articles linked to this work by shared authors, journal, and citation graph.

Sort by
Same author

Additional booster doses in patients with chronic lymphocytic leukemia induce humoral and cellular immune responses to SARS-CoV-2 similar to natural infection regardless ongoing treatments: A study by ERIC, the European Research Initiative on CLL.

American journal of hematology·2024
Same author

New e-Health Tracks in Engineering Education of the Politecnico di Milano.

Yearbook of medical informatics·2016
Same author

Medical Informatics and Telemedicine at the Politecnico di Milano.

Yearbook of medical informatics·2016
Same author

Early effects comparison of X-rays delivered at high-dose-rate pulses by a plasma focus device and at low dose rate on human tumour cells.

Radiation protection dosimetry·2015
Same author

A pictorial schema for a comprehensive user-oriented identification of medical Apps.

Methods of information in medicine·2014
Same author

A comprehensive e-prescribing model to allow representing, comparing, and analyzing available systems.

Methods of information in medicine·2013

Managing clinical data with varying time details is crucial. GCH-OSQL (Granular Clinical History-Object Structured Query Language) offers a solution for temporal databases, improving clinical information management.

Area of Science:

  • Computer Science
  • Medical Informatics

Background:

  • Managing temporal information with varying granularity and indeterminacy is a widespread challenge in many fields.
  • Clinical data management frequently encounters these temporal complexities.
  • Querying temporal databases also necessitates handling diverse time granularities and uncertainties.

Purpose of the Study:

  • To introduce GCH-OSQL (Granular Clinical History-Object Structured Query Language), an object-oriented, temporally-oriented extension of SQL.
  • To present the GCH-OODM (Granular Clinical History-Object Data Model) for storing clinical information with mixed granularities and temporal indeterminacy.
  • To address the valid time of clinical information within a database context.

Main Methods:

  • Developed GCH-OSQL, an extension of SQL incorporating temporal features.

Related Experiment Videos

  • Designed GCH-OODM to support storage of clinical data with flexible temporal attributes.
  • Implemented a system prototype using object-oriented technologies for GCH-OSQL and GCH-OODM.

    • Main Results:

    • GCH-OSQL extends the SELECT construct with TIME-SLICE and MOVING WINDOW clauses.
    • The system allows referencing the temporal dimension of objects in WHERE and SELECT clauses.
    • The prototype was successfully applied to manage follow-up patient data post-coronary angioplasty.

    Conclusions:

    • GCH-OSQL and GCH-OODM provide a robust framework for managing complex temporal clinical data.
    • The developed system demonstrates practical application in real-world clinical scenarios.
    • This approach enhances the querying and management of granular and indeterminate temporal information in healthcare.