Dan Brickley wrote: > On Fri, Apr 16, 2010 at 11:43 PM, Kingsley Idehen > <[email protected]> wrote: > >> Tom Morris wrote: >> >>> This example query from the DBpedia page returns a list of companies >>> which all have exactly 151,000 employees: >>> >>> http://dbpedia.org/snorql/?query=SELECT+%3Fsubject+%3Femployees+%3Fhomepage+WHERE+{%0D%0A%3Fsubject+rdf:type+%3Chttp://dbpedia.org/class/yago/Company108058098%3E.%0D%0A%3Fsubject+dbpedia2:numEmployees+%3Femployees%0D%0AFILTER+(xsd:integer(%3Femployees)+%3E%3D+50000).%0D%0A%3Fsubject+foaf:homepage+%3Fhomepage.%0D%0A}+ORDER+BY+DESC(xsd:integer(%3Femployees))%0D%0ALIMIT+20%0D%0A >>> >>> That seems a rather improbable result. I'm not a real SPARQL guru, >>> but I don't see anything obviously wrong with the query. Is the query >>> incorrect or is the issue with the database or the server? >>> >>> Tom >>> >>> ------------------------------------------------------------------------------ >>> Download Intel® Parallel Studio Eval >>> Try the new software tools for yourself. Speed compiling, find bugs >>> > > > >> To save time (i.e. decoding the URL), could you please do the following: >> >> 1. Go to: http://dbpedia.org/isparql >> 2. Click on "Advanced Tab" >> 3. Paste in your query >> 4. Execute >> 5. Share the Query Results Link. >> >> Clearly our restrictions are in play, hence the recommendation that you >> page through using OFFSET and LIMIT. >> > > You can also paste > http://dbpedia.org/snorql/?query=SELECT+%3Fsubject+%3Femployees+%3Fhomepage+WHERE+{%0D%0A%3Fsubject+rdf:type+%3Chttp://dbpedia.org/class/yago/Company108058098%3E.%0D%0A%3Fsubject+dbpedia2:numEmployees+%3Femployees%0D%0AFILTER+(xsd:integer(%3Femployees)+%3E%3D+50000).%0D%0A%3Fsubject+foaf:homepage+%3Fhomepage.%0D%0A}+ORDER+BY+DESC(xsd:integer(%3Femployees))%0D%0ALIMIT+20%0D%0A > > ... into the form at http://meyerweb.com/eric/tools/dencoder/ > > This gives: > > http://dbpedia.org/snorql/?query=SELECT ?subject ?employees ?homepage WHERE { > ?subject rdf:type <http://dbpedia.org/class/yago/Company108058098>. > ?subject dbpedia2:numEmployees ?employees > FILTER (xsd:integer(?employees) >= 50000). > ?subject foaf:homepage ?homepage. > } ORDER BY DESC(xsd:integer(?employees)) > LIMIT 20 > > > Hope that helps! > > Dan > > Tom / Dan,
Restrictions aren't in play here, I misread "exactly 151,000 employees" as meaning: resultset record count, this looks like a SPARQL bug (at this point). -- Regards, Kingsley Idehen President & CEO OpenLink Software Web: http://www.openlinksw.com Weblog: http://www.openlinksw.com/blog/~kidehen Twitter/Identi.ca: kidehen ------------------------------------------------------------------------------ Download Intel® Parallel Studio Eval Try the new software tools for yourself. Speed compiling, find bugs proactively, and fine-tune applications for parallel performance. See why Intel Parallel Studio got high marks during beta. http://p.sf.net/sfu/intel-sw-dev _______________________________________________ Dbpedia-discussion mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/dbpedia-discussion
