Database Stats

Stats from my RDFWeb database

A bunch of simple stats from my RDFWeb database:

Sorry this is broken at the moment - will fix soon...

all predicates

select distinct value, count(resources.value) as num from "+ resources, triples where keyhash=triples.predicate group by value "+ order by num desc;

all classes (I cheated a bit - I knew the sha1 for rdf:type)

query="SELECT DISTINCT b1.value AS class, count(b1.value) as num FROM triples a1, resources b1 WHERE a1.predicate = '-1317267140' and b1.keyhash=a1.object group by b1.value order by num desc;