SPARQL query for semantic similarity in Wikidata times out

Asked Feb 21 '19 at 21:12

Active Feb 24 '19 at 18:01

Viewed 228 times

I'd like to find entities "similar" to John Harrison in Wikidata. My naive SPARQL query always times out.

SELECT ?similar ?similarLabel (COUNT(?p) AS ?similarity) WHERE {
  wd:Q314335 ?p ?o.
  ?similar ?p ?o.
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}
GROUP BY ?similar ?similarLabel
HAVING (?similarity > 5)
ORDER BY DESC(?similarity)

I've tried limiting the number of properties from a sub query, but it still times out.

Is there a more efficient SPARQL query that might succeed? Are there any other Blazegraph extensions (e.g., GAS) that might help here?

edited Feb 24 '19 at 18:01

unor

92,415
26
211
360

asked Feb 21 '19 at 21:12

rickhg12hs

10,638
6
24
42

1

http://tIny_url.com/y6327wey (remove `_`). See also http://graphdb.ontotext.com/documentation/free/semantic-similarity-searches.html – Stanislav Kralin Feb 21 '19 at 22:02
@StanislavKralin Very good! If I want to include the `GROUP_CONCAT` of `?rLabel`, how would I do that? I'm timing out again. :( – rickhg12hs Feb 21 '19 at 23:33
2

http://tiny_url.com/y468ayoc – Stanislav Kralin Feb 22 '19 at 10:22

SPARQL query for semantic similarity in Wikidata times out

0 Answers0