title: Representing and querying conceptual graphs with relational database management systems is possible.
abstract: This is an experimental study on the feasibility of maintaining medical concept dictionaries in production grade relational database management systems (RDBMS.) In the past, RDBMS did not support transitive relational structures and had therefore been unsuitable for managing knowledge bases. The revised SQL-99 standard, however, may change this. In this paper we show that modern RDBMS that support recursive queries are capable of querying transitive relationships in a generic data model. We show a simple but efficient indexed representation of transitive closure. We could confirm that even challenging combined transitive relationships can be queried in SQL.
authors.affiliation: Regenstrief Institute, Indianapolis, IN, USA.
authors.forename: G
authors.initials: G
authors.lastname: Schadow
authors.forename: M R
authors.initials: MR
authors.lastname: Barnes
authors.forename: C J
authors.initials: CJ
authors.lastname: McDonald
mesh_terms: D001185:Artificial Intelligence; D003628:Database Management Systems; D005240:Feasibility Studies; D016347:Medical Records Systems, Computerized / Q000458:organization & administration*; D011381:Programming Languages; D012984:Software; D018875:Vocabulary, Controlled