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. #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. #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" 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
