System for accessing a relational database using semantic queries
The invention is a system for integrating data sets organized in one organization type with data sets organized in a second organization type so that data queries submitted to be processed in the manner of the first organization type can be translated into queries usable by the data set in the second data organization type and the results returned to satisfy the first query.
1. A system comprising:
one or more computer systems including a memory including executable instructions, and a processor that is configured, responsive to executing the instructions, to:
execute a digitally encoded first query expressed in a first query language operable on a first type of data organization to form a first query translatable to query a data set in a second type of data organization comprised of a second type of data organization schema encoded in a schema data file;
access a mapping data structure embodying a synthetic domain model representation of the second type of data organization configured to create a data object representing the second translated query;
automatically translate the first query into a second digitally encoded translated query expressed in a second query language compatible with the second type of data organization to form a second query;
execute the second query on the data set of the second type of data organization to derive query result data; and
re-format the query result data to conform with requirements of the first query language.
2. The system of claim 1 wherein the processor is further configured to:
access the synthesized domain model as a mapping of a relational schema to a semantic schema.
3. The system of claim 1 wherein the processor is further configured to:
automatically translate a semantically structured data query to form a relationally structured data query.
4. The system of claim 3 wherein the processor is further configured to:
automatically translate a SPARQL-based query to form a SQL-based query.
5. The system of claim 1 wherein the processor is further configured to:
embed a create view command in one or more of the first query and the second query.
6. The system of claim 1 wherein the processor is further configured to:
implement query engine logic to automatically perform one or more query rewrites from a triple-based evaluation to a relational evaluation.
7. The system of claim 1 wherein the processor is further configured to:
automatically translate a relationally structured data query to form a semantically structured data query.
8. A method comprising:
executing at a processor of one or more computer systems a digitally encoded first query expressed in a first query language operable on a first type of data organization to form a first query translatable to query a data set in a second type of data organization comprised of a second type of data organization schema encoded in a schema data file;
accessing a mapping data structure stored in a computer memory associated with the one or more computer systems, the mapping data structure embodying a synthetic domain model representation of the second type of data organization configured to create a data object representing the second translated query;
automatically translating the first query into a second digitally encoded translated query expressed in a second query language compatible with the second type of data organization to form a second query;
executing the second query on the data set of the second type of data organization to derive query result data; and
re-formatting the query result data to conform with requirements of the first query language.
9. The method of claim 8 wherein accessing the mapping data structure comprises:
accessing the synthesized domain model as a mapping of a relational schema to a semantic schema.
10. The method of claim 8 wherein automatically translating the first query to form the second query comprises:
automatically translating a semantically structured data query to form a relationally structured data query.
11. The method of claim 10 wherein automatically translating the semantically structured data query to form the relationally structured data query comprises:
automatically translating a SPARQL-based query to form a SQL-based query.
12. The method of claim 8 further comprising:
embedding a create view command in one or more of the first query and the second query.
13. The method of claim 8 wherein automatically translating the first query to form the second query comprises:
automatically translating a relationally structured data query to form a semantically structured data query.
14. The method of claim 13 wherein automatically translating the relationally structured data query to form the semantically structured data query comprises:
automatically translating a SQL-based query to form a SPARQL-based query.
15. A computer readable storage device comprised of data representing computer instructions configured to cause a processor to initiate a computer-implemented method comprising:
executing at a processor of one or more computer systems a digitally encoded first query expressed in a first query language operable on a first type of data organization to form a first query translatable to query a data set in a second type of data organization comprised of a second type of data organization schema encoded in a schema data file;
accessing a mapping data structure stored in a computer memory associated with the one or more computer systems, the mapping data structure embodying a synthetic domain model representation of the second type of data organization configured to create a data object representing the second translated query;
automatically translating the first query into a second digitally encoded translated query expressed in a second query language compatible with the second type of data organization to form a second query;
executing the second query on the data set of the second type of data organization to derive query result data; and
re-formatting the query result data to conform with requirements of the first query language.
16. The computer-implemented method of claim 15 wherein accessing the mapping data structure comprises:
accessing the synthesized domain model as a mapping of a relational schema to a semantic schema.
17. The computer-implemented method of claim 15 wherein automatically translating the first query to form the second query comprises:
automatically translating a semantically structured data query to form a relationally structured data query.
18. The computer-implemented method of claim 17 wherein automatically translating the semantically structured data query to form the relationally structured data query comprises:
automatically translating a SPARQL-based query to form a SQL-based query.
19. The computer-implemented method of claim 15 further comprising:
embedding a create view command in one or more of the first query and the second query.
20. The computer-implemented method of claim 15 wherein automatically translating the first query to form the second query comprises:
automatically translating a relationally structured data query to form a semantically structured data query.