-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Hi Peter,
Indeed, I forgot to recount when I added additional filters to the query. Anyway, I'm not sure CONSTRUCT is really what I want here. Is there no way to get SELECT DISTINCT to work? I may have to resort to dropping the DISTINCT keyword, and filtering out the duplicate results myself. Thanks, Alex Peter Ansell wrote: > Have you tried a construct query instead? > > Interestingly, the actual number of results according to Virtuoso is 3123, so > you might be expecting information that isn't quite complete for all 6000 > articles. > > PREFIX skos: <http://www.w3.org/2004/02/skos/core#> > PREFIX dbpedia: <http://dbpedia.org/resource/> > PREFIX dbpedia-prop: <http://dbpedia.org/property> > PREFIX dbpedia-cat: <http://dbpedia.org/resource/Category:> > PREFIX dbpedia-owl: <http://dbpedia.org/ontology/> > PREFIX foaf: <http://xmlns.com/foaf/0.1/> > > SELECT COUNT(DISTINCT ?article) > WHERE > { > ?article a dbpedia-owl:MilitaryConflict . > ?article dbpprop:conflict ?conflict . > ?article dbpedia-owl:date ?date . > ?article dbpedia-owl:place ?place . > ?article dbpprop:place ?placeName . > ?article dbpprop:combatant ?combatant . > ?article dbpprop:commander ?commander . > ?article dbpedia-owl:result ?result . > ?article dbpedia-owl:strength ?strength . > ?article dbpedia-owl:causalties ?casualties . > } > > The following query gets 6487 as a result: > > PREFIX skos: <http://www.w3.org/2004/02/skos/core#> > PREFIX dbpedia: <http://dbpedia.org/resource/> > PREFIX dbpedia-prop: <http://dbpedia.org/property> > PREFIX dbpedia-cat: <http://dbpedia.org/resource/Category:> > PREFIX dbpedia-owl: <http://dbpedia.org/ontology/> > PREFIX foaf: <http://xmlns.com/foaf/0.1/> > > SELECT COUNT(DISTINCT ?article) > WHERE > { > ?article a dbpedia-owl:MilitaryConflict . > OPTIONAL { ?article dbpprop:conflict ?conflict . } > OPTIONAL { ?article dbpedia-owl:date ?date . } > OPTIONAL { ?article dbpedia-owl:place ?place . } > OPTIONAL { ?article dbpprop:place ?placeName . } > OPTIONAL { ?article dbpprop:combatant ?combatant . } > OPTIONAL { ?article dbpprop:commander ?commander . } > OPTIONAL { ?article dbpedia-owl:result ?result . } > OPTIONAL { ?article dbpedia-owl:strength ?strength . } > OPTIONAL { ?article dbpedia-owl:causalties ?casualties . } > } > > > ----- Original Message ---- >> From: Alex <alex...@gmail.com> >> To: Hugh Williams <hwilli...@openlinksw.com>; >> virtuoso-users@lists.sourceforge.net >> Sent: Monday, 28 September, 2009 10:41:36 AM >> Subject: [Virtuoso-users] SELECT DISTINCT queries >> > Hi Hugh, > > I have now resorted to using OFFSET/LIMIT to get the full set of results > (about 6,000, in my case). However, I am having trouble with the > following SPARQL query on http://dbpedia.org/sparql. > > PREFIX skos: > PREFIX dbpedia: > PREFIX dbpedia-prop: > PREFIX dbpedia-cat: > PREFIX dbpedia-owl: > PREFIX foaf: > > SELECT DISTINCT ?article ?conflict ?date ?place ?placeName ?combatant > ?commander ?result ?strength ?casualties > WHERE > { > ?article a dbpedia-owl:MilitaryConflict . > ?article dbpprop:conflict ?conflict . > ?article dbpedia-owl:date ?date . > ?article dbpedia-owl:place ?place . > ?article dbpprop:place ?placeName . > ?article dbpprop:combatant ?combatant . > ?article dbpprop:commander ?commander . > ?article dbpedia-owl:result ?result . > ?article dbpedia-owl:strength ?strength . > ?article dbpedia-owl:causalties ?casualties . > } > LIMIT 100 > > Error message: > 42000 Error SQ200: The memory pool size 20021248 reached the limit > 20000000 bytes, try to increase the MaxMemPoolSize ini setting. > > Any suggestions as to how I might avoid this issue? Observe that it > disappears when I remove the 'DISTINCT' keyword, but then I'm getting an > unacceptably large number of duplicate results. > > Regards, > Alex >> - ------------------------------------------------------------------------------ Come build with us! The BlackBerry® Developer Conference in SF, CA is the only developer event you need to attend this year. Jumpstart your developing skills, take BlackBerry mobile applications to market and stay ahead of the curve. Join us from November 9-12, 2009. Register now! http://p.sf.net/sfu/devconf _______________________________________________ Virtuoso-users mailing list Virtuoso-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/virtuoso-users > > __________________________________________________________________________________ > Get more done like never before with Yahoo!7 Mail. > Learn more: http://au.overview.mail.yahoo.com/ -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.10 (MingW32) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/ iQEcBAEBAgAGBQJKwJ3UAAoJEOqaT4w4/280vqAIALBBfOBR5UMv7nG/Hy7huwmX em+FvNcTtExS9wuObmV6cw89ObgiKT+aSJaHxbsWCgGrL4IXYnE6rvr6+rtrnIs6 ksj9zyyq+n79pEmOmQC9I76MuN8YOvSt2WKJR/u6lCJiB//NfqIa2Rcdv8zOpwIW 0XYWi/CfYAoD1hZ66w4i230SBYfdfdjEisD8HV0N9Cjn4Wrriv/StWu5zQSsC+W7 mIriRCPe/uhfONRQmccqB4MXnaMhpZJ0f4QzViUBg6ffX2JAy+UENnY18QLe3xAv tXDNawlEcLMF50Fq2fWaGnVQwj/N4XFwFqy70j+bXz/vYYwdEHSKZyzy79+WN6M= =juOh -----END PGP SIGNATURE-----
