Integrating linked data with relational data

• US 9,836,503 B2
• Filed: 01/21/2014
• Issued: 12/05/2017
• Est. Priority Date: 01/21/2014
• Status: Active Grant

• Current Assignee: Oracle International Corporation (Oracle Corporation)
• Original Assignee: Oracle International Corporation (Oracle Corporation)
• Inventors: Perry, Matthew Steven, Estrada Vargas, Ana Paula
• Primary Examiner(s): Robinson, Greta
• Application Number:
  US14/159,702
• Publication Number:
  US 20150205880A1
• Time in Patent Office: 1,414 Days
• Field of Search: 707713, 707714, 707716, 707717, 707718, 707759
• CPC Class Codes: G06F 16/24532 of parallel queries

Abstract

A method, system, and computer program product for accessing a SPARQL endpoint that is specified from within a SQL database query language statement. A method embodiment receives a SQL database query language statement that is then parsed in order to identify the locations of one or more SPARQL endpoints to be accessed. The database query language statement comprises operations and/or queries (e.g., SPARQL queries) to be performed over at least some linked data (e.g., queries over named RDF graphs) found at the one or more SPARQL endpoints. The database query language statement can also specify relational operations such as a relational database table operation, and/or a view operation, and/or other relational database functions that operate in conjunction with retrieved linked data.

Claims

1. A method comprising:

using a computing system having at least one processor to perform a process, the process comprising;

receiving a SQL database query language statement on a SQL database, wherein

the SQL database query language statement comprises one or more SQL query clauses and a table function that transforms at least one SPARQL endpoint into a row source for the SQL database to integrate local relational data with non-local RDF data retrieved from the one or more SPARQL endpoints, and

a SPARQL query string and at least one SPARQL endpoint of one or more SPARQL endpoints are embedded in the table function of SQL database query language statement;

executing the SQL database query language statement including the table function on the SQL database to transform the at least one SPARQL endpoint into a row source for the SQL database, wherein during execution of the SQL database query language statement on the SQL database,

executing the one or more SQL query clauses on the SQL database;

sending at least the SPARQL query string embedded in the SQL database query language statement to the at least one SPARQL endpoint that is embedded in the SQL database query language statement, wherein the at least one SPARQL endpoint is identified by parsing at least the table function in the SQL database query language statement that has been executed;

receiving query results from the at least one SPARQL endpoint, at least a portion of the query results corresponding to the non-local RDF data;

converting the non-local RDF data into a relational data format to generate converted RDF data; and

combining the converted RDF data with relational data from a local relational database.

2. The method of claim 1, wherein combining the converted RDF data with the relational data is performed without requiring pre-access or pre-stage RDF data from the one or more remote SPARQL endpoints.

3. The method of claim 1, wherein the SQL database query language statement including the table function is executed to transform the at least one SPARQL endpoint into the row source for the SQL database without using a gateway between the SQL database and the at least one SPARQL endpoint.

4. The method of claim 3, wherein a database engine of the SQL database converts the non-local RDF data into the relation data format and executes the one or more SQL query language strings.

5. The method of claim 1, wherein at least one of the remote SPARQL endpoints corresponds to a SPARQL endpoint URL.

6. The method of claim 1, wherein at least a portion of the SQL database query language statement comprises an HTTP request method.

7. The method of claim 1, further comprising performing a relational database operation by combining rows formed from RDF data with at least one relational database table.

8. The method of claim 1, further comprising parsing the SQL database query language statement to identify a proxy.

9. The method of claim 8, wherein the proxy is a SPARQL gateway.

10. The method of claim 9, further comprising receiving at least some RDF data from the SPARQL gateway.

11. A computer program product embodied in a non-transitory computer readable medium, the computer readable medium having stored thereon a sequence of instructions which, when executed by a processor causes the processor to execute a set of acts, the set of acts comprising:

receiving a SQL database query language statement on a SQL database, wherein

the SQL database query language statement comprises one or more SQL query clauses and a table function that transforms at least one SPARQL endpoint into a row source for the SQL database to integrate local relational data with non-local RDF data retrieved from the one or more SPARQL endpoints, and

a SPARQL query string and at least one SPARQL endpoint of one or more SPARQL endpoints are embedded in the table function of SQL database query language statement;

executing the SQL database query language statement including the table function on the SQL database to transform the at least one SPARQL endpoint into a row source for the SQL database, wherein

during execution of the SQL database query language statement on the SQL database,

executing the one or more SQL query clauses on the SQL database;

sending at least the SPARQL query string embedded in the SQL database query language statement to the at least one SPARQL endpoint that is embedded in the SQL database query language statement, wherein the at least one SPARQL endpoint is identified by parsing at least the table function in the SQL database query language statement that has been executed;

receiving query results from the at least one SPARQL endpoint, at least a portion of the query results corresponding to the non-local RDF data;

converting the non-local RDF data into a relational data format to generate converted RDF data; and

combining the converted RDF data with relational data from a local relational database.

12. The computer program product of claim 11, further comprising instructions which, when executed by the processor, further cause the processor to execute the set of acts, and the set of acts further comprising receiving at least some RDF data from the one or more remote SPARQL endpoints.

13. The computer program product of claim 12, wherein the SQL database query language statement comprises an operation to be performed over at least some of the RDF data.

14. The computer program product of claim 13, wherein at least some of the RDF data comprises at least a portion of a named RDF graph.

15. The computer program product of claim 11, wherein at least one of the remote SPARQL endpoints corresponds to a SPARQL endpoint URL.

16. The computer program product of claim 11, wherein at least a portion of the SQL database query language statement comprises an HTTP request method.

17. The computer program product of claim 11, further comprising instructions which, when executed by the processor, further cause the processor to execute the set of acts, and the set of acts further comprising performing a relational database operation by combining rows formed from RDF data with at least one relational database table.

18. The computer program product of claim 11, further comprising instructions which, when executed by the processor, further cause the processor to execute the set of acts, and the set of acts further comprising parsing the SQL database query language statement to identify a proxy.

19. A computer system comprising:

a query processor to receive a SQL database query language statement on a SQL database, wherein

the SQL database query language statement comprises one or more SQL query clauses and a table function that transforms at least one SPARQL endpoint into a row source for the SQL database to integrate local relational data with non-local RDF data retrieved from the one or more SPARQL endpoints, and

a SPARQL query string and at least one SPARQL endpoint of one or more SPARQL endpoints are embedded in the table function of SQL database query language statement;

an SQL database engine that executes the SQL database query language statement including the table function on the SQL database to transform the at least one SPARQL endpoint into a row source for the SQL database, wherein

during execution of the SQL database query language statement on the SQL database,

the SQL database engine is further configured to execute the one or more SQL query language strings on the SQL database, to send at least the SPARQL query string embedded in the SQL database query language statement to the at least one SPARQL endpoint that is embedded in the SQL database query language statement, wherein the at least one SPARQL endpoint is identified by parsing at least the table function in the SQL database query language statement that has been executed, to receive query results from the at least one SPARQL endpoint, at least a portion of the query results corresponding to the non-local RDF data, to convert the non-local RDF data into a relational data format to generate converted RDF data, and to combine the converted RDF data with relational data from a local relational database.

20. The computer system of claim 19, wherein the database engine receives at least some RDF data from the one or more SPARQL endpoints.