INTEGRATING LINKED DATA WITH RELATIONAL DATA

• US 20150205880A1
• Filed: 01/21/2014
• Published: 07/23/2015
• 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
• Granted Patent: US 9,836,503 B2
• Time in Patent Office: Days
• US Class Current: 1/1
• 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;

parsing the SQL database query language statement to identify one or more remote SPARQL endpoints; and

sending at least a portion of the SQL database query language statement to at least one of the one or more remote SPARQL endpoints.

2. The method of claim 1, further comprising receiving at least some RDF data from the one or more remote SPARQL endpoints.

3. The method of claim 2, wherein the SQL database query language statement comprises an operation to be performed over at least some of the RDF data.

4. The method of claim 3, wherein at least some of the RDF data comprises at least a portion of a named RDF graph.

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 process, the process comprising:

receiving a SQL database query language statement;

parsing the SQL database query language statement to identify one or more remote SPARQL endpoints; and

sending at least a portion of the SQL database query language statement to at least one of the one or more remote SPARQL endpoints.

12. The computer program product of claim 11, further comprising instructions for 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 for 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 for 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 comprising identification of one or more remote SPARQL endpoints; and

a database engine to send at least a portion of the SQL database query language statement to at least one of the identified one or more remote SPARQL endpoints.

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