Changes between Version 6 and Version 7 of CMD2RDF/Queries

Timestamp:

05/23/14 21:27:54 (10 years ago)

Author:

xnrn@gmx.net

Comment:

added further queries with data categories

CMD2RDF/Queries

@@ -50 +50 @@
 }}}
 
+List all used datcats, with english labels and counts:
+{{{
+#!sql
+PREFIX dcr: <http://www.isocat.org/ns/dcr.rdf#>
+
+SELECT SAMPLE(?datcatid) SAMPLE(?datcatlabel) COUNT(?e) as ?count
+WHERE {?e dcr:datcat ?datcatid.
+       ?datcat dcr:datcat ?datcatid.
+       ?datcat rdfs:label ?datcatlabel.
+  FILTER(langMatches(lang(?datcatlabel), "EN"))
+}
+GROUP BY ?datcatid ?datcatlabel
+ORDER BY DESC(?count)
+}}}
+[[http://clarin.aac.ac.at/virtuoso/sparql?default-graph-uri=&query=PREFIX+dcr%3A+%3Chttp%3A%2F%2Fwww.isocat.org%2Fns%2Fdcr.rdf%23%3E%0D%0A%0D%0ASELECT+SAMPLE%28%3Fdatcatid%29+SAMPLE%28%3Fdatcatlabel%29+COUNT%28%3Fe%29+as+%3Fcount%0D%0AWHERE+{%3Fe+dcr%3Adatcat+%3Fdatcatid.%0D%0A+++++++%3Fdatcat+dcr%3Adatcat+%3Fdatcatid.%0D%0A+++++++%3Fdatcat+rdfs%3Alabel+%3Fdatcatlabel.%0D%0A++FILTER%28langMatches%28lang%28%3Fdatcatlabel%29%2C+%22EN%22%29%29%0D%0A}%0D%0AGROUP+BY+%3Fdatcatid+%3Fdatcatlabel%0D%0AORDER+BY+DESC%28%3Fcount%29&format=text%2Fhtml&timeout=0&debug=on|datcat with label and counts]]
+
 List all relations from the relation registry:
 {{{
@@ -55 +71 @@
 SELECT ?dc1 ?reltype ?dc2 
 WHERE { 
-       { GRAPH <http://clarin.eu/cmd/rr-cmdi.rdf> {?dc1 ?reltype ?dc2 } }
- UNION { GRAPH <http://clarin.eu/cmd/rr-dc.rdf> {?dc1 ?reltype ?dc2 } }
+       { GRAPH <http://www.clarin.eu/cmd/rr-cmdi.rdf> {?dc1 ?reltype ?dc2 } }
+ UNION { GRAPH <http://www.clarin.eu/cmd/rr-dc.rdf> {?dc1 ?reltype ?dc2 } }
 }
+}}}
+
+List values in fields for given data category (`DC-2544` resourceTitle):
+{{{
+#!sql
+PREFIX dcr: <http://www.isocat.org/ns/dcr.rdf#>
+
+SELECT ?v as ?resourcetitle
+WHERE {?cmdelem dcr:datcat "http://www.isocat.org/datcat/DC-2544".
+       ?instelem a ?cmdelem.
+       ?instelem ?p ?v.
+FILTER isLiteral(?v)
+}
+ORDER BY ?v
+}}}
+
+Datcats with the number of elements they are references by and the number of corresponding instances:
+{{{
+#!sql
+PREFIX dcr: <http://www.isocat.org/ns/dcr.rdf#>
+
+SELECT SAMPLE(?datcatid) COUNT(distinct ?cmdelem) as ?count COUNT(?instelem) as ?count_instances
+WHERE {?cmdelem  dcr:datcat ?datcatid.      
+       ?instelem a ?cmdelem. 
+}
+GROUP BY ?datcatid 
+ORDER BY DESC(?count_instances)
 }}}
 
@@ -100 +143 @@
 
 
+=== Search by DatCat
+
+Search in description fields for string `syntax` or `parse`: 
+{{{
+#!sql
+PREFIX dcr: <http://www.isocat.org/ns/dcr.rdf#>
+
+SELECT ?v as ?resourcetitle
+WHERE {?cmdelem dcr:datcat "http://www.isocat.org/datcat/DC-2520".
+       ?instelem a ?cmdelem.
+       ?instelem ?p ?v.
+FILTER isLiteral(?v).
+FILTER REGEX(?v, "(syntax|parse)", "i")
+}
+}}}
+
+[[http://clarin.aac.ac.at/sparql?default-graph-uri=&query=PREFIX+dcr%3A+%3Chttp%3A%2F%2Fwww.isocat.org%2Fns%2Fdcr.rdf%23%3E%0D%0A%0D%0ASELECT+%3Fv+as+%3Fresourcetitle%0D%0AWHERE+{%3Fcmdelem+dcr%3Adatcat+%22http%3A%2F%2Fwww.isocat.org%2Fdatcat%2FDC-2520%22.%0D%0A+++++++%3Finstelem+a+%3Fcmdelem.%0D%0A+++++++%3Finstelem+%3Fp+%3Fv.%0D%0AFILTER+isLiteral%28%3Fv%29.%0D%0AFILTER+REGEX%28%3Fv%2C+%22%28syntax%7Cparse%29%22%2C+%22i%22%29%0D%0A}&format=text%2Fhtml&timeout=10000&debug=on| syntax or parse in description ]] (by datcat: [[http://isocat.org/datcat/2520|Description]] `DC-2520`)
+