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 relational operators for statistical data manipulations in medical databases.

H H Yao1, T S Yamashita

  • 1Department of Computer Engineering and Science, Case Western Reserve University, Cleveland, Ohio 44106.

Computers and Biomedical Research, an International Journal
|December 1, 1989
PubMed
Summary

This study introduces the lattice relational model and five extended operators to efficiently manage large, hierarchical statistical and medical data (SMD). These advancements overcome limitations in conventional systems for biomedical databases.

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

[Clinical characteristics of crystal deposits in joints and tendons in patients with gout].

Beijing da xue xue bao. Yi xue ban = Journal of Peking University. Health sciences·2021
Same author

[Clinical characteristics and risk factors of cardiovascular disease in patients with elderly-onset rheumatoid arthritis: A large cross-sectional clinical study].

Beijing da xue xue bao. Yi xue ban = Journal of Peking University. Health sciences·2020
Same author

[Clinical characteristics and treatment outcomes of macrophage activation syndrome in adults: A case series of 67 patients].

Beijing da xue xue bao. Yi xue ban = Journal of Peking University. Health sciences·2019
Same author

[Study of bone mineral density and serum bone turnover markers in newly diagnosed systemic lupus erythematosus patients].

Beijing da xue xue bao. Yi xue ban = Journal of Peking University. Health sciences·2018
Same author

[Clinical and immunological characteristics of patients with systemic lupus erythematosus in Tibet plateau, China].

Beijing da xue xue bao. Yi xue ban = Journal of Peking University. Health sciences·2018
Same author

[Increased serum C-C chemokine ligand 19 levels correlated with B cell abnormalities in systemic lupus erythematosus].

Beijing da xue xue bao. Yi xue ban = Journal of Peking University. Health sciences·2017

Area of Science:

  • Biomedical Informatics
  • Database Management Systems
  • Statistical Data Analysis

Background:

  • Conventional relational database management systems struggle with the unique demands of statistical and medical data (SMD).
  • SMD requires efficient storage due to large size, minimal duplication, and dynamic attribute growth from derived statistics.
  • Hierarchical structures inherent in SMD are poorly managed by traditional relational models, necessitating separate relations that increase complexity.

Purpose of the Study:

  • To address the limitations of conventional relational database systems in managing biomedical and clinical data.
  • To introduce novel methods for efficient storage, reorganization, and manipulation of statistical and medical data.
  • To propose a new data model and operators specifically designed for the complexities of medical databases.

Related Experiment Videos

Main Methods:

  • Introduction of five extended relational operators: (lattice) NEST, (lattice) UNNEST, MERGE, SPREAD, and GEN.
  • Integration of these extended operators with conventional relational algebra.
  • Development and application of the lattice relational model for statistical data manipulation.

Main Results:

  • The proposed extended operators enable effective reorganization and grouping of relations.
  • The lattice relational model provides a framework to manage hierarchical and large-volume SMD.
  • Demonstrated applications of the new model and operators in solving practical medical database challenges.

Conclusions:

  • The lattice relational model and extended operators offer a superior solution for managing statistical and medical data compared to conventional systems.
  • These advancements facilitate more efficient storage, reduce data redundancy, and improve the handling of complex data structures in biomedical databases.
  • The proposed framework enhances the capabilities of medical databases, supporting better data analysis and management.