Paul, On 11 Apr 2008, at 19:46, Paul Kreis wrote: > Hi All, > > I have still three problems: > > #1: always i test that query[1] on the DBpedia SPARQL-Endpoint > (http://DBpedia.org/sparql) i get this: "..... Error SQ200: The memory > pool size 10518528 reached the limit 10485760 bytes, try to > increase the > MaxMemPoolSize ini setting." > If i simplify the query and leave out the part with the director or > the > producer, it works.
[Hugh] The MaxMemPoolSize for the DBpedia SPARQL Endpoint has been doubled, and I can now run query #1 although it does return an empty result set. Please re-run yourself ... > > #2: some of my queries[2] are still to slow, it takes to much time for > the results, or i run in the maximum execution time. [Hugh] I have been able to run query #2, so this may have benefited from the MaxMemPoolSize increase. Please re-run yourself ... > > #3: whenever i use bif:contains in a query[3] and there is a blank > (e.g. > ?cityname bif:contains "New York") in the searchstring, i get this > error: "37000 Error XM029: Free-text expression, line 1: syntax > error at > York" [Hugh] You should use ?cityname bif:contains "'New York'" , note the single quotes inside the double quotes , which worked for me. Please re-run yourself ... Best Regards Hugh Williams Professional Services OpenLink Software > > best regards, > Paul Kreis > > Queries: > [1] > PREFIX foaf: <http://xmlns.com/foaf/0.1/> > PREFIX dbpedia2: <http://dbpedia.org/property/> > SELECT DISTINCT ?filmname ?page > FROM <http://dbpedia.org> > WHERE { > ?film dbpedia2:name ?filmname . > ?film foaf:page ?page . > {?film ?property > <http://dbpedia.org/class/yago/MotionPictureFilm103789400>} OPTIONAL > {?film ?property <http://dbpedia.org/class/yago/Film106613686>} > {?film dbpedia2:director ?director . ?director foaf:name ? > directorname . > ?directorname bif:contains "Kennedy"} > {?film dbpedia2:producer ?producer . ?producer foaf:name ? > producername . > ?producername bif:contains "Spielberg"} > {?film dbpedia2:year ?year }UNION{?film dbpedia2:years ?year } FILTER > (?year > "2000"^^xsd:integer) } > ORDER BY ?filmname > > [2] > PREFIX foaf: <http://xmlns.com/foaf/0.1/> > PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#> > PREFIX geo: <http://www.w3.org/2003/01/geo/wgs84_pos#> > SELECT DISTINCT ?cityname ?lat ?long ?page > FROM <http://dbpedia.org> > WHERE { > { ?city ?property <http://dbpedia.org/class/yago/City108524735> } > UNION { ?city ?property <http://dbpedia.org/class/yago/ > Capital108518505> } > UNION { ?city ?property <http://dbpedia.org/class/yago/ > Town108665504> } > ?city rdfs:label ?cityname . > FILTER (LANG(?cityname) = "en") . > ?city geo:long ?long . > ?city geo:lat ?lat . > ?city foaf:page ?page . > ?cityname bif:contains "Berlin" . } > ORDER BY ?cityname > > [3] > PREFIX foaf: <http://xmlns.com/foaf/0.1/> > PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#> > PREFIX geo: <http://www.w3.org/2003/01/geo/wgs84_pos#> > SELECT DISTINCT ?cityname ?page > FROM <http://dbpedia.org> > WHERE { > { ?city ?property <http://dbpedia.org/class/yago/City108524735> } > UNION { ?city ?property <http://dbpedia.org/class/yago/ > Capital108518505> } > UNION { ?city ?property <http://dbpedia.org/class/yago/ > Town108665504> } > ?city rdfs:label ?cityname . > FILTER (LANG(?cityname) = "en") . > ?city foaf:page ?page . > ?cityname bif:contains "New York" . } > ORDER BY ?cityname > > ---------------------------------------------------------------------- > --- > This SF.net email is sponsored by the 2008 JavaOne(SM) Conference > Don't miss this year's exciting event. There's still time to save > $100. > Use priority code J8TL2D2. > http://ad.doubleclick.net/clk;198757673;13503038;p?http:// > java.sun.com/javaone > _______________________________________________ > Dbpedia-discussion mailing list > [email protected] > https://lists.sourceforge.net/lists/listinfo/dbpedia-discussion ------------------------------------------------------------------------- This SF.net email is sponsored by the 2008 JavaOne(SM) Conference Don't miss this year's exciting event. There's still time to save $100. Use priority code J8TL2D2. http://ad.doubleclick.net/clk;198757673;13503038;p?http://java.sun.com/javaone _______________________________________________ Dbpedia-discussion mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/dbpedia-discussion
