On 10/11/16 8:59 PM, Safran, Tracy (NIH/NCI) [C] wrote: > > 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> >
My examples are against pretty large datasets, but using the commercial
edition of Virtuoso. Are you able to provide any insights into your
datasets?
Please try the following to see if they shed any light on this matter. :
/SELECT ?subject ?role ?object/
/ WHERE { GRAPH //<http://NCIT_NG1> <http://NCIT_NG1> WHERE {/
/ ?subject rdfs:subClassOf ?an ./
/ ?an owl:onProperty ?role ./
/ ?an owl:someValuesFrom ?object ./
/ ?subject rdfs:subClassOf* ncit:Gene/
/ }/
/ }/
//
/ ORDER BY _asc_(?subject) ;
/
/SELECT ?subject ?role ?object/
/ WHERE { GRAPH //<http://NCIT_NG1> <http://NCIT_NG1> WHERE {/
/ ?subject rdfs:subClassOf ?an ./
/ ?an owl:onProperty ?role ./
/ ?an owl:someValuesFrom ?object ./
/ ?subject rdfs:subClassOf+ ncit:Gene/
/ }/
/ }/
//
/ ORDER BY _asc_(?subject) ;
/
/SELECT ?subject ?role ?object/
/ WHERE { GRAPH //<http://NCIT_NG1> <http://NCIT_NG1> WHERE {/
/ ?subject rdfs:subClassOf ?an ./
/ ?an owl:onProperty ?role ./
/ ?an owl:someValuesFrom ?object ./
/ ?subject rdfs:subClassOf+ ncit:Gene/
/ }/
/ }/
//
/ ORDER BY _asc_(?subject)
LIMIT 50 ;
/
Kingsley /
/
>
>
>
>
>
> *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/
> <http://www.openlinksw.com/blog/%7Ekidehen/>
> 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
--
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
smime.p7s
Description: S/MIME Cryptographic Signature
------------------------------------------------------------------------------ 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
