This discussion is archived
7 Replies Latest reply: Apr 5, 2013 12:54 AM by 1000012 RSS

Joseki/Fuseki for Oracle Spatial

1000012 Newbie
Currently Being Moderated
Hi,

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.

Regards,

Arnaud K.
Arhs

Edited by: 997009 on 29 mars 2013 14:50
  • 1. Re: Joseki/Fuseki for Oracle Spatial
    alwu Pro
    Currently Being Moderated
    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.

    Thanks,

    Zhe Wu
  • 2. Re: Joseki/Fuseki for Oracle Spatial
    1000012 Newbie
    Currently Being Moderated
    Hi Zhe,

    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.

    Regards,

    Arnaud
  • 3. Re: Joseki/Fuseki for Oracle Spatial
    alwu Pro
    Currently Being Moderated
    Hi,

    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.)

    Thanks,

    Zhe Wu
  • 4. Re: Joseki/Fuseki for Oracle Spatial
    1000012 Newbie
    Currently Being Moderated
    Hi Zhe,

    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.

    Thanks,

    Regards,

    Arnaud
  • 5. Re: Joseki/Fuseki for Oracle Spatial
    alwu Pro
    Currently Being Moderated
    Hi Arnaud,

    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.

    Thanks,

    Zhe
  • 6. Re: Joseki/Fuseki for Oracle Spatial
    1000012 Newbie
    Currently Being Moderated
    Hi Zhe,

    Yes, we already asked our client to execute the SQL translation on the database. I will come back to you with the results.

    Thanks,

    Arnaud
  • 7. Re: Joseki/Fuseki for Oracle Spatial
    1000012 Newbie
    Currently Being Moderated
    Hi Zhe,

    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.

    Thanks,

    Arnaud

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points