More information: If I query the open-source version of Virtuoso, loaded with
the same set of graphs, it returns results. I suspect there is something in
the configuration or security of the commercial that is not letting this
return. I am not really sure where to look to debug this.
Tracy M. Safran
Programmer Analyst - EVS support
Frederick National Laboratory for Cancer Research
Leidos Biomedical Research, Inc.
Ph: 240-276-5172
tracy.saf...@fnlcr.nih.gov<mailto:tracy.saf...@fnlcr.nih.gov>
From: "Safran , Tracy (NIH/NCI) [C]" <safr...@mail.nih.gov>
Date: Tuesday, October 11, 2016 at 8:59 PM
To: Kingsley Idehen <kide...@openlinksw.com>,
"virtuoso-users@lists.sourceforge.net" <virtuoso-users@lists.sourceforge.net>
Subject: Re: [Virtuoso-users] Problem with advanced queries
I am not getting any error, just an empty class list. (<class 'list'>: [] ) The
same dataset is loaded into Stardog, for the sake of comparison, and the exact
same query returns results.
Tracy M. Safran
Programmer Analyst - EVS support
Frederick National Laboratory for Cancer Research
Leidos Biomedical Research, Inc.
Ph: 240-276-5172
tracy.saf...@fnlcr.nih.gov<mailto:tracy.saf...@fnlcr.nih.gov>
From: Kingsley Idehen <kide...@openlinksw.com>
Date: Tuesday, October 11, 2016 at 6:17 PM
To: "virtuoso-users@lists.sourceforge.net"
<virtuoso-users@lists.sourceforge.net>
Subject: Re: [Virtuoso-users] Problem with advanced queries
On 10/11/16 4:37 PM, Safran, Tracy (NIH/NCI) [C] wrote:
I am having problems doing some slightly advanced queries against http. A
simple query works but other queries don’t. Is there a deeper issue with
permissions or indexes that I need to look into?
Example: This works.
SELECT *
FROM <http://NCIT_NG1><http://NCIT_NG1> where { ?s ?p ?o } LIMIT 50
But this does not (note: prefix left out for brevity)
SELECT ?subject ?role ?object
WHERE {
?subject rdfs:subClassOf ?an .
?an owl:onProperty ?role .
?an owl:someValuesFrom ?object .
?subject rdfs:subClassOf* ncit:Gene
}
ORDER BY asc(?subject)
Tracy M. Safran
Programmer Analyst - EVS support
Frederick National Laboratory for Cancer Research
Leidos Biomedical Research, Inc.
Ph: 240-276-5172
tracy.saf...@fnlcr.nih.gov<mailto:tracy.saf...@fnlcr.nih.gov>
I assume you are getting:
Virtuoso 37000 Error TR...: transitive start not given ?
You need to add some qualification to the query to optimize for unknowns such
as db size and available memory.
Examples:
1.
http://dbpedia.org/sparql?default-graph-uri=&query=SELECT+distinct+%3Fsubject+%3Fobject%0D%0A%0D%0A++++WHERE+%7B%0D%0A%0D%0A%0D%0A++++++++%3Fsubject+a+owl%3AClass+.%0D%0A++++++++%3Fobject+a+owl%3AClass+.%0D%0A++++++++%3Fsubject+rdfs%3AsubClassOf*+%3Fobject+.+%0D%0A%0D%0A++++++++filter+%28contains%28xsd%3Astring%28%3Fsubject%29%2C%27dbpedia.org%27%29%29%0D%0A++++++++%7D%0D%0A%0D%0A++++ORDER+BY+asc%281%29%0D%0A%0D%0ALIMIT+100&format=text%2Fx-html%2Btr&CXML_redir_for_subjs=121&CXML_redir_for_hrefs=&timeout=30000&debug=on
-- DBpedia Static
2.
http://dbpedia-live.openlinksw.com/sparql?default-graph-uri=&query=SELECT+distinct+%3Fsubject+%3Fobject%0D%0A%0D%0A++++WHERE+%7B%0D%0A%0D%0A%0D%0A++++++++%3Fsubject+a+owl%3AClass+.%0D%0A++++++++%3Fobject+a+owl%3AClass+.%0D%0A++++++++%3Fsubject+rdfs%3AsubClassOf*+%3Fobject+.+%0D%0A%0D%0A++++++++filter+%28contains%28xsd%3Astring%28%3Fsubject%29%2C%27dbpedia.org%27%29%29%0D%0A++++++++%7D%0D%0A%0D%0A++++ORDER+BY+asc%281%29%0D%0A%0D%0ALIMIT+100&format=text%2Fx-html%2Btr&CXML_redir_for_subjs=121&CXML_redir_for_hrefs=&timeout=30000&debug=on
-- DBpedia Live
3.
http://lod.openlinksw.com/sparql?default-graph-uri=&query=SELECT+distinct+%3Fsubject+%3Fobject%0D%0A%0D%0A++++WHERE+%7B%0D%0A%0D%0A%0D%0A++++++++%3Fsubject+a+owl%3AClass+.%0D%0A++++++++%3Fobject+a+owl%3AClass+.%0D%0A++++++++%3Fsubject+rdfs%3AsubClassOf*+%3Fobject+.+%0D%0A%0D%0A++++++++filter+%28contains%28xsd%3Astring%28%3Fsubject%29%2C%27umbel%27%29%29%0D%0A++++++++%7D%0D%0A%0D%0A++++ORDER+BY+asc%281%29%0D%0A%0D%0ALIMIT+100&format=text%2Fx-html%2Btr&CXML_redir_for_subjs=121&CXML_redir_for_hrefs=&timeout=30000&debug=on
-- massive 30 Billion+ LOD Cloud Cache
--
Regards,
Kingsley Idehen
Founder & CEO
OpenLink Software (Home Page: http://www.openlinksw.com)
Weblogs (Blogs):
Legacy Blog: http://www.openlinksw.com/blog/~kidehen/
Blogspot Blog: http://kidehen.blogspot.com
Medium Blog: https://medium.com/@kidehen
Profile Pages:
Pinterest: https://www.pinterest.com/kidehen/
Quora: https://www.quora.com/profile/Kingsley-Uyi-Idehen
Twitter: https://twitter.com/kidehen
Google+: https://plus.google.com/+KingsleyIdehen/about
LinkedIn: http://www.linkedin.com/in/kidehen
Web Identities (WebID):
Personal: http://kingsley.idehen.net/dataspace/person/kidehen#this
:
http://id.myopenlink.net/DAV/home/KingsleyUyiIdehen/Public/kingsley.ttl#this
------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, SlashDot.org! http://sdm.link/slashdot
_______________________________________________
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users
