Changes between Version 5 and Version 6 of CMD2RDF/Queries

Timestamp:

05/23/14 20:00:31 (10 years ago)

Author:

xnrn@gmx.net

Comment:

--

CMD2RDF/Queries

@@ -36 +36 @@
 [[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]]
 
-== Inspect use of data categories
+== Inspect data categories
 
-List all used datcats:
+
+List all used datcats, with counts:
 {{{
 #!sql
 PREFIX dcr: <http://www.isocat.org/ns/dcr.rdf#>
-SELECT distinct ?datcat WHERE {[] dcr:datcat ?datcat}
+
+SELECT SAMPLE(?datcat) COUNT(?e) as ?count
+WHERE {?e dcr:datcat ?datcat}
+GROUP BY ?datcat
+ORDER BY DESC(?count)
+}}}
+
+List all relations from the relation registry:
+{{{
+#!sql
+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 } }
+}
 }}}