Semantic translation of data sets

A non-transitory computer-readable medium comprising instructions, which when executed by at least one processor, configure the at least one processor to perform operations, the operations comprising:

• accessing a semantic map between a schema of a relational database (RDB) and a resource description framework (RDF) data model, the semantic map defined according to a first semantic ontology, the first semantic ontology defining subjects and respective objects associated with the subjects;
• applying the semantic map to data loaded from the RDB to generate a first set of semantic objects;
• storing the first set of semantic objects in a staging RDF triplestore;
• and
• executing a script to transform the first set of semantic objects into a second set of semantic objects according to a second semantic ontology, the second semantic ontology defining subjects and respective objects associated with the subjects in the second ontology, wherein executing the script includes:
• accessing a transitive map in the script that identifies mappings between the objects defined in the first semantic ontology to the subjects defined in the second semantic ontology;
• generating a semantic object based on a foreign key of column in a table of the RDB;
• storing the second set of semantic objects into a production RDF triplestore;
• querying the staging RDF triplestore for a code associated with a semantic object of the first set of semantic objects, wherein the code is an object defined in the first semantic ontology;
• looking up the code in the transitive map to determine a type of object linked to the code, the type of object being defined as a subject of the second semantic ontology;
• and
• generating another semantic object according to the type of object.

A system comprising:

• at least one processor;
• a storage device comprising instructions, which when executed by the at least one processor, configure the at least one processor to perform operations, the operations comprising:
• accessing a semantic map between a schema of a relational database (RDB) and a resource description framework (RDF) data model, the semantic map defined according to a first semantic ontology, the first semantic ontology defining subjects and respective objects associated with the subjects;
• applying the semantic map to data loaded from the RDB to generate a first set of semantic objects;
• storing the first set of semantic objects in a staging RDF triplestore;
• and
• executing a script to transform the first set of semantic objects into a second set of semantic objects according to a second semantic ontology, the second semantic ontology defining subjects and respective objects associated with the subjects in the second ontology, wherein executing the script includes:
• accessing a transitive map in the script that identifies mappings between objects in the first semantic ontology to subjects in the second semantic ontology;
• generating a semantic object based on a foreign key of column in a table of the RDB;
• storing the second set of semantic objects into a production RDF triplestore;
• querying the staging RDF triplestore for a code associated with a semantic object of the first set of semantic objects, wherein the code is an object defined in the first semantic ontology:
• looking up the code in the transitive map to determine a type of object linked to the code, the type of object being defined as a subject of the second semantic ontology;
• and
• generating another semantic object according to the type of object.