This content has been marked as final.
Show 3 replies
-
1. Re: Sparql to Sql translation.
alwu-Oracle Mar 22, 2011 12:59 AM (in response to 849175)Hi Petar,
Why do you need to see the underlying SQL(s)?
Thanks,
Zhe Wu -
2. Re: Sparql to Sql translation.
849175 Mar 22, 2011 4:53 PM (in response to alwu-Oracle)Hi Zhe Wu,
i need to make some performance measurements, so i need to see the queries that are executed against the database.
I forgot to tell that I am using Oracle Database 11g. As i read, the last translation of the SPARQL query is done in Jena Adapter, and for the given SPARQL query a SEM_MATCH query is issued. I was looking for the source code of Jena Adapter, but I can't find it.
So does anybody have a clue how can I take advantage of Jena Adapter function to translate SPARQL query to SEM_MATCH query?
Thanks. -
3. Re: Sparql to Sql translation.
alwu-Oracle Mar 23, 2011 3:38 PM (in response to 849175)Hi,1 person found this helpful
A good way to measure SPARQL performance is to do that in your client program. You start a timer before you issue a SPARQL query, stop the timer after you get back all the results. Everything happening behind the scene is, well, internal business.
Note that in some cases, Jena Adapter translates a SPARQL query to multiple SQL queries and spends time merging the sub query results.
Btw, Jena Adapter is not open source so you won't find it.
If you really care about the SQL execution time, then you can do database performance monitoring using EM, AWR, etc.
Thanks,
Zhe Wu