IP Library Granted Patent US 9,396,283
Granted Patent B2
US 9,396,283 · App. 14/220,526 · Granted Jul 19, 2016

System for accessing a relational database using semantic queries

Inventors: Daniel Paul Miranker (Austin, TX); Juan Federico Sequeda (Austin, TX)
G06F17/30917G06F17/30557G06F17/30932
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 9,396,283
App. No.
14/220,526
Granted
Jul 19, 2016
Kind
B2
Abstract

This invention is a system for integrating relational databases into a semantic web framework utilizing a simple mapping process and the SQL query optimizer present in the SQL database engine.

Claims (20)

1. A system comprised of one or more computers for executing a digitally encoded database query received by the system, said query being expressed in a semantic query language, on the contents of a pre-existing relational database with a corresponding relational database schema, said system comprising:

a translating module comprised of logic configured to automatically translate the received database query into a second digitally encoded database query expressed in a relational query language by using a mapping data structure representing a mapping from the relational database schema to a synthetic domain model that is a putative ontology automatically created from the relational database schema, in order to create a translated relational query; and

an execution module comprised of logic configured to execute the translated relational query on the relational database.

2. The system of claim 1 further comprising an optimizing module comprised of logic configured to optimize the translated query prior to its execution by the execution module.

3. The system of claim 2 where the optimizing module is further configured to detect an at least one unsatisfiable condition.

4. The system of claim 2 where the optimizing module is further configured to execute a self-join elimination.

5. The system of claim 2 where the optimizing module is further configured to execute a self outer join elimination.

6. The system of claim 1 where the translating module is further configured to use a synthetic domain model expressed in OWL (Web Ontology Language).

7. The system of claim 1 where the translating module is further configured to use a synthetic domain model expressed in RDFS (Resource Description Framework Schema).

8. The system of claim 1 further comprising a generating module adapted to create from the mapping an RDF (Resource Description Framework) logical representation of the relational database data that conforms to the synthetic domain model.

9. The system of claim 1 further comprising a generating module adapted to create an RDF (Resource Description Framework) logical representation using a view definition associated with the relational database.

10. The system of claim 9 where the view definition is a SQL view definition.

11. The system of claim 9 where the view definition is logical.

12. The system of claim 9 where the view definition is materialized.

13. The system of claim 10 where the SQL view definition is comprised of a body nested in the translated query.

14. The system of claim 1 where the translating module is further configured to output a translated query where the arguments of the translated query are at least one columns of a RDF (Resource Description Framework) logical representation of the relational database data contents.

15. The system of claim 1 where the translating module is further configured to convert a unique resource identifier into a string comprised of a combination of a table name identifying a data table and a column label associated with the table identified by the table name.

16. The system of claim 1 where the translating module is further configured to materialize a plurality of database contents comprising the pre-existing relational database as an RDF (Resource Description Framework) representation.

17. The system of claim 1 where the translating module is further configured to determine component substitutions of an at least one component comprising the received query.

18. The system of claim 1 further comprising a second translating module comprised of logic configured to translate the result of the translated relational query into a query result that conforms to the semantic query language.

Assignments (7)
ASSIGNMENT OF ASSIGNOR'S INTEREST Recorded Oct 2, 2025
From: DATA.WORLD, INC.
To: SERVICENOW, INC.
Reel/Frame 073004/0844 →
ASSIGNMENT OF ASSIGNOR'S INTEREST Recorded Jun 10, 2019
From: CAPSENTA, INC.
To: DATA.WORLD, INC.
Reel/Frame 049419/0484 →
CORRECTIVE ASSIGNMENT TO CORRECT THE PATENT NUMBER 9396284 PREVIOUSLY RECORDED ON REEL 042222 FRAME 0316. ASSIGNOR(S) HEREBY CONFIRMS THE ASSIGNMENT. Recorded Jun 10, 2019
From: SEQUEDA, JUAN; MIRANKER, DANIEL PAUL
To: CAPSENTA, INC.
Reel/Frame 049422/0833 →
ASSIGNMENT OF ASSIGNOR'S INTEREST Recorded Jun 10, 2019
From: MIRANKER, DANIEL P.; SEQUEDA, JUAN F.
To: BOARD OF REGENTS OF THE UNIVERSITY OF TEXAS SYSTEM
Reel/Frame 049419/0298 →
ASSIGNMENT OF ASSIGNOR'S INTEREST Recorded Mar 6, 2019
From: BOARD OF REGENTS OF THE UNIVERSITY OF TEXAS SYSTEM
To: MIRANKER, DANIEL P.; SEQUEDA, JUAN F.
Reel/Frame 048515/0926 →
ASSIGNMENT OF ASSIGNOR'S INTEREST Recorded Mar 14, 2018
From: MIRANKER, DANIEL; SEQUEDA, JUAN
To: CAPSENTA, INC.
Reel/Frame 045584/0718 →
ASSIGNMENT OF ASSIGNOR'S INTEREST Recorded May 3, 2017
From: SEQUEDA, JUAN; MIRANKER, DANIEL PAUL
To: CAPSENTA, INC.
Reel/Frame 042222/0316 →
Continuity (3)
Continuation 13278907 · Oct 21, 2011
Provisional Application 61406021 · Oct 22, 2010
Related Publication 20150269223A1 · Sep 24, 2015