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

Representing and querying conceptual graphs with relational database management systems is possible.

G Schadow1, M R Barnes, C J McDonald

  • 1Regenstrief Institute, Indianapolis, IN, USA.

Proceedings. AMIA Symposium
|February 5, 2002
PubMed
Summary

Modern relational database systems can now manage complex medical concept dictionaries. This study confirms that SQL-99 standard databases support querying transitive relationships, overcoming previous limitations for knowledge base management.

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

Bowel and bladder outcomes in patients with anorectal malformations and sacral agenesis: a retrospective cohort study.

Pediatric surgery international·2026
Same author

Defining trajectories of response in patients with psoriasis treated with biologic therapies.

The British journal of dermatology·2021
Same author

Bioinformatics for dermatology: why we should learn about code.

The British journal of dermatology·2017
Same author

Health Informatics Standards: A View From Mid-America.

Yearbook of medical informatics·2016
Same author

Genome-wide association analysis of copy number variation in recurrent depressive disorder.

Molecular psychiatry·2011
Same author

Chronic exertional compartment syndrome of the forearm: a case series of 12 patients treated with fasciotomy.

The Journal of hand surgery, European volume·2011

Area of Science:

  • Computer Science
  • Medical Informatics

Background:

  • Relational database management systems (RDBMS) traditionally lacked support for transitive relational structures, hindering their use for complex knowledge bases.
  • The evolution of database standards, particularly SQL-99, introduces capabilities that may resolve these limitations.

Purpose of the Study:

  • To investigate the feasibility of maintaining medical concept dictionaries within production-grade RDBMS.
  • To evaluate the capability of modern RDBMS supporting recursive queries to handle transitive relationships in a generic data model.

Main Methods:

  • Experimental validation of RDBMS performance with medical concept dictionaries.
  • Development and testing of an efficient indexed representation for transitive closure.
  • Querying of complex, combined transitive relationships using SQL.

Related Experiment Videos

Main Results:

  • Modern RDBMS supporting recursive queries can effectively query transitive relationships within a generic data model.
  • A novel, efficient indexed representation for transitive closure was demonstrated.
  • Successful querying of challenging combined transitive relationships in SQL was confirmed.

Conclusions:

  • Production-grade RDBMS are now feasible for managing medical concept dictionaries.
  • Recursive query capabilities in modern SQL standards enable efficient handling of complex, transitive knowledge structures.