Integrating terminologies into standard SQL: a new approach for research on routine data

Abstract

Background Most electronic medical records still contain large amounts of free-text data. Semantic evaluation of such data requires the data to be encoded with sufficient classifications or transformed into a knowledge-based database. Methods We present an approach that allows databases accessible via SQL (Structured Query Language) to be searched directly through semantic queries without the need for further transformations. Therefore, we developed I) an extension to SQL named Ontology-SQL (O-SQL) that allows to use semantic expressions, II) a framework that uses a standard terminology server to annotate free-text containing database tables and III) a parser that rewrites O-SQL to SQL, so that such queries can be passed to the database server. Results I) We compared several semantic queries published to date and were able to reproduce them in a reduced, highly condensed form. II) The quality of the annotation process was measured against manual annotation, and we found a sensitivity of 97.62% and a specificity of 100.00%. III) Different semantic queries were analyzed, and measured with F-scores between 0.91 and 0.98. Conclusions We showed that systematic analysis of free-text-containing medical records is possible with standard tools. The seamless connection of ontologies and standard technologies from the database field represents an important constituent of unstructured data analysis. The developed technology can be readily applied to relationally organized data and supports the increasingly important field of translational research. Electronic supplementary material The online version of this article (10.1186/s13326-019-0199-z) contains supplementary material, which is available to authorized users.

Medical Information Mining-Based Visual Artificial Intelligence Emergency Nursing Management System

“…The MVC design pattern stipulates the responsibilities of the components and reduces the coupling between the components [ 16 ]. The use of the MyBatis framework brings complete data encapsulation and optimizes the data processing process [ 17 ]. The Spring MVC framework includes a perfect client request processing system, which is composed of components such as HandlerMapping and ViewReSolver.…”

Crowd-Sourced Chemistry: Considerations for Building a Standardized Database to Improve Omic Analyses

“…For large data sets, SQL Server can be used. It works well with relational data, especially if individual records have many attributes associated with them . SQL data sets can be transformed into the XML data format which is amenable to many informatic solutions and coding languages.…”

Knowledge-based best of breed approach for automated detection of clinical events based on German free text digital hospital discharge letters

“…[6,7,13] [10] While due to lack of appropriate resources, commonly to begin with refinement or de novo generation of a terminology have been necessary, we could recently demonstrate that analysis of free-text-containing medical records is possible with standard tools and terminologies. [19]…”

“…This also applies to rarely used active agents. Therefore, we conceived an approach, which can be implemented with little or even no training [19]…”

“…[27, 28] [23, 24, 29] It is important to note that osteoporosis and osteoporosis-related fractures are associated with high morbidity and mortality, as well as high health care costs. [19][20]…”