Automatically generating a semantic mapping for a relational database

Patent metadata

Field	Value
Publication number	US-2015347621-A1
Application number	US-201514718174-A
Country	US
Kind code	A1
Filing date	May 21, 2015
Priority date	May 30, 2014
Publication date	Dec 3, 2015
Grant date	—

Abstract

A method for automatically generating a semantic mapping for a relational database RDB includes obtaining a first semantic mapping from a first RDB to an ontology of linked data; obtaining a schema mapping from the first RDB to a second RDB; and generating 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.

First claim

1 .- 10 . (canceled)

11 . A system for automatically generating a semantic mapping for a relational database RDB, comprising:
a semantic mapping obtaining module configured to obtain a first semantic mapping from a first RDB to an ontology of linked data; a schema mapping obtaining module configured to obtain a schema mapping from the first RDB to a second RDB; and a semantic mapping generating module configured to generate 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.

12 . The system of claim 11 , wherein the semantic mapping generating module comprises:
a semantic mapping processing module configured to obtain an internal model representation regarding the first semantic mapping based on the first semantic mapping; a schema mapping processing module configured to obtain an internal model representation regarding the schema mapping based on the schema mapping; a mapping synthesizing module configured to synthesize 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; a mapping compiling module configured to compile the synthesized internal model representation of the mappings to obtain the second semantic mapping.

13 . The system of claim 12 , wherein the internal model representation is a graphic structure-based representation.

14 . The system of claim 13 , wherein the first semantic mapping is composed of a resource description framework RDF triple, wherein the RDF triple comprises a subject, a predictive, and an object, wherein the semantic mapping processing module is configured to:
express the subject and object of the RDF triple as nodes on the graph, and express the predictive of the RDF triple as an edge on the graph, thereby obtaining a graphic structure representation regarding the first semantic mapping.

15 . The system of claim 14 , wherein the semantic mapping processing module is further configured to express the object of the RDF triple as a blank node on the graph responsive to the object being literal information, wherein the blank node is directed to a RDB node contained in the literal information.

16 . The system of claim 13 , wherein the schema mapping processing module is configured to:
express a schema mapping name in the schema mapping as a node on the graph; express a table-name.column-name of the first RDB and a table-name.column-name of the second RDB as nodes on the graph; in response to the table-name.column-name of the first RDB and the table-name.column-name of the second RDB in the schema mapping sharing a same variable symbol, direct a node corresponding to the schema mapping name to an association node through an edge, wherein the association node is directed to nodes corresponding to the table-name.column-name of the first RDB and the table-name.column-name of the second RDB, respectively.

17 . The system of claim 13 , wherein the mapping synthesizing module is configured to: perform graph traversal on the internal model representation regarding the first semantic mapping and the graphic structure representation regarding the schema mapping, to obtain a synthesized internal model representation of mappings.

18 . The system of claim 13 , wherein the mapping compiling module is configured to perform graph traversal on the synthesized graphic structure representation of mappings to obtain the second semantic mapping.

19 . The system of claim 12 , wherein the internal model representation is a logic-based representation.

20 . The system of claim 11 , wherein the semantic mapping is a D2RQ mapping.

Assignees

• IBM

Inventors

• Hu Gang
• Mei Jing
• Shen wei jia
• Sun Wen B
• Xie Guo Tong

Classifications

• G06F16/284

  Relational databases · CPC title

• G06F12/00 Primary

  Accessing, addressing or allocating within memory systems or architectures (digital input from, or digital output to record carriers, e.g. to disk storage units, G06F3/06) · CPC title

• G06F16/211 Primary

  Schema design and management · CPC title

• G06F16/86 Primary

  Mapping to a database · CPC title

• G06F16/9024

  Graphs; Linked lists (G06F16/9027 takes precedence) · CPC title