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

Data extraction and ad hoc query of an entity-attribute-value database

P M Nadkarni1, C Brandt

  • 1Yale University, New Haven, Connecticut, USA. prakash.nadkarni@yale.edu

Journal of the American Medical Informatics Association : JAMIA
|November 24, 1998
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

Tomographic inversion method to characterize coherent mode activity in the Wendelstein 7-X stellarator.

The Review of scientific instruments·2026
Same author

Knowledge, self-perception and ability of pelvic floor muscle contraction among Nepalese women with urinary incontinence.

Brazilian journal of physical therapy·2026
Same author

Accurate and reproducible whole-genome genotyping for bacterial genomic surveillance with Nanopore sequencing data.

Journal of clinical microbiology·2025
Same author

Gut microbiota and immune profiling of microbiota-humanised versus wildtype mouse models of hepatointestinal schistosomiasis.

Animal microbiome·2024
Same author

Synthetic Mirnov diagnostic for the validation of experimental observations.

The Review of scientific instruments·2024
Same author

Infection prevention and control between legal requirements and German Society for Hygiene and Microbiology expert assessments: a cross-sectional study in September-November 2022.

The Journal of hospital infection·2023

Electronic patient record systems using Entity-Attribute-Value (EAV) tables hinder data warehousing. This study introduces ACT/DB, a metadata-driven approach to improve attribute-centric queries in clinical trial data management.

Area of Science:

  • Health Informatics
  • Database Management
  • Clinical Data Management

Background:

  • Electronic patient record systems (EPRSs) commonly use Entity-Attribute-Value (EAV) tables, optimized for individual patient data retrieval.
  • Data warehousing requires cross-patient queries based on attributes, which is challenging with EAV data structures.
  • Attribute-centric querying is more complex in EAV formats compared to conventional database designs.

Purpose of the Study:

  • To address the challenge of attribute-centric querying in EAV-based electronic patient record systems.
  • To present a novel approach for managing and querying clinical trials data stored in EAV format.
  • To improve the efficiency of data warehousing and ad hoc querying for clinical trial data.

Main Methods:

  • Developed ACT/DB, a database system specifically for managing clinical trials data.

Related Experiment Videos

  • Implemented a metadata layer to support a query front end.
  • Designed the query front end to abstract the underlying EAV or non-EAV nature of attributes from users.

    • Main Results:

    • Demonstrated an approach to facilitate attribute-centric queries on EAV data.
    • Successfully managed clinical trials data using the ACT/DB system.
    • Highlighted the effectiveness of metadata in simplifying complex data structures for users.

    Conclusions:

    • The proposed metadata-driven query front end offers a viable solution for attribute-centric querying in EAV systems.
    • While progress has been made, the query problem is not fully solved, with several complex subproblems remaining.
    • Further research is needed to address the identified complex subproblems in EAV data querying for data warehousing.