Changes between Version 1 and Version 2 of CMD2RDF/Queries

Timestamp:

05/20/14 14:18:53 (10 years ago)

Author:

xnrn@gmx.net

Comment:

--

CMD2RDF/Queries

@@ -12 +12 @@
 GROUP BY ?v
 }}}
+[[http://clarin.aac.ac.at/isparql/view/?query=PREFIX%20cmd-lang%3A%20%3Chttp%3A%2F%2Fcatalog.clarin.eu%2Fds%2FComponentRegistry%2Frest%2Fregistry%2Fcomponents%2Fclarin.eu%3Acr1%3Ac_1271859438111%2Frdf%23%3E%0A%0ASELECT%20SAMPLE%28%3Fv%29%20COUNT%28%3Fv%29%0AWHERE%20{%20%0A%20%20%20[]%20cmd-lang%3ALanguage.hasLanguageNameElementValue%20%3Fv.%0A%20}%20%0AGROUP%20BY%20%3Fv&endpoint=%2Fsparql&maxrows=50&timeout=&default-graph-uri=&view=1&amode=0&raw_iris=false| result in clarin.aac.ac.at-virtuoso]]
+
+
+List distinct LangNames and corresponding LangCodes order by frequency:
+{{{
+PREFIX cmdm: <http://www.clarin.eu/cmd/general.rdf#>
+PREFIX cmd-lang: <http://catalog.clarin.eu/ds/ComponentRegistry/rest/registry/components/clarin.eu:cr1:c_1271859438111/rdf#>
+PREFIX cmd-iso639: <http://catalog.clarin.eu/ds/ComponentRegistry/rest/registry/components/clarin.eu:cr1:c_1271859438110/rdf#>
+
+SELECT SAMPLE(?langnamevalue) as ?langname SAMPLE(?iso639codevalue) as ?langcode COUNT(?langnamevalue) as ?count
+WHERE { 
+   ?langname cmd-lang:Language.hasLanguageNameElementValue ?langnamevalue.
+   ?lang cmdm:contains ?langname.
+   ?lang cmdm:contains ?iso639.
+   ?iso639 cmdm:contains ?iso639code.
+   ?iso639code a cmd-iso639:ISO639.iso-639-3-code.
+   ?iso639code cmd-iso639:ISO639.hasiso-639-3-codeElementValue ?iso639codevalue.
+ } 
+GROUP BY ?langnamevalue  ?iso639codevalue
+ORDER BY DESC(?count)
+}}}
+[[http://clarin.aac.ac.at/isparql/view/?query=PREFIX%20cmdm%3A%20%3Chttp%3A%2F%2Fwww.clarin.eu%2Fcmd%2Fgeneral.rdf%23%3E%0APREFIX%20cmd-lang%3A%20%3Chttp%3A%2F%2Fcatalog.clarin.eu%2Fds%2FComponentRegistry%2Frest%2Fregistry%2Fcomponents%2Fclarin.eu%3Acr1%3Ac_1271859438111%2Frdf%23%3E%0APREFIX%20cmd-iso639%3A%20%3Chttp%3A%2F%2Fcatalog.clarin.eu%2Fds%2FComponentRegistry%2Frest%2Fregistry%2Fcomponents%2Fclarin.eu%3Acr1%3Ac_1271859438110%2Frdf%23%3E%0A%0ASELECT%20SAMPLE(%3Flangnamevalue)%20as%20%3Flangname%20SAMPLE(%3Fiso639codevalue)%20as%20%3Flangcode%20COUNT(%3Flangnamevalue)%20as%20%3Fcount%0AWHERE%20%7B%20%0A%20%20%20%3Flangname%20cmd-lang%3ALanguage.hasLanguageNameElementValue%20%3Flangnamevalue.%0A%20%20%20%3Flang%20cmdm%3Acontains%20%3Flangname.%0A%20%20%20%3Flang%20cmdm%3Acontains%20%3Fiso639.%0A%20%20%20%3Fiso639%20cmdm%3Acontains%20%3Fiso639code.%0A%20%20%20%3Fiso639code%20a%20cmd-iso639%3AISO639.iso-639-3-code.%0A%20%20%20%3Fiso639code%20cmd-iso639%3AISO639.hasiso-639-3-codeElementValue%20%3Fiso639codevalue.%0A%20%7D%20%0AGROUP%20BY%20%3Flangnamevalue%20%20%3Fiso639codevalue%0AORDER%20BY%20DESC(%3Fcount)&endpoint=%2Fsparql&maxrows=50&timeout=&default-graph-uri=&view=1&amode=0&raw_iris=false|result]]
+
+
+
 List the `cmdm:contains` relation pairs,
 grouped by type with count:
@@ -24 +49 @@
 ORDER BY ?t1 ?t2
 }}}
+
+result in [[http://clarin.aac.ac.at/isparql/view/?query=SELECT%20%28SAMPLE%28%3Ft1%29%20AS%20%3FPARENT%29%20%28SAMPLE%28%3Ft2%29%20AS%20%3FCHILD%29%20%28COUNT%28%3Fc2%29%20as%20%3FCOUNT%29%0AWHERE%20{%20%0A%20%20%20%3Fc1%20%3Chttp%3A%2F%2Fwww.clarin.eu%2Fcmd%2Fgeneral.rdf%23contains%3E%20%3Fc2.%0A%20%20%20%3Fc1%20a%20%3Ft1.%20%3Fc2%20a%20%3Ft2.%0A%20}%20%0AGROUP%20BY%20%3Ft1%20%3Ft2%0AORDER%20BY%20%3Ft1%20%3Ft2&endpoint=%2Fsparql&maxrows=50&timeout=&default-graph-uri=&view=1&amode=0&raw_iris=false|clarin.aac.ac.at-virtuoso]]