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

Exploratory data analysis using set operations and ordinal mapping.

Tim Churches1

  • 1Epidemiology and Surveillance Branch, New South Wales Department of Health, Locked Mail Bag 961, North Sydney, NSW 2059, Australia. tchur@doh.health.nsw.gov

Computer Methods and Programs in Biomedicine
|May 3, 2003
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

Compliance with Australian Orthopaedic Association guidelines does not reduce the risk of venous thromboembolism after total hip and knee arthroplasty.

Scientific reports·2024
Same author

Association between VTE and antibiotic prophylaxis guideline compliance and patient-reported outcomes after total hip and knee arthroplasty: an observational study.

Journal of patient-reported outcomes·2022
Same author

Modelling vaccination capacity at mass vaccination hubs and general practice clinics: a simulation study.

BMC health services research·2022
Same author

Non-compliance with clinical guidelines increases the risk of complications after primary total hip and knee joint replacement surgery.

PloS one·2021
Same author

Cost of investigations during the acute hospital stay following total hip or knee arthroplasty, by complication status.

BMC health services research·2020
Same author

Wrist deformity, bother and function following wrist fracture in the elderly.

BMC research notes·2020

New data processing methods improve health data analysis. Set operations on ordinal mappings (SOOM) offer faster query responses for large health datasets compared to traditional SQL databases.

Area of Science:

  • Health Informatics
  • Database Management
  • Data Science

Background:

  • Exploratory data analysis (EDA) for health datasets requires efficient ad hoc querying.
  • Increasing health data volumes challenge traditional data processing methods, leading to slow query response times.
  • Existing database solutions struggle to meet the performance demands of modern EDA.

Purpose of the Study:

  • To introduce and evaluate an alternative data processing technique for health data EDA.
  • To address the performance limitations of conventional methods in handling large health datasets.
  • To demonstrate a novel approach for faster data summarization and filtering.

Main Methods:

  • The study describes a technique combining complete vertical data partitioning with set operations on ordinal mappings (SOOM).

Related Experiment Videos

  • An initial implementation was developed to test the SOOM technique.
  • Performance was benchmarked against conventional SQL databases using typical EDA queries.

    • Main Results:

    • The SOOM technique demonstrated significantly improved performance over conventional SQL databases for EDA queries.
    • Initial implementation showed substantial gains in response times for filtering and summarization tasks.
    • The approach proved effective in handling large-scale health data.

    Conclusions:

    • The SOOM technique offers a viable and high-performance alternative for health data exploratory analysis.
    • Vertical partitioning and set operations on ordinal mappings provide a scalable solution for growing health datasets.
    • Further performance enhancements through parallel, distributed computation appear feasible.