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.
Full text
PDF
Selected References
These references are in PubMed. This may not be the complete list of references from this article.
- Huff S. M., Rocha R. A., McDonald C. J., De Moor G. J., Fiers T., Bidgood W. D., Jr, Forrey A. W., Francis W. G., Tracy W. R., Leavelle D. Development of the Logical Observation Identifier Names and Codes (LOINC) vocabulary. J Am Med Inform Assoc. 1998 May-Jun;5(3):276–292. doi: 10.1136/jamia.1998.0050276. [DOI] [PMC free article] [PubMed] [Google Scholar]
- McDonald C. J., Overhage J. M., Tierney W. M., Dexter P. R., Martin D. K., Suico J. G., Zafar A., Schadow G., Blevins L., Glazener T. The Regenstrief Medical Record System: a quarter century experience. Int J Med Inform. 1999 Jun;54(3):225–253. doi: 10.1016/s1386-5056(99)00009-x. [DOI] [PubMed] [Google Scholar]
- Musen M. A., Gennari J. H., Eriksson H., Tu S. W., Puerta A. R. PROTEGE-II: computer support for development of intelligent systems from libraries of components. Medinfo. 1995;8(Pt 1):766–770. [PubMed] [Google Scholar]
- Rector A. L., Bechhofer S., Goble C. A., Horrocks I., Nowlan W. A., Solomon W. D. The GRAIL concept modelling language for medical terminology. Artif Intell Med. 1997 Feb;9(2):139–171. doi: 10.1016/s0933-3657(96)00369-7. [DOI] [PubMed] [Google Scholar]
- Russler D. C., Schadow G., Mead C., Snyder T., Quade L. M., McDonald C. J. Influences of the Unified Service Action Model on the HL7 Reference Information Model. Proc AMIA Symp. 1999:930–934. [PMC free article] [PubMed] [Google Scholar]
- Schadow G., Russler D. C., McDonald C. J. Conceptual integration of guidelines and workflow into the electronic health record. Stud Health Technol Inform. 2000;77:807–811. [PubMed] [Google Scholar]
- Schulz S., Romacker M., Hahn U. Knowledge engineering the UMLS. Stud Health Technol Inform. 2000;77:701–705. [PubMed] [Google Scholar]