Integrating applications with an RDF repository through a SPARQL gateway

• US 8,949,225 B2
• Filed: 05/22/2012
• Issued: 02/03/2015
• Est. Priority Date: 05/22/2012
• Status: Active Grant

• Current Assignee: Oracle International Corporation (Oracle Corporation)
• Original Assignee: Oracle International Corporation (Oracle Corporation)
• Inventors: Wu, Zhe, Rieb, Karl
• Primary Examiner(s): Ly, Anh
• Application Number:
  US13/477,362
• Publication Number:
  US 20130318070A1
• Time in Patent Office: 987 Days
• Field of Search: 707/803, 707/760, 707/792, 707/761, 707/763, 707/740, 707/722, 707/811, 707/E17.014, 707/E17.055, 707/E1.046, 707/E17.044, 707/999.003, 707/798, 707/721, 707/759, 707/725, 707/808, 707/E17.002, 709/203, 709/217, 709/218, 709/219, 715/234, 715/235, 715/236, 715/249, 717/137, 717/143, 710/244
• US Class Current: 707/722
• CPC Class Codes: G06F 16/00 Information retrieval; Database structures therefor; File system structures therefor
• CPC Class Codes: G06F 16/2452 Query translation
• CPC Class Codes: G06F 16/256 in federated or virtual databases
• CPC Class Codes: G06F 16/258 Data format conversion from or to a database
• CPC Class Codes: G06F 16/284 Relational databases

Abstract

A method, system, and computer program product for of processing database queries using the resource description framework (RDF) language through a gateway service. The method commences by receiving a database query (e.g., an SQL query) from an application, the query being in a first query language format, then converting the query into a SPARQL query format and submitting the converted query to a SPARQL endpoint. The SPARQL endpoint processes the SPARQL query (e.g., by accessing an RDF repository), and sends back the query results. A gateway service (e.g., a SPARQL gateway) then receives the SPARQL query results from the SPARQL endpoint and transforms the SPARQL query results into a format corresponding to the first query language format so the initiating application can process it natively. Several performance features are disclosed, including a method for achieving a quality of service level by concurrently submitting multiple SPARQL queries with different LIMIT clauses.

Claims

1. A computer implemented method for accessing an RDF (resource description framework) repository through a SPARQL (SPARQL Protocol and RDF Query Language) gateway, the method comprising:

receiving, by the SPARQL gateway running on a computer having a processor, a database query, the database query received in a first query language format;

converting the database query into a SPARQL query format;

submitting the converted query to a SPARQL endpoint;

receiving, by the SPARQL gateway, SPARQL query results from the SPARQL endpoint; and

transforming the SPARQL query results into a format corresponding to the first query language format, wherein the format is not an XML format.

2. The method of claim 1, wherein the first query language format is SQL.

3. The method of claim 1, further comprising sending the transformed SPARQL query results to at least one of, a database engine, or a database application.

4. The method of claim 1, wherein submitting the converted query to a SPARQL endpoint comprises submitting a first converted query with a first LIMIT clause and a second converted query with a second LIMIT clause.

5. The method of claim 1, wherein transforming the SPARQL query results uses an XSLT processor.

6. The method of claim 1, wherein converting the database query into a SPARQL query format comprises determining that the database query can be converted into more than one equivalent SPARQL query, and selecting the fastest one from among the more than one equivalent SPARQL queries.

7. The method of claim 1, wherein converting the database query into a SPARQL query format comprises converting an aspect of an SQL query into a corresponding RDF construct.

8. A computer system for accessing an RDF repository through a SPARQL gateway, comprising:

a computer processor to execute a set of program code instructions; and

a memory to hold the program code instructions, in which the program code instructions comprises program code to perform,

receiving, by a SPARQL gateway, a database query, the database query received in a first query language format;

converting the database query into a SPARQL query format;

submitting the converted query to a SPARQL endpoint;

receiving by the SPARQL gateway, SPARQL query results from the SPARQL endpoint; and

transforming the SPARQL query results into a format corresponding to the first query language format, wherein the format is not an XML format.

9. The computer system of claim 8, wherein the first query language format is SQL.

10. The computer system of claim 8, further comprising sending the transformed SPARQL query results to at least one of, a database engine, or a database application.

11. The computer system of claim 8, wherein submitting the converted query to a SPARQL endpoint comprises submitting a first converted query with a first LIMIT clause and a second converted query with a second LIMIT clause.

12. The computer system of claim 8, wherein transforming the SPARQL query results uses an XSLT processor.

13. The computer system of claim 8, wherein converting the database query into a SPARQL query format comprises determining that the database query can be converted into more than one equivalent SPARQL query, and selecting the fastest one from among the more than one equivalent SPARQL queries.

14. The computer system of claim 8, wherein converting the database query into a SPARQL query format comprises converting an aspect of an SQL query into a corresponding RDF construct.

15. 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 to access an RDF repository through a SPARQL gateway, the process comprising:

receiving, by the SPARQL gateway, a database query, the database query received in a first query language format;

converting the database query into a SPARQL query format;

submitting the converted query to a SPARQL endpoint;

receiving by the SPARQL gateway, SPARQL query results from the SPARQL endpoint; and

transforming the SPARQL query results into a format corresponding to the first query language format, wherein the format is not an XML format.

16. The computer program product of claim 15, wherein the first query language format is SQL.

17. The computer program product of claim 15, further comprising sending the transformed SPARQL query results to at least one of, a database engine, or a database application.

18. The computer program product of claim 15, wherein submitting the converted query to a SPARQL endpoint comprises submitting a first converted query with a first LIMIT clause and a second converted query with a second LIMIT clause.

19. The computer program product of claim 15, wherein transforming the SPARQL query results uses an XSLT processor.

20. The computer program product of claim 15, wherein converting the database query into a SPARQL query format comprises determining that the database query can be converted into more than one equivalent SPARQL query, and selecting the fastest one from among the more than one equivalent SPARQL queries.