×

Automatically generating a semantic mapping for a relational database

  • US 10,445,300 B2
  • Filed: 06/23/2015
  • Issued: 10/15/2019
  • Est. Priority Date: 05/30/2014
  • Status: Active Grant
First Claim
Patent Images

1. A method for automatically generating a semantic mapping for a relational database (RDB), the method comprising:

  • obtaining, via a processor, a first semantic mapping from a first RDB to an ontology of linked data;

    obtaining, via the processor, a schema mapping from the first RDB to a second RDB; and

    generating, via the processor, a second semantic mapping from the second RDB to the ontology of the linked data based on the first semantic mapping and the schema mapping, the generating comprising;

    obtaining, via the processor, an internal model representation regarding the first semantic mapping based on the first semantic mapping, wherein the internal model representation is a graph, wherein the first semantic mapping is composed of a resource description framework (RDF) triple, wherein the RDF triple comprises a subject, a predicative, and an object, wherein the obtaining the internal model representation regarding the first semantic mapping based on the first semantic mapping comprises expressing the subject and object of the RDF triple as nodes on the graph and expressing the predicative of the RDF triple as an edge on the graph, and wherein the object is expressed as a blank node in the graph responsive to the object being literal information;

    obtaining an internal model representation regarding the schema mapping based on the schema mapping;

    synthesizing the internal model representation regarding the first semantic mapping and the internal model representation regarding the schema mapping to obtain a synthesized internal model representation of mappings, wherein the first semantic mapping and the schema mapping are synthesized by graph traversal; and

    compiling the synthesized internal model representation of the mappings to obtain the second semantic mapping;

    wherein the first semantic mapping for the RDB causes the processor to access data in the first and the second RDB with enhanced efficiency and the compiling the synthesized internal model representation of the mappings to obtain the second semantic mapping comprises;

    performing graph traversal on the synthesized graphic structure representation of mappings to obtain the second semantic mapping.

View all claims
  • 1 Assignment
Timeline View
Assignment View
    ×
    ×