In order to have a SPARQL endpoint over http, we want to use Joseki or Fuseki with our Oracle Spatial. Actually, we are using Joseki but we have some performance issue.
Have you a feedback on this two products? What is the more adapted for Oracle Spatial?
Fuseki is compatible and efficient with Oracle Spatial? We don't see a lot of information or example of configuration on the Web.
Thanks in advance for your help.
Edited by: 997009 on 29 mars 2013 14:50
Hi Arnaud K.,
Right now, the latest release of Jena Adapter supports Joseki 3.4.4. We are considering the support of Fuseki in a later release.
What kind of performance issues are your seeing? Maybe we can provide a bit help.
Thank you for your helpful response. We were not sure about the incompatibility with Fuseki.
Our client has a RDF store with over 700 millions of tripes. Unfortunately, they have frequently timeouts during selects. The problem is clearly present with heavy operations like filter or distinct,but also with more common operators. This is very restrictive for tools that are based on the SPARQL endpoint.
We have also the well known issue of the SPARQL endpoint on a Read-only database.
Thank you for your attention.
Did your client add timeout explicitly in their queries? This does not sound like something that is related to Joseki's logic.
To get Joseki + Jena Adapter + WLS to work with an Oracle read-only DB, please contact Oracle support. The way
Jena Adapter runs semantic query is indeed compatible with a read-only Oracle DB. (We've also done some internal testing on that.)
Thank you for the information about the read-only compatibility.
The query is in timeout after 30 minutes, that's the session timeout specified on the Joseki side.
Nevertheless, I think it is already an high timeout value.
So the query did not finish after 30 minutes? Does it make a different if you run those queries in the database directly? Could you please cut & paste here a few of the slow queries? If that is not convenient, you can send them to Oracle support or to me at alan dot wu at oracle dot com.
For your information, we are waiting the results from our client. The problem doesn't occur at our premises. It seems that the timeouts occur randomly.
We will come back to you by email.