Hi Lei,
Note that bad data has been cleaned up so you now get the correct results, see:
http://dbpedia.org/sparql/?default-graph-uri=http%3A%2F%2Fdbpedia.org&qtxt=PREFIX+%3A+%3Chttp%3A%2F%2Fdbpedia.org%2Fresource%2F%3E%0D%0APREFIX+rdf%3A+%3Chttp%3A%2F%2Fwww.w3.org%2F1999%2F02%2F22-rdf-syntax-ns%23%3E%0D%0APREFIX+rdfs%3A+%3Chttp%3A%2F%2Fwww.w3.org%2F2000%2F01%2Frdf-schema%23%3E%0D%0APREFIX+dbpedia-owl%3A+%3Chttp%3A%2F%2Fdbpedia.org%2Fontology%2F%3E%0D%0A%0D%0ASELECT+%3Fauthor_name+%3Ftitle+%3Fpages%0D%0AFROM+%3Chttp%3A%2F%2Fdbpedia.org%2F%3E%0D%0AWHERE+%7B%0D%0A%3Fauthor+rdf%3Atype+dbpedia-owl%3AWriter+.%0D%0A%3Fauthor+rdfs%3Alabel+%3Fauthor_name+%0D%0AFILTER+%28LANG%28%3Fauthor_name%29%3D%22en%22%29+.+%0D%0A%3Fauthor+dbpedia-owl%3AnotableWork+%3Fwork+.%0D%0A%3Fwork+dbpedia-owl%3AnumberOfPages+%3Fpages%0D%0AFILTER+%28%3Fpages+%3E+500%29+.%0D%0A%3Fwork+rdfs%3Alabel+%3Ftitle+%0D%0AFILTER+%28LANG%28%3Ftitle%29%3D%22en%22%29.%0D%0A%7D+%0D%0AORDER+BY+%28%3Fpages%29%0D%0ALIMIT+100&format=text%2Fhtml&timeout=30000&debug=on
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 -- http://twitter.com/OpenLink
Google+ -- http://plus.google.com/100570109519069333827/
Facebook -- http://www.facebook.com/OpenLinkSoftware
Universal Data Access, Integration, and Management Technology Providers
On 22 Sep 2014, at 10:36, Hugh Williams <hwilli...@openlinksw.com> wrote:
> Hi Lei,
>
> This is due to bad data in the latest DBpedia 2014 datasets it seems ie
> <http://dbpedia.org/resource/Aunt_Phillis\u0027s_Cabin>
> dbpedia-owl:numberOfPages “0”^^xsd:positiveInteger . ; as the
> problem does not occur against the previous 3.9 datasets still hosted in LOD
> Cloud Cache instance, see:
>
> http://dbpedia.org/sparql/?default-graph-uri=http%3A%2F%2Fdbpedia.org&qtxt=PREFIX+%3A+%3Chttp%3A%2F%2Fdbpedia.org%2Fresource%2F%3E%0D%0APREFIX+rdf%3A+%3Chttp%3A%2F%2Fwww.w3.org%2F1999%2F02%2F22-rdf-syntax-ns%23%3E%0D%0APREFIX+rdfs%3A+%3Chttp%3A%2F%2Fwww.w3.org%2F2000%2F01%2Frdf-schema%23%3E%0D%0APREFIX+dbpedia-owl%3A+%3Chttp%3A%2F%2Fdbpedia.org%2Fontology%2F%3E%0D%0A%0D%0ASELECT+%3Fauthor_name+%3Ftitle+%3Fpages%0D%0AFROM+%3Chttp%3A%2F%2Fdbpedia.org%2F%3E%0D%0AWHERE+%7B%0D%0A%3Fauthor+rdf%3Atype+dbpedia-owl%3AWriter+.%0D%0A%3Fauthor+rdfs%3Alabel+%3Fauthor_name+%0D%0AFILTER+%28LANG%28%3Fauthor_name%29%3D%22en%22%29+.+%0D%0A%3Fauthor+dbpedia-owl%3AnotableWork+%3Fwork+.%0D%0A%3Fwork+dbpedia-owl%3AnumberOfPages+%3Fpages%0D%0AFILTER+%28%3Fpages+%3E+500%29+.%0D%0A%3Fwork+rdfs%3Alabel+%3Ftitle+%0D%0AFILTER+%28LANG%28%3Ftitle%29%3D%22en%22%29.%0D%0A%7D+%0D%0AORDER+BY+%28%3Fpages%29%0D%0ALIMIT+100&format=text%2Fhtml&timeout=30000&debug=on
>
> vs:
>
> http://lod.openlinksw.com/sparql?default-graph-uri=&qtxt=PREFIX+%3A+%3Chttp%3A%2F%2Fdbpedia.org%2Fresource%2F%3E%0D%0APREFIX+rdf%3A+%3Chttp%3A%2F%2Fwww.w3.org%2F1999%2F02%2F22-rdf-syntax-ns%23%3E%0D%0APREFIX+rdfs%3A+%3Chttp%3A%2F%2Fwww.w3.org%2F2000%2F01%2Frdf-schema%23%3E%0D%0APREFIX+dbpedia-owl%3A+%3Chttp%3A%2F%2Fdbpedia.org%2Fontology%2F%3E%0D%0A%0D%0ASELECT+%3Fauthor_name+%3Ftitle+%3Fpages%0D%0AFROM+%3Chttp%3A%2F%2Fdbpedia.org%3E%0D%0AWHERE+%7B%0D%0A%3Fauthor+rdf%3Atype+dbpedia-owl%3AWriter+.%0D%0A%3Fauthor+rdfs%3Alabel+%3Fauthor_name+%0D%0AFILTER+%28LANG%28%3Fauthor_name%29%3D%22en%22%29+.+%0D%0A%3Fauthor+dbpedia-owl%3AnotableWork+%3Fwork+.%0D%0A%3Fwork+dbpedia-owl%3AnumberOfPages+%3Fpages%0D%0AFILTER+%28%3Fpages+%3E+500%29+.%0D%0A%3Fwork+rdfs%3Alabel+%3Ftitle+%0D%0AFILTER+%28LANG%28%3Ftitle%29%3D%22en%22%29.%0D%0A%7D+%0D%0AORDER+BY+%28%3Fpages%29%0D%0ALIMIT+100&format=text%2Fhtml&CXML_redir_for_subjs=121&CXML_redir_for_hrefs=&timeout=30000&debug=on
>
> 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 -- http://twitter.com/OpenLink
> Google+ -- http://plus.google.com/100570109519069333827/
> Facebook -- http://www.facebook.com/OpenLinkSoftware
> Universal Data Access, Integration, and Management Technology Providers
>
> On 12 Sep 2014, at 14:42, Lei Niu <lei.niu...@gmail.com> wrote:
>
>>
>> * Query Examples on dbpedia.org/sparql/
>> ** 1)
>> PREFIX : http://dbpedia.org/resource/
>> PREFIX rdf: http://www.w3.org/1999/02/22-rdf-syntax-ns#
>> PREFIX rdfs: http://www.w3.org/2000/01/rdf-schema#
>> PREFIX dbpedia-owl: http://dbpedia.org/ontology/
>>
>> SELECT ?author_name ?title ?pages
>> FROM http://dbpedia.org/
>> WHERE {
>> ?author rdf:type dbpedia-owl:Writer .
>> ?author rdfs:label ?author_name
>> FILTER (LANG(?author_name)="en") .
>> ?author dbpedia-owl:notableWork ?work .
>> ?work dbpedia-owl:numberOfPages ?pages
>> FILTER (?pages > 500) .
>> ?work rdfs:label ?title
>> FILTER (LANG(?title)="en").
>> }
>> LIMIT 100
>>
>> RESULT:
>> author_name title pages
>> ...
>> "Seth and Mary Eastman"@en "Aunt Phillis's Cabin"@en
>> "0"^^http://www.w3.org/2001/XMLSchema#positiveInteger
>> ...
>> ** 2)
>> PREFIX : http://dbpedia.org/resource/
>> PREFIX rdf: http://www.w3.org/1999/02/22-rdf-syntax-ns#
>> PREFIX rdfs: http://www.w3.org/2000/01/rdf-schema#
>> PREFIX dbpedia-owl: http://dbpedia.org/ontology/
>>
>> SELECT ?author_name ?title ?pages
>> FROM http://dbpedia.org/
>> WHERE {
>> ?author rdf:type dbpedia-owl:Writer .
>> ?author rdfs:label ?author_name
>> FILTER (LANG(?author_name)="en") .
>> ?author dbpedia-owl:notableWork ?work .
>> ?work dbpedia-owl:numberOfPages ?pages
>> FILTER (?pages > 500) .
>> ?work rdfs:label ?title
>> FILTER (LANG(?title)="en").
>> }
>> ORDER BY (?pages)
>> LIMIT 100
>>
>> RESULT:
>> "Seth and Mary Eastman"@en "Aunt Phillis's Cabin"@en 140156966022648
>>
>>
>> * Summary and potential reason of this bug
>>
>> There is no page for "Aunt Phillis's Cabin".
>> The numberOfPages is http://www.w3.org/2001/XMLSchema#positiveInteger.
>> When do the query, the triples will be
>> "Seth and Mary Eastman"@en "Aunt Phillis's Cabin"@en
>> "0"^^http://www.w3.org/2001/XMLSchema#positiveInteger
>>
>> However 0 is not positive integer.
>>
>> The invalid result happens when ORDER BY used.
>>
>> ------------------------------------------------------------------------------
>> Want excitement?
>> Manually upgrade your production database.
>> When you want reliability, choose Perforce
>> Perforce version control. Predictably reliable.
>> http://pubads.g.doubleclick.net/gampad/clk?id=157508191&iu=/4140/ostg.clktrk_______________________________________________
>> Virtuoso-users mailing list
>> Virtuoso-users@lists.sourceforge.net
>> https://lists.sourceforge.net/lists/listinfo/virtuoso-users
>
------------------------------------------------------------------------------
Meet PCI DSS 3.0 Compliance Requirements with EventLog Analyzer
Achieve PCI DSS 3.0 Compliant Status with Out-of-the-box PCI DSS Reports
Are you Audit-Ready for PCI DSS 3.0 Compliance? Download White paper
Comply to PCI DSS 3.0 Requirement 10 and 11.5 with EventLog Analyzer
http://pubads.g.doubleclick.net/gampad/clk?id=154622311&iu=/4140/ostg.clktrk
_______________________________________________
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users
