7 Replies Latest reply: Apr 5, 2013 2:54 AM by 1000012 RSS

    Joseki/Fuseki for Oracle Spatial

    1000012
      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-Oracle
          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
            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-Oracle
              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
                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-Oracle
                  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
                    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
                      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