Data modeling translation system

• US 10,489,419 B1
• Filed: 03/28/2017
• Issued: 11/26/2019
• Est. Priority Date: 03/28/2016
• Status: Active Grant

• Current Assignee: Wells Fargo Bank NA (Wells Fargo & Company)
• Original Assignee: Wells Fargo Bank NA (Wells Fargo & Company)
• Inventors: Newman, David, Kabiraj, Devdeep, Quigley, Gerald, Day, Caroline Janice
• Primary Examiner(s): Chbouki, Tarek
• Application Number:
  US15/471,728
• Time in Patent Office: 973 Days
• CPC Class Codes: G06F 16/2452 Query translation
• CPC Class Codes: G06F 16/258 Data format conversion from or to a database
• CPC Class Codes: G06F 16/284 Relational databases
• CPC Class Codes: G06F 16/3344 using natural language analysis
• CPC Class Codes: G06F 16/367 Ontology
• CPC Class Codes: G06F 16/86 Mapping to a database

Abstract

A method may include receiving a semantic query, wherein the semantic query is formatted using a first ontology; retrieving a transitive mapping between the first ontology and a second ontology; translating a first element of the semantic query from the format of the first ontology to a second element of the second ontology in accordance with the transitive map; parsing a relational database to Resource Description Format (R2RML) mapping to determine a set of database tables that include the second element; directing an execution of the semantic query to the set of database tables in accordance with the R2RML mapping; and storing the results of the executed query in a tripe format, the stored results formatted using the first ontology.

Claims

1. A method comprising:

receiving a semantic query, wherein the semantic query is formatted using a first ontology;

retrieving a transitive mapping between the first ontology and a second ontology;

translating a first element of the semantic query from the format of the first ontology to a second element of the second ontology in accordance with the transitive map;

parsing a relational database to Resource Description Format (R2RML) mapping to determine a set of database tables that include the second element, the R2RML mapping associated with the second ontology;

directing an execution of the semantic query to the set of database tables in accordance with the R2RML mapping to retrieve data associated with the second element; and

storing the results of the executed query in a triple format, the stored results formatted using the first ontology.

2. The method of claim 1, wherein the first ontology is associated with a first entity and the second ontology is associated with a second entity.

3. The method of claim 1, wherein translating a first element of the semantic query from the format of the first ontology to a second element of the second ontology in accordance with the transitive map comprises:

parsing the transitive map to find the first element, and wherein the transitive map includes the second element as a corresponding term to the first element.

4. The method of claim 1, further comprising:

parsing the query to determine the first element, wherein the first element is a property of an object of the query.

5. The method of claim 1, further comprising:

presenting a user interface that includes;

a plurality of terms from the first ontology;

a plurality of terms from the second ontology; and

a suggested pairing between a term of the plurality of terms from the first ontology and a term of the plurality of terms from the second ontology.

6. The method of claim 5;

wherein the suggested pairing is based on the term of the plurality of terms from the first ontology and the term of the plurality of terms from the second ontology being the same.

7. The method of claim 5, further comprising:

receiving, via the user interface, confirmation of the suggested pairing.

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

receiving a semantic query, wherein the semantic query is formatted using a first ontology;

retrieving a transitive mapping between the first ontology and a second ontology;

translating a first element of the semantic query from the format of the first ontology to a second element of the second ontology in accordance with the transitive map;

parsing a relational database to Resource Description Format (R2RML) mapping to determine a set of database tables that include the second element, the R2RML mapping associated with the second ontology;

directing an execution of the semantic query to the set of database tables in accordance with the R2RML mapping to retrieve data associated with the second element; and

storing the results of the executed query in a triple format, the stored results formatted using the first ontology.

9. The non-transitory computer readable medium of claim 8, wherein the first ontology is associated with a first entity and the second ontology is associated with a second entity.

10. The non-transitory computer readable medium of claim 8, wherein the operation of translating a first element of the semantic query from the format of the first ontology to a second element of the second ontology in accordance with the transitive map comprises:

parsing the transitive map to find the first element, and wherein the transitive map includes the second element as a corresponding term to the first element.

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

parsing the query to determine the first element, wherein the first element is a property of an object of the query.

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

presenting a user interface that includes;

a plurality of terms from the first ontology;

a plurality of terms from the second ontology; and

a suggested pairing between a term of the plurality of terms from the first ontology and a term of the plurality of terms from the second ontology.

13. The non-transitory computer readable medium of claim 12, wherein the suggested pairing is based on the term of the plurality of terms from the first ontology and the term of the plurality of terms from the second ontology being the same.

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

receiving, via the user interface, confirmation of the suggested pairing.

15. A system comprising:

at least one processor;

a storage device comprising instructions, which when executed by the at least one processor, configure the processor to perform operations comprising;

receiving a semantic query, wherein the semantic query is formatted using a first ontology;

retrieving a transitive mapping between the first ontology and a second ontology;

translating a first element of the semantic query from the format of the first ontology to a second element of the second ontology in accordance with the transitive map;

parsing a relational database to Resource Description Format (R2RML) mapping to determine a set of database tables that include the second element, the R2RML mapping associated with the second ontology;

directing an execution of the semantic query to the set of database tables in accordance with the R2RML mapping to retrieve data associated with the second element; and

storing the results of the executed query in a triple format, the stored results formatted using the first ontology.

16. The system of claim 15, wherein the first ontology is associated with a first entity and the second ontology is associated with a second entity.

17. The system of claim 15, wherein the operation of translating a first element of the semantic query from the format of the first ontology to a second element of the second ontology in accordance with the transitive map comprises:

parsing the transitive map to find the first element, and wherein the transitive map includes the second element as a corresponding term to the first element.

18. The system of claim 15, the operations further comprising:

parsing the query to determine the first element, wherein the first element is a property of an object of the query.

19. The system of claim 15, the operations further comprising:

presenting a user interface that includes;

a plurality of terms from the first ontology;

a plurality of terms from the second ontology; and

a suggested pairing between a term of the plurality of terms from the first ontology and a term of the plurality of terms from the second ontology.

20. The system of claim 19, wherein the suggested pairing is based on the term of the plurality of terms from the first ontology and the term of the plurality of terms from the second ontology being the same.