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

A searching and reporting system for relational databases using a graph-based metadata representation.

Robin Hewitt1, Alberto Gobbi, Man-Ling Lee

  • 1Hewitt Consulting, San Diego, California 92103, USA. rhewitt@acm.org

Journal of Chemical Information and Modeling
|July 28, 2005
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

Conformation-Dependent Complexation Interactions for a SMARCA2 PROTAC and Cyclodextrin.

Molecular pharmaceutics·2025
Same author

Biologics for Subchondral Bone Injuries.

Clinics in sports medicine·2025
Same author

Autograft Cartilage Repair/Restorative Techniques in a Single Step.

Clinics in sports medicine·2025
Same author

Complications in anterior cruciate ligament reconstruction Articular cartilage reconstruction: Review of concepts, techniques, complications, risk factors, and Bail out/salvage strategies.

Journal of clinical orthopaedics and trauma·2025
Same author

One-Step Cartilage Repair of Full-Thickness Knee Chondral Lesions Using a Hyaluronic Acid-Based Scaffold Embedded With Bone Marrow Aspirate Concentrate: Long-term Outcomes After Mean Follow-up Duration of 14 Years.

The American journal of sports medicine·2024
Same author

Outcomes of the EMDataResource cryo-EM Ligand Modeling Challenge.

Nature methods·2024

This study introduces a novel system for pharmaceutical and biotech researchers to easily search relational databases without needing SQL knowledge. The system enhances drug discovery by providing fast, flexible data access through a unique metadata representation.

Area of Science:

  • Biotechnology
  • Pharmaceutical Sciences
  • Database Management

Background:

  • Relational databases are standard in pharma/biotech but require specialized SQL knowledge.
  • Accessing data efficiently is crucial for drug discovery projects.
  • Existing systems often lack user-friendliness for non-technical users.

Purpose of the Study:

  • To develop an intuitive system for searching and reporting data in relational databases.
  • To enable drug discovery teams to access data without SQL expertise.
  • To present the technical underpinnings of this user-friendly data retrieval system.

Main Methods:

  • Developed a hierarchical, graph-based metadata representation.
  • Implemented automated SQL-construction methods.

Related Experiment Videos

  • Designed an easy-to-use interface for data searching and reporting.

    • Main Results:

    • The system allows users to access all data without writing SQL queries.
    • The system is fast and flexible, improving data accessibility.
    • Successfully supports drug discovery project teams at Anadys.

    Conclusions:

    • The developed system significantly simplifies data retrieval from relational databases for pharmaceutical and biotech researchers.
    • This approach enhances the efficiency of drug discovery by democratizing data access.
    • The hierarchical metadata and automated SQL construction are key to the system's success.