SPARQL Queries for CMD2RDF

CMDM - Model

Profiles and Components - Schemas

List all profiles:

PREFIX cmdm: <http://www.clarin.eu/cmd/general.rdf#>
SELECT ?p WHERE { ?p rdfs:subClassOf cmdm:Profile }

​​result in clarin.aac.ac.at-virtuoso

List the cmdm:contains relation pairs, grouped by type with count:

SELECT (SAMPLE(?t1) AS ?PARENT) (SAMPLE(?t2) AS ?CHILD) (COUNT(?c2) as ?COUNT)
WHERE { 
   ?c1 <http://www.clarin.eu/cmd/general.rdf#contains> ?c2.
   ?c1 a ?t1. ?c2 a ?t2.
 } 
GROUP BY ?t1 ?t2
ORDER BY ?t1 ?t2

​result

Inspect instance data

Language

List distinct used LanguageNames:

PREFIX cmd-lang: <http://catalog.clarin.eu/ds/ComponentRegistry/rest/registry/components/clarin.eu:cr1:c_1271859438111/rdf#>

SELECT SAMPLE(?v) COUNT(?v)
WHERE { 
   [] cmd-lang:Language.hasLanguageNameElementValue ?v.
 } 
GROUP BY ?v

​result

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)

​result