IP Library › Granted Patent US 11,238,084
Granted Patent B1
US 11,238,084 · App. 15/645,574 · Granted Feb 1, 2022

Semantic translation of data sets

Inventors: David Newman (Walnut Creek, CA); Omar B. Khan (Richmond, VA)
Assignee: Wells Fargo Bank, N.A.
G06F16/367G06F16/284G06F16/334
View Patent ↗
Loading inventors, assignments & file history…
Monitor This Case
Get email alerts when status or documents change.
Order Certified Copies
Most orders are placed with the USPTO same day — all within 24 business hours.
Order via The Patent Place →
Pre-filled with this patent's details
Quick Facts
Patent No.
US 11,238,084
App. No.
15/645,574
Granted
Feb 1, 2022
Kind
B1
Abstract

A method may include 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; 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; executing a script to transform the first set of semantic objects into a second set of semantic objects according to a second semantic ontology; and storing the second set of semantic objects into a production RDF triplestore.

Claims (60)

1. A method 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.

2. The method of claim 1 , wherein the code is stored as the object of the semantic object.

3. The method of claim 1 , further comprising:

receiving a query for the production RDF triplestore;

retrieving a set of result semantic objects from the production RDF triplestore based on the query; and

presenting the set of result semantic objects in a graph format, wherein the graph format is based on the second semantic ontology.

4. The method of claim 3 , wherein presenting the set of result semantic objects in a graph format comprises:

determining that a first semantic object of the set of result semantic objects has a likelihood above a certain threshold of being the same as a second semantic object of the set of result semantic objects; and

presenting an identification of the first and second semantic objects as being likely the same semantic object.

5. The method of claim 1 , further comprising:

traversing the production RDF triplestore to find duplicate semantic objects; and

removing one of duplicate semantic objects.

6. The method of claim 1 , wherein the script is formatted according to SPARQL Protocol and RDF Query Language.

7. 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.

8. The non-transitory computer-readable medium of claim 7 , wherein the code is stored as the object of the semantic object.

9. The non-transitory computer-readable medium of claim 7 , the operations further comprising:

receiving a query for the production RDF triplestore;

retrieving a set of result semantic objects from the production RDF triplestore based on the query; and

presenting the set of result semantic objects in a graph format, wherein the graph format is based on the second semantic ontology.

10. The non-transitory computer-readable medium of claim 9 , wherein the operation of presenting the set of result semantic objects in a graph format comprises:

determining that a first semantic object of the set of result semantic objects has a likelihood above a certain threshold of being the same as a second semantic object of the set of result semantic objects; and

presenting an identification of the first and second semantic objects as being likely the same semantic object.

11. The non-transitory computer-readable medium of claim 7 , the operations further comprising:

traversing the production RDF triplestore to find duplicate semantic objects; and

removing one of duplicate semantic objects.

12. The non-transitory computer-readable medium of claim 7 , wherein the script is formatted according to SPARQL Protocol and RDF Query Language.

13. 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.

14. The system of claim 13 , wherein the code is stored as the object of the semantic object.

Assignments (1)
ASSIGNMENT OF ASSIGNOR'S INTEREST Recorded Aug 7, 2017
From: NEWMAN, DAVID; KHAN, OMAR B.
To: WELLS FARGO BANK, N.A.
Reel/Frame 043219/0833 →
Continuity (1)
Provisional Application 62441079 · Dec 30, 2016
Cited By (4)
US 12,353,351 US 12,380,151 US 12,386,853 US 12,670,204