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

Exploring performance issues for a clinical database organized using an entity-attribute-value representation.

R S Chen1, P Nadkarni, L Marenco

  • 1Yale University, New Haven, Connecticut, USA.

Journal of the American Medical Informatics Association : JAMIA
|September 14, 2000
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

[Examining the origin of the Zheng's in Kunshan and their medical physicians].

Zhonghua yi shi za zhi (Beijing, China : 1980)·2026
Same author

Predicted deleterious mutations reveal the genetic architecture of male reproductive success in a lekking bird.

Nature ecology & evolution·2025
Same author

[The versions of <i>Song Xin Notes</i> and their content].

Zhonghua yi shi za zhi (Beijing, China : 1980)·2025
Same author

[The unpublished manuscript <i>He Yao Zong Bu</i> in the Wu Medicine School].

Zhonghua yi shi za zhi (Beijing, China : 1980)·2025
Same author

[Pathological diagnosis and differential diagnosis of anorectal neoplastic diseases].

Zhonghua bing li xue za zhi = Chinese journal of pathology·2025
Same author

[Yue Chang and his <i>Yao Xing Ji Yao Bian Du</i>].

Zhonghua yi shi za zhi (Beijing, China : 1980)·2024
Same journal

Digital divide in clinical and operational artificial intelligence adoption and implementation stages: US hospital diffusion patterns and AI deserts.

Journal of the American Medical Informatics Association : JAMIA·2026
Same journal

Extending the fundamental theorem of biomedical informatics: a proposal and illustrative examples.

Journal of the American Medical Informatics Association : JAMIA·2026
Same journal

Human factors methods for designing safe health information technology: what do the experts think?

Journal of the American Medical Informatics Association : JAMIA·2026
Same journal

Equity-by-design for socially assistive robots as digital health tools.

Journal of the American Medical Informatics Association : JAMIA·2026
Same journal

Orchestrator multi-agent clinical decision support system for secondary headache diagnosis in primary care.

Journal of the American Medical Informatics Association : JAMIA·2026
Same journal

CUI-Curate: a GraphRAG-based framework for automated clinical concept curation for NLP applications.

Journal of the American Medical Informatics Association : JAMIA·2026
See all related articles

The entity-attribute-value (EAV/CR) model is less efficient for attribute-centered queries than conventional databases. Optimizing EAV/CR query strategies and hardware can improve performance for biomedical data retrieval.

Area of Science:

  • Biomedical Informatics
  • Database Management Systems

Background:

  • The entity-attribute-value with classes and relationships (EAV/CR) model offers flexibility for heterogeneous biomedical data.
  • However, EAV/CR can be less efficient for data retrieval compared to conventional database schemas.

Purpose of the Study:

  • To quantify performance differences between EAV/CR and conventional models for real-world microbiology data.
  • To explore EAV/CR query implementation strategies for optimizing performance.

Main Methods:

  • Clinical microbiology data were stored using both EAV/CR and conventional models over ten years.
  • Query execution times were compared for attribute-centered and entity-centered queries under varying database sizes and memory.
  • Three EAV/CR query strategies were evaluated.

Related Experiment Videos

Main Results:

  • Entity-centered queries performed similarly across both models.
  • Attribute-centered queries were 3-5 times less efficient in EAV/CR than conventional models.
  • EAV/CR query performance improved with increased system memory and batch processing of simple SQL statements.

Conclusions:

  • EAV/CR and conventional models show performance differences, particularly for attribute-centered queries.
  • Hardware upgrades (more memory, powerful hardware) can mitigate EAV/CR performance inefficiencies.