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

Easing the transition between attribute-value databases and conventional databases for scientific data.

P M Nadkarni1, L Marenco

  • 1Yale Center for Medical Informatics, New Haven, CT, USA.

Proceedings. AMIA Symposium
|February 5, 2002
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

Medical Informatics Training at Yale University School of Medicine.

Yearbook of medical informatics·2016
Same author

A hybrid human and machine resource curation pipeline for the Neuroscience Information Framework.

Database : the journal of biological databases and curation·2012
Same author

The Common Data Elements for cancer research: remarks on functions and structure.

Methods of information in medicine·2006
Same author

Automating identification of adverse events related to abnormal lab results using standard vocabularies.

AMIA ... Annual Symposium proceedings. AMIA Symposium·2006
Same author

Metadata driven generation of reports for clinical studies.

AMIA ... Annual Symposium proceedings. AMIA Symposium·2006
Same author

Integration of Web-based and PC-based clinical research databases.

Methods of information in medicine·2004
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

A new tool facilitates data transfer for the Entity-Attribute-Value/ aClass-aRecord (EAV/CR) framework, essential for managing complex scientific data. This overcomes previous limitations, enabling easier integration with legacy systems and analytical packages.

Area of Science:

  • Computer Science
  • Bioinformatics
  • Data Management

Background:

  • Scientific databases often contain highly heterogeneous and evolving data, requiring specialized modeling frameworks.
  • The Entity-Attribute-Value/ aClass-aRecord (EAV/CR) framework is suitable for such complex scientific data.
  • Existing data transfer tools struggle with the unique data representation of EAV/CR, hindering its adoption.

Purpose of the Study:

  • To develop a generic tool for non-procedural data transfer into and out of EAV/CR databases.
  • To address the limitations of commercial data-transfer programs in handling EAV vs. conventional data representations.
  • To facilitate the integration of EAV/CR databases with legacy systems and analytical packages.

Main Methods:

  • Developed a data transfer tool compatible with Microsoft OLE DB technology.

Related Experiment Videos

  • Ensured the tool requires minimal programmer intervention for setup.
  • Designed the tool for regular use without requiring programming knowledge.
  • Main Results:

    • The tool enables data transfer for EAV/CR databases from various OLE DB-accessible sources.
    • Significantly reduces the technical barrier for using the EAV/CR framework.
    • Demonstrates a practical solution for a previously identified bottleneck in scientific data management.

    Conclusions:

    • The developed data transfer tool enhances the usability of the EAV/CR framework for scientific databases.
    • This tool simplifies data integration, supporting research in rapidly advancing domains.
    • Further development may address current limitations and expand compatibility.