Abstract:Objective: SNOMED CT is the international lingua franca of terminologies for human health. Based in Description Logics (DL), the terminology enables data queries that incorporate inferences between data elements, as well as, those relationships that are explicitly stated. However, the ontologic and polyhierarchical nature of the SNOMED CT concept model make it difficult to implement in its entirety within electronic health record systems that largely employ object oriented or relational database architectures. The result is a reduction of data richness, limitations of query capability and increased systems overhead. The hypothesis of this research was that a graph database (graph DB) architecture using SNOMED CT as the basis for the data model and subsequently modeling patient data upon the semantic core of SNOMED CT could exploit the full value of the terminology to enrich and support advanced data querying capability of patient data sets. Methods: The hypothesis was tested by instantiating a graph DB with the fully classified SNOMED CT concept model. The graph DB instance was tested for integrity by calculating the transitive closure table for the SNOMED CT hierarchy and comparing the results with transitive closure tables created using current, validated methods. The graph DB was then populated with 461,171 anonymized patient record fragments and over 2.1 million associated SNOMED CT clinical findings. Queries, including concept negation and disjunction, were then run against the graph database and an enterprise Oracle relational database (RDBMS) of the same patient data sets. The graph DB was then populated with laboratory data encoded using LOINC, as well as, medication data encoded with RxNorm and complex queries performed using LOINC, RxNorm and SNOMED CT to identify uniquely described patient populations. Results: A graph database instance was successfully created for two international releases of SNOMED CT and two US SNOMED CT editions. Transitive closure tables and descriptive statistics generated using the graph database were identical to those using validated methods. Patient queries produced identical patient count results to the Oracle RDBMS with comparable times. Database queries involving defining attributes of SNOMED CT concepts were possible with the graph DB. The same queries could not be directly performed with the Oracle RDBMS representation of the patient data and required the creation and use of external terminology services. Further, queries of undefined depth were successful in identifying unknown relationships between patient cohorts. Conclusion: The results of this study supported the hypothesis that a patient database built upon and around the semantic model of SNOMED CT was possible. The model supported queries that leveraged all aspects of the SNOMED CT logical model to produce clinically relevant query results. Logical disjunction and negation queries were possible using the data model, as well as, queries that extended beyond the structural IS_A hierarchy of SNOMED CT to include queries that employed defining attribute-values of SNOMED CT concepts as search parameters. As medical terminologies, such as SNOMED CT, continue to expand, they will become more complex and model consistency will be more difficult to assure. Simultaneously, consumers of data will increasingly demand improvements to query functionality to accommodate additional granularity of clinical concepts without sacrificing speed. This new line of research provides an alternative approach to instantiating and querying patient data represented using advanced computable clinical terminologies.

Interactions between visual and motor areas during the recognition of plausible actions as revealed by magnetoencephalography

Ontology-Based Medical Data Integration for Regional Healthcare Application

Offset voltage control scheme for modular multilevel converter operated in nearest level control

Extraperitoneal pelvioscopy: a new aid in staging of lower urinary tract tumors. A preliminary report.

SemOntoMap: A Hybrid Approach for Semantic Annotation of Clinical Texts

Semantic SQL -- Combining and optimizing semantic predicates in SQL

A Rule-Based Information Extraction System for Human-Readable Semi-Structured Scientific Documents

Extending the TOP Framework with an Ontology-Based Text Search Component

An alternative database approach for management of SNOMED CT and improved patient data queries

Converting Semi-structured Clinical Medical Records into Information and Knowledge

Evaluation of Semantic Web Technologies for Storing Computable Definitions of Electronic Health Records Phenotyping Algorithms

Comparison of DNA ploidy status and DNA ploidy-related parameters in malignant melanoma tissue microarrays and full sections.

A Web-Based Data-Querying Tool Based on Ontology-Driven Methodology and Flowchart-Based Model

Aggregation and Visualization of Laboratory Data by Using Ontological Tools Based on LOINC and SNOMED CT

Personalized Retrieval in the Medical Domain: A NoSQL Solution Based on Ontology Building

Semantic-Enhanced Query Expansion System for Retrieving Medical Image Notes

Rheumatoid arthritis, malignancy, and paraproteins.

Collaborative Semantic Annotation Tooling (CoAT) to Improve Efficiency and Plug-and-Play Semantic Interoperability in the Secondary Use of Medical Data: Concept, Implementation, and First Cross-Institutional Experiences

Toward Semantic Interoperability of Electronic Health Records

Ontologizing health systems data at scale: making translational discovery a reality

Terminology Enhanced EHR: Integration of Archetypes and Terminology, an Implementation Experience