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

Extended SQL for manipulating clinical warehouse data.

S B Johnson1, D Chatziantoniou

  • 1Department of Medical Informatics, Columbia University, USA.

Proceedings. AMIA Symposium
|November 24, 1999
PubMed
Summary
This summary is machine-generated.

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

Ethical Reasoning During a Pandemic: Results of a Five Country European Study.

AJOB empirical bioethics·2022
Same author

COVID-19 contact tracing apps: UK public perceptions.

Critical public health·2022
Same author

Estimating survival in advanced cancer: a comparison of estimates made by oncologists and patients.

Supportive care in cancer : official journal of the Multinational Association of Supportive Care in Cancer·2019
Same author

First Report of White Mold (Sclerotinia sclerotiorum) on Soybean in Maine.

Plant disease·2019
Same author

First Report of Potato mop-top virus on Potato from the United States.

Plant disease·2019
Same author

The 2009 Late Blight Pandemic in the Eastern United States - Causes and Results.

Plant disease·2019
Same journal

Progressive display of very high resolution images using wavelets.

Proceedings. AMIA Symposium·2002
Same journal

The Chronus II temporal database mediator.

Proceedings. AMIA Symposium·2002
Same journal

Gene expression levels in different stages of progression in oral squamous cell carcinoma.

Proceedings. AMIA Symposium·2002
Same journal

An assessment of the visibility of MeSH-indexed medical web catalogs through search engines.

Proceedings. AMIA Symposium·2002
Same journal

Filtering for medical news items using a machine learning approach.

Proceedings. AMIA Symposium·2002
Same journal

Enriching the structure of the UMLS semantic network.

Proceedings. AMIA Symposium·2002
See all related articles

This study introduces an extended SQL for efficient clinical data analysis. It enables faster data aggregation and manipulation, improving clinical data mining and research.

Area of Science:

  • Health Informatics
  • Database Management
  • Clinical Data Analytics

Background:

  • Healthcare institutions generate vast amounts of clinical data.
  • Clinical data warehouses facilitate analysis but present schema and performance challenges.
  • Existing data structures hinder efficient analytical tasks and data mining.

Purpose of the Study:

  • To present an extension to SQL for improved clinical data analysis.
  • To enable efficient manipulation and aggregation of grouped rows in clinical data.
  • To enhance the performance of analytical queries on large clinical datasets.

Main Methods:

  • Developed an extension to the Structured Query Language (SQL).
  • The extension allows designation and manipulation of row groups.

Related Experiment Videos

  • Implemented aggregations and analysis on large datasets.

    • Main Results:

    • The extended SQL provides a concise way to designate row groups.
    • Queries run in linear time, significantly outperforming standard SQL's polynomial performance.
    • Demonstrated powerful aggregation capabilities for large data volumes.

    Conclusions:

    • The SQL extension offers a powerful and efficient solution for clinical data mining.
    • Improves the usability and performance of clinical data warehouses for research and analysis.
    • Facilitates complex data analysis, benefiting patient care and administrative reporting.