Skip to main content
Fig. 2 | Journal of Biomedical Semantics

Fig. 2

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

Fig. 2

For each table (“aTableName”) and each column (“aColumnName_x”) enabled for semantic queries, an annotation table is created with the naming scheme “[_][aTableName][_][aColumnName_x]”. The annotation table is linked to the source table via the unique primary key. Each row in the annotation table results in n rows in the annotation table, each holding the concept identifier (ConceptID) and a concept label (ConceptLabel) from the ontology and a level denoting the semantic distance (the super classes of the annotation concepts are also stored)

Back to article page