What is the best way to run some SQL statements to create tables if they do not
exists?
I'm trying to achieve (at last), true automated deployment.
Dan Davis, Systems/Applications Architect (Contractor),
Office of Computer and Communications Systems,
National Library of Medicine, NIH
---
Hi Maria,
The explain output is more for analysis by development, there are limited
description of Query Plans at http://docs.openlinksw.com/virtuoso/perfdiag/ ,
but those params are not documented. In terms of query execution the Virtuoso
profile command can be used for determining if the que
Sorry for another mail. But just to confirm is the join used by the
query plan below some kind of loop join:
{
RDF_QUAD_POGS 4 rows(s_1_4_t1.S)
P = ##plays , O = #/Music
RDF_QUAD_POGS 0.8 rows(s_1_4_t0.S)
inlined P = ##type , O = ##Musician , S = s_1_4_t1.S
Distinct (s_1
Hi Balazs,
From your stackoverflow post the
“com.hp.hpl.jena.sparql.engine.http.QueryExceptionHTTP: File not found” error
is coming from Jena, are any error in the Virtuoso log ? When performing a
checkpoint which is an atomic action in Virtuoso the database will be
temporarily inaccessible an
Hi Pantelis,
OK, good to hear the issue has been resolved …
Best Regards
Hugh Williams
Professional Services
OpenLink Software, Inc. // http://www.openlinksw.com/
Weblog -- http://www.openlinksw.com/blogs/
LinkedIn -- http://www.linkedin.com/company/openlink-software/
Twitter
Hi Ghislain,
many thanks for your answer.
By the way the page you're mentioning doesn't resolv my doubts.
First the last two examples, which are using geospatial query
(bif:st_intersects) are not working: the first is giving no results, the
last an error.
Then I'm concerned with the geospatial fu
Hi Pasquale,
Yes, I think you are missing something. The point is probably that you are not
using quite well the functions in your queries?!
Please have a look at this page
http://linkedgeodata.org/GADM which contains some sample queries for the
LinkedGeo data endpoint which powered by Virtuoso
Dear All,
Thank you very much for your response. However, I am not able to
understand the meaning of "inlined", "rosq", "artm" in Virtuoso's
query plans. For exposition my question contains small example query.
Also how can I figure out which join algorithm is used by Virtuoso by
looking at the o