Integrating applications with an RDF repository through a SPARQL gateway

Patent metadata

Field	Value
Publication number	US-8949225-B2
Application number	US-201213477362-A
Country	US
Kind code	B2
Filing date	May 22, 2012
Priority date	May 22, 2012
Publication date	Feb 3, 2015
Grant date	Feb 3, 2015

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.

First claim

What is claimed is:

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.

Assignees

• Wu Zhe
• Rieb Karl
• Oracle Int Corp

Inventors

• Wu Zhe
• Rieb Karl

Classifications

• G06F17/30

  Physics · mapped topic

• G06F17/30595 Primary

  Physics · mapped topic

• G06F16/258 Primary

  Data format conversion from or to a database · CPC title

• G06F16/00

  Information retrieval; Database structures therefor; File system structures therefor · CPC title

• G06F16/284 Primary

  Relational databases · CPC title