Changes between Version 2 and Version 3 of CMD2RDF/Queries
- Timestamp:
- 05/21/14 07:27:19 (10 years ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
CMD2RDF/Queries
v2 v3 1 1 = SPARQL Queries for CMD2RDF 2 3 == CMDM - Model 4 5 6 == Profiles and Components - Schemas 7 8 List all profiles: 9 {{{ 10 #!sql 11 PREFIX cmdm: <http://www.clarin.eu/cmd/general.rdf#> 12 SELECT ?p WHERE { ?p rdfs:subClassOf cmdm:Profile } 13 }}} 14 [[http://clarin.aac.ac.at/isparql/view/?query=PREFIX%20cmdm%3A%20%3Chttp%3A%2F%2Fwww.clarin.eu%2Fcmd%2Fgeneral.rdf%23%3E%0A%0ASELECT%20%3Fp%20WHERE%20{%20%3Fp%20rdfs%3AsubClassOf%20cmdm%3AProfile%20}&endpoint=%2Fsparql&maxrows=50&timeout=&default-graph-uri=&view=1&amode=0&raw_iris=true|result in clarin.aac.ac.at-virtuoso]] 15 16 List the `cmdm:contains` relation pairs, 17 grouped by type with count: 18 {{{ 19 #!sql 20 SELECT (SAMPLE(?t1) AS ?PARENT) (SAMPLE(?t2) AS ?CHILD) (COUNT(?c2) as ?COUNT) 21 WHERE { 22 ?c1 <http://www.clarin.eu/cmd/general.rdf#contains> ?c2. 23 ?c1 a ?t1. ?c2 a ?t2. 24 } 25 GROUP BY ?t1 ?t2 26 ORDER BY ?t1 ?t2 27 }}} 28 29 [[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|result]] 30 31 32 == Inspect instance data 33 34 35 === Language 2 36 3 37 List distinct used `LanguageNames`: … … 12 46 GROUP BY ?v 13 47 }}} 14 [[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]]48 [[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]] 15 49 16 50 … … 36 70 37 71 38 39 List the `cmdm:contains` relation pairs,40 grouped by type with count:41 {{{42 #!sql43 SELECT (SAMPLE(?t1) AS ?PARENT) (SAMPLE(?t2) AS ?CHILD) (COUNT(?c2) as ?COUNT)44 WHERE {45 ?c1 <http://www.clarin.eu/cmd/general.rdf#contains> ?c2.46 ?c1 a ?t1. ?c2 a ?t2.47 }48 GROUP BY ?t1 ?t249 ORDER BY ?t1 ?t250 }}}51 52 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]]