Free text search in sparql when you have multiword and scaping character

Question

I am wondering how I can use in sparql query when I have a word like : Robert J. O'Neill I am looking for the resource that have the multiword unit with quota or unicode character in the Label property.

                 SELECT DISTINCT ?resource ?abstract 
                 WHERE {?resource rdfs:label ?s.
                 ?s <bif:contains> "'Robert J. O'Neill'"
                 ?resource dbo:abstract ?abstract
                 }
                 '''

What have you tried so far? What is the exact problem you are facing? — vendettamit, Jun 11 '18 at 15:50

Gilles-Antoine Nys · Accepted Answer · 2018-06-11T20:16:35.110

1

Here is the query that will return all the elements that have "Robert J. O'Neill" as label.

SELECT DISTINCT ?s WHERE 
{
    ?s rdfs:label ?label .
    FILTER(regex(?label, "Robert J. O'Neill", "i"))
}

If you are sure that you need a specific string matching. This is faster :

SELECT DISTINCT ?s WHERE 
{
    ?s rdfs:label ?label .
    ?label bif:contains "Robert J. O'Neill"
}

But be aware that, Virtuoso for example doesnt support such a query because of the spaces in the string. So an alternative is to avoid it as :

SELECT DISTINCT * WHERE 
{
    ?s rdfs:label ?label .
    ?label bif:contains "Robert" .
    FILTER (CONTAINS(?label, " J. O'Neill"))
}

edited Jun 11 '18 at 20:16

answered Jun 11 '18 at 16:37

Gilles-Antoine Nys

1,481
16
21

Is it possible to do it with beacause regex is slow? – far-zadeh Jun 11 '18 at 19:50
Thanks, Is there any endpoint that support a query with spaces in the string? – far-zadeh Jun 11 '18 at 20:57
I haven't tested other endpoints on this specific statement yet. – Gilles-Antoine Nys Jun 11 '18 at 20:58

score 1 · Answer 2 · answered Jun 12 '18 at 10:22

1

I found following code faster that the regex:

SELECT ?s  WHERE { ?s  rdfs:label ?o FILTER ( bif:contains ( ?o, '"Robert" AND "J." AND "Neill"' ) ) }

answered Jun 12 '18 at 10:22

far-zadeh

135
7

Indeed, it is a possible variant of the provide answer. – Gilles-Antoine Nys Jun 12 '18 at 14:18

Free text search in sparql when you have multiword and scaping character

2 Answers2

Linked