Re: [Virtuoso-users] Subquery error when using Virtuoso7/ODBC/PHP

2015-12-29 Thread Hugh Williams
Hi Quentin, The query optimizer does not optimize remote client queries ie PHP via ODBC in this case, I imagine it will be some ODBC option being set by the PHP interface that is changing the query execution for such connections. When you ask about ODBC Driver building, I assume you mean the V

Re: [Virtuoso-users] Make my views refer to external ontology?

2015-12-29 Thread Kingsley Idehen
On 12/29/15 2:08 PM, Eng.Bassam wrote: > thanks > I thinks only must write FROM statement to include local ontologies in > my sparql or to inform sparql engine where can locate the data, i.e: > > select ?o ?cname > FROM //my persons data > FROM

Re: [Virtuoso-users] Make my views refer to external ontology?

2015-12-29 Thread Eng.Bassam
thanks I thinks only must write FROM statement to include local ontologies in my sparql or to inform sparql engine where can locate the data, i.e: select ?o ?cname FROM //my persons data FROM // geo cou

Re: [Virtuoso-users] Make my views refer to external ontology?

2015-12-29 Thread Kingsley Idehen
On 12/29/15 12:46 PM, Eng.Bassam wrote: > suppose the geoname resource is: > http://sws.geonames.org/2378080/";> > rdf:resource="http://sws.geonames.org/2378080/about.rdf"/> > Mauritania > > > I want to get name of country_geo > select ?o ?cname > where {?s SIO:SIO_000664 ?o; > ?s a f

Re: [Virtuoso-users] Make my views refer to external ontology?

2015-12-29 Thread Eng.Bassam
suppose the geoname resource is: http://sws.geonames.org/2378080/";> http://sws.geonames.org/2378080/about.rdf"/> Mauritania I want to get name of country_geo select ?o ?cname where {?s SIO:SIO_000664 ?o; ?s a foaf:Person. ?o gn:name ?cname } limit 10 how I can traverse

Re: [Virtuoso-users] Make my views refer to external ontology?

2015-12-29 Thread Kingsley Idehen
On 12/29/15 8:31 AM, Eng.Bassam wrote: > Hello > I have a person pesron table with columns (id, name , country_geo), > person table type in R2RML is foaf:person, I have also loaded geonames > onology in my virtuoso server at link > http://localhost:8890/ontologies/geonames > > now for the country_

[Virtuoso-users] Make my views refer to external ontology?

2015-12-29 Thread Eng.Bassam
Hello I have a person pesron table with columns (id, name , country_geo), person table type in R2RML is foaf:person, I have also loaded geonames onology in my virtuoso server at link http://localhost:8890/ontologies/geonames now for the country_geo column the r2rml is : rr:predicateObjectMap [ rr:

Re: [Virtuoso-users] Timeout problem

2015-12-29 Thread Hugh Williams
Hi Pantelis, Are you saying the query runs successfully against some other older Virtuoso SPARQL endpoint but it returning no results against this newer 3214 build you are using from Oct 2015 ? If so what is the version and build data of this earlier build. You need to profile the query and se

Re: [Virtuoso-users] Timeout problem

2015-12-29 Thread Pantelis Natsiavas
The [SPARQL] settings section of my virtuoso.ini file initially had a value for MaxQueryCostEstimationTime. I have just commented it out and now I don't get the error anymore. However, I actually get no response on my query. I use the web interface and when I click "Execute" button, I get no re