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

Supporting temporal queries on clinical relational databases: the S-WATCH-QL language

C Combi1, L Missora, F Pinciroli

  • 1Dipartimento di Matematica e Informatica, Università degli Studi di Udine.

Proceedings : a Conference of the American Medical Informatics Association. AMIA Fall Symposium
|January 1, 1996
PubMed
Summary

This paper introduces Structured Watch Query Language (S-WATCH-QL), a temporal extension for SQL. It enhances clinical databases with temporal data types and historical relations for complex temporal queries.

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

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
Same author

A three-layer multidatabase system for functional statistical analyses of microarray experiment results.

Conference proceedings : ... Annual International Conference of the IEEE Engineering in Medicine and Biology Society. IEEE Engineering in Medicine and Biology Society. Annual Conference·2007

Area of Science:

  • Computer Science
  • Database Management
  • Temporal Databases

Background:

  • Clinical databases require specialized handling of time-sensitive data.
  • Existing SQL lacks robust temporal data management capabilities.
  • The ubiquitous nature of time necessitates advanced temporal operators.

Purpose of the Study:

  • To introduce S-WATCH-QL (Structured Watch Query Language) as a temporal extension of SQL.
  • To address the need for specialized temporal data and operators in clinical databases.
  • To enable more sophisticated temporal data querying and analysis.

Main Methods:

  • Developed S-WATCH-QL as a temporal extension to the relational model-based SQL.
  • Introduced temporal data types supporting various granularities.

Related Experiment Videos

  • Incorporated historical relations for storing instantaneous and interval-based temporal information.
  • Added temporal clauses, functions, and predicates for complex query definition.

    • Main Results:

    • S-WATCH-QL effectively extends SQL with temporal functionalities.
    • The language supports diverse temporal data granularities.
    • Historical relations efficiently manage both valid times and intervals.
    • Complex temporal queries can be defined using the new temporal clauses and predicates.

    Conclusions:

    • S-WATCH-QL provides a powerful solution for temporal data management in relational databases.
    • The extension is particularly beneficial for clinical databases requiring precise temporal analysis.
    • This work enhances the capability of SQL for handling time-dependent information.