Changes between Version 2 and Version 3 of CMD2RDF/Queries


Ignore:
Timestamp:
05/21/14 07:27:19 (10 years ago)
Author:
xnrn@gmx.net
Comment:

added profiles query, reorganized

Legend:

Unmodified
Added
Removed
Modified
  • CMD2RDF/Queries

    v2 v3  
    11= SPARQL Queries for CMD2RDF
     2
     3== CMDM - Model
     4
     5
     6== Profiles and Components - Schemas
     7
     8List all profiles:
     9{{{
     10#!sql
     11PREFIX cmdm: <http://www.clarin.eu/cmd/general.rdf#>
     12SELECT ?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
     16List the `cmdm:contains` relation pairs,
     17grouped by type with count:
     18{{{
     19#!sql
     20SELECT (SAMPLE(?t1) AS ?PARENT) (SAMPLE(?t2) AS ?CHILD) (COUNT(?c2) as ?COUNT)
     21WHERE {
     22   ?c1 <http://www.clarin.eu/cmd/general.rdf#contains> ?c2.
     23   ?c1 a ?t1. ?c2 a ?t2.
     24 }
     25GROUP BY ?t1 ?t2
     26ORDER 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
    236
    337List distinct used `LanguageNames`:
     
    1246GROUP BY ?v
    1347}}}
    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]]
    1549
    1650
     
    3670
    3771
    38 
    39 List the `cmdm:contains` relation pairs,
    40 grouped by type with count:
    41 {{{
    42 #!sql
    43 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 ?t2
    49 ORDER BY ?t1 ?t2
    50 }}}
    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]]