System for accessing a relational database using semantic queries
AssigneeCapsenta, Inc.
InventorsDaniel Paul Miranker, Juan Federico Sequeda
Life of this patent
Estimating the term…
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.
Claims48
A system comprised of one or more computers for executing a digitally encoded first query that is expressed in a query language operable on a graph representation of data, on the data contents of a pre-existing relational database with comprised of a corresponding relational database schema, said system comprising:
- a computer memory comprised of stored data encoding the first query, said stored first query being expressed in a query language operable on a graph representation of data;
- a translating module comprised of logic configured to automatically translate the stored first query into a second digitally encoded database query expressed in a relational query language by using a mapping data structure stored in a computer memory comprising said system, said data structure embodying a graph that represents a synthetic domain model representation of the relational database schema, in order to create a data object representing the second translated relational query;
- and
- a relational database system comprised of the pre-existing relational database configured by logic to execute the second translated relational query on the pre-existing relational database.
A method executed by a computer system comprised of one or more computers, for executing a digitally encoded first query that is expressed in a query language operable on a graph representation of data, on the data contents of a pre-existing relational database comprised of a corresponding relational database schema, said method comprising:
- retrieving from a data storage device data encoding the first query, said first query being expressed in a query language operable on a graph representation of data
- automatically translating the first database query into a second digitally encoded translated database query expressed in a relational query language by using a mapping data structure stored in a computer memory comprising said computer system, said data structure embodying a graph that represents a synthetic domain model representation of the relational database schema in order to create a data object representing the second translated relational query;
- and
- executing the second translated relational query on the pre-existing relational database.
Dependencies are inferred from the claim text.