Re: Real Federated SPARQL Queries Required and Possible Collaboration

Hi Muhammed,

You can find here [1] some Fed queries we used some years ago for mapping purpose of vocabs in LOV and prefix.cc <http://prefix.cc/>.
HTH

Ghislain 
[1] https://github.com/cygri/prefix.cc/wiki <https://github.com/cygri/prefix.cc/wiki> 

> Le 20 déc. 2016 à 09:14, Thomas Francart <thomas.francart@sparna.fr> a écrit :
> 
> 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 <http://vocabularies.unesco.org/sparql>) :
> 
> PREFIX skos: <http://www.w3.org/2004/02/skos/core# <http://www.w3.org/2004/02/skos/core#>> 
> PREFIX isothes: <http://purl.org/iso25964/skos-thes# <http://purl.org/iso25964/skos-thes#>>
> PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema# <http://www.w3.org/2000/01/rdf-schema#>>
> PREFIX dbo: <http://dbpedia.org/ontology/ <http://dbpedia.org/ontology/>>
> SELECT ?pays ?isoCode ?concept ?nomDbpedia
> WHERE {
>     SERVICE <http://fr.dbpedia.org/sparql <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 <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+ <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 <mailto:ismael@lcc.uma.es>>:
> Dear Saleem,
> 
> I read your email, and I would like to share with you http://bioqueries.uma.es <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 <mailto: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 <mailto: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 <https://svn.aksw.org/papers/2015/ISWC_FEASIBLE/public.pdf>
> [2] http://svn.aksw.org/papers/2015/ISWC_LSQ/public.pdf <http://svn.aksw.org/papers/2015/ISWC_LSQ/public.pdf>[3] http://aksw.github.io/LSQ/ <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 <http://blog.sparna.fr/>, site : sparna.fr <http://sparna.fr/>, linkedin : fr.linkedin.com/in/thomasfrancart <https://fr.linkedin.com/in/thomasfrancart>
> tel :  +33 (0)6.71.11.25.97, skype : francartthomas

---------------------------------------
Ghislain A. Atemezing, Ph.D
Mail: ghislain.atemezing@gmail.com
Web: https://w3id.org/people/gatemezing <http://www.atemezing.org/>
Twitter: @gatemezing
About Me: https://about.me/ghislain.atemezing <https://about.me/ghislain.atemezing>

Received on Tuesday, 20 December 2016 10:57:40 UTC