W3C home > Mailing lists > Public > public-lod@w3.org > December 2016

Re: Real Federated SPARQL Queries Required and Possible Collaboration

From: Thomas Francart <thomas.francart@sparna.fr>
Date: Tue, 20 Dec 2016 09:14:21 +0100
Message-ID: <CAPugn7VqD_K3zz0gND9Gf4H_LerPnkZip7GJxBmdJR3Y_Ua=ew@mail.gmail.com>
To: Ismael Navas <ismael@lcc.uma.es>
Cc: Muhammad Saleem <saleem.muhammd@gmail.com>, "public-lod@w3.org" <public-lod@w3.org>, "semantic-web@w3.org Web" <semantic-web@w3.org>
Hello

Here is a query that fetches the country codes from (french) DBPedia for
countries with the same name as skos:Concept in the UNESCO thesaurus
(endpoint http://vocabularies.unesco.org/sparql) :

PREFIX skos: <http://www.w3.org/2004/02/skos/core#>
PREFIX isothes: <http://purl.org/iso25964/skos-thes#>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX dbo: <http://dbpedia.org/ontology/>
SELECT ?pays ?isoCode ?concept ?nomDbpedia
WHERE {
    SERVICE <http://fr.dbpedia.org/sparql> {
        ?pays a dbo:Country .
        ?pays dbo:isoCodeRegion ?isoCode .
        ?pays rdfs:label ?nomDbpedia .
        FILTER(langMatches(lang(?nomDbpedia), 'en'))
    }
    ?collection isothes:superGroup <http://vocabularies.unesco.
org/thesaurus/domain7> .
    ?collection skos:member ?concept .
      ?concept skos:prefLabel ?labelThesaurus .
    FILTER(langMatches(lang(?labelThesaurus), 'en'))
    FILTER( UCASE(STR(?labelThesaurus)) = UCASE(STR(?nomDbpedia)) )
}

Direct query link :

http://vocabularies.unesco.org/sparql-form/?query=PREFIX+skos%3A+%3Chttp%3A%2F%2Fwww.w3.org%2F2004%2F02%2Fskos%2Fcore%23%3E+%0APREFIX+isothes%3A+%3Chttp%3A%2F%2Fpurl.org%2Fiso25964%2Fskos-thes%23%3E%0APREFIX+rdfs%3A+%3Chttp%3A%2F%2Fwww.w3.org%2F2000%2F01%2Frdf-schema%23%3E%0APREFIX+dbo%3A+%3Chttp%3A%2F%2Fdbpedia.org%2Fontology%2F%3E%0ASELECT+%3Fpays+%3FisoCode+%3Fconcept+%3FnomDbpedia%0AWHERE+%7B%0A%09SERVICE+%3Chttp%3A%2F%2Ffr.dbpedia.org%2Fsparql%3E+%7B%0A++++%09%3Fpays+a+dbo%3ACountry+.%0A++++%09%3Fpays+dbo%3AisoCodeRegion+%3FisoCode+.%0A++++%09%3Fpays+rdfs%3Alabel+%3FnomDbpedia+.%0A++++%09FILTER(langMatches(lang(%3FnomDbpedia)%2C+%27en%27))%0A++++%7D%0A++++%3Fcollection+isothes%3AsuperGroup+%3Chttp%3A%2F%2Fvocabularies.unesco.org%2Fthesaurus%2Fdomain7%3E+.%0A++++%3Fcollection+skos%3Amember+%3Fconcept+.%0A++%09%3Fconcept+skos%3AprefLabel+%3FlabelThesaurus+.%0A++++FILTER(langMatches(lang(%3FlabelThesaurus)%2C+%27en%27))%0A++++FILTER(+UCASE(STR(%3FlabelThesaurus))+%3D+UCASE(STR(%3FnomDbpedia))+)%0A%7D+

2016-12-20 8:02 GMT+01:00 Ismael Navas <ismael@lcc.uma.es>:

> Dear Saleem,
>
> I read your email, and I would like to share with you
> http://bioqueries.uma.es as a repository of queries in Life Sciences.
>
> Regards,
> Ismael
>
>
> El 19 de diciembre de 2016 21:34:07 CET, Muhammad Saleem <
> saleem.muhammd@gmail.com> escribió:
>>
>> Dear all,
>>
>> Do you have federated SPARQL queries you use today or have used in the
>> past?
>>
>> Please e-mail them to us (via saleem.muhammd@gmail.com), as text files
>> or in any way you prefer, together with the URLs of the endpoints on which
>> you’ve executed them.
>>
>> Motivated by FEASIBLE [1] SPARQL benchmark generation framework, we want
>> to design a customizable (in terms of queries types, number of queries,
>> number of datasets etc.) federated SPARQL benchmark out of real queries
>> log/use-cases. To this end, we are currently collecting real federated
>> SPARQL queries from different domains, applications, and endpoints for
>> analysis.
>>
>> Your help in this endeavour would be highly appreciated.
>>
>> We'll be more than happy to collaborate and/or provide you with the
>> detailed results of the study if you contribute.
>>
>> Your federated queries will also be published as RDF as part of the
>> extended LSQ: The Linked SPARQL Queries Dataset [2,3].
>>
>> Best Regards,
>>
>> Muhammad Saleem
>>
>> Ruben Verborgh
>>
>> Claus Stadler
>>
>> Miel Vander Sande
>>
>> Axel-Cyrille Ngonga Ngomo
>>
>> Carlos Buil Aranda
>>
>> [1] https://svn.aksw.org/papers/2015/ISWC_FEASIBLE/public.pdf
>>
>> [2] http://svn.aksw.org/papers/2015/ISWC_LSQ/public.pdf
>> [3] http://aksw.github.io/LSQ/
>>
>>
>>
> --
> Sent from my Android device with K-9 Mail. Please excuse my brevity.
>



-- 

*Thomas Francart* -* SPARNA*
Web de *données* | Architecture de l'*information* | Accès aux
*connaissances*
blog : blog.sparna.fr, site : sparna.fr, linkedin :
fr.linkedin.com/in/thomasfrancart
tel :  +33 (0)6.71.11.25.97, skype : francartthomas
Received on Tuesday, 20 December 2016 08:15:22 UTC

This archive was generated by hypermail 2.3.1 : Tuesday, 20 December 2016 08:15:23 UTC