Re: retrieve a list of all distinct/unique resources in a store/repo from Ian Dickinson on 2017-11-21 (public-rdf-ruby@w3.org from November 2017)

From: Ian Dickinson <i.j.dickinson@gmail.com>
Date: Tue, 21 Nov 2017 00:35:13 +0000
To: Anthony Durity <a.durity@umail.ucc.ie>
Cc: W3C Ruby RDF mailing list <public-rdf-ruby@w3.org>
Message-ID: <CAHvAVxa=5dSYFjvdvORsxB=f3GMDXJ=v=ZGToVYYV0nrfz=wcw@mail.gmail.com>

On Tue, Nov 21, 2017 at 12:30 AM, Ian Dickinson <i.j.dickinson@gmail.com> wrote:
> On Mon, Nov 20, 2017 at 4:47 PM, Anthony Durity <a.durity@umail.ucc.ie> wrote:
>> What about the SPARQL-y route?
> Off the top of my head, untested:
>
>     select distinct ?term {
>         { ?term ?p ?o } union
>         { ?s ?term ?o } union
>         { ?s ?p ?term }
>
>         FILTER (!isBlank(?term))
>     }
>
> Probably quite an expensive query on a store of any size, so be careful!

Oops, you said no literals either. So the filter should be:

   FILTER (!isBlank(?term) && !isLiteral(?term))

Ian

Received on Tuesday, 21 November 2017 00:35:41 UTC