The easiest and fast way to get DBpedia statistics is
http://dbtrends.aksw.org.

There is also a library that can be used in your code.
https://bitbucket.org/emarx/dbtrends/wiki/Home.

best,
Edgard

On Wed, Jan 28, 2015 at 5:54 PM, Jörn Hees <j_h...@cs.uni-kl.de> wrote:

> Hi,
>
> it seems it's not as easy as i had thought to get the top subjects,
> predicates and objects, as SPARQL queries such as this
> ```
> SELECT ?n COUNT(*) AS ?c
> WHERE {
>   ?n ?p ?o.
> }
> ORDER BY DESC(?c)
> LIMIT 10
> ```
> just time out / return with partial results.
>
>
> So i compiled them from the NT dumps, as described here (also see for full
> files):
>
> https://joernhees.de/blog/2015/01/28/dbpedia-2014-stats-top-subjects-predicates-and-objects/
>
> Thought this might be of interest to some of you.
>
>
> Turns out there's actually quite a lot of duplicate triples in the dumps:
>    4891 <
> http://commons.wikimedia.org/wiki/Special:FilePath/Flag_of_Slovenia.svg?width=300>
> <http://purl.org/dc/elements/1.1/rights> <
> http://en.wikipedia.org/wiki/File:Flag_of_Slovenia.svg> .
>    4891 <
> http://commons.wikimedia.org/wiki/Special:FilePath/Flag_of_Slovenia.svg> <
> http://xmlns.com/foaf/0.1/thumbnail> <
> http://commons.wikimedia.org/wiki/Special:FilePath/Flag_of_Slovenia.svg?width=300>
> .
>    4891 <
> http://commons.wikimedia.org/wiki/Special:FilePath/Flag_of_Slovenia.svg> <
> http://purl.org/dc/elements/1.1/rights> <
> http://en.wikipedia.org/wiki/File:Flag_of_Slovenia.svg> .
>    1520 <
> http://commons.wikimedia.org/wiki/Special:FilePath/Naval_Ensign_of_the_United_Kingdom.svg?width=300>
> <http://purl.org/dc/elements/1.1/rights> <
> http://en.wikipedia.org/wiki/File:Naval_Ensign_of_the_United_Kingdom.svg>
> .
>    1520 <
> http://commons.wikimedia.org/wiki/Special:FilePath/Naval_Ensign_of_the_United_Kingdom.svg>
> <http://xmlns.com/foaf/0.1/thumbnail> <
> http://commons.wikimedia.org/wiki/Special:FilePath/Naval_Ensign_of_the_United_Kingdom.svg?width=300>
> .
>    1520 <
> http://commons.wikimedia.org/wiki/Special:FilePath/Naval_Ensign_of_the_United_Kingdom.svg>
> <http://purl.org/dc/elements/1.1/rights> <
> http://en.wikipedia.org/wiki/File:Naval_Ensign_of_the_United_Kingdom.svg>
> .
>    1195 <
> http://commons.wikimedia.org/wiki/Special:FilePath/Airplane_silhouette.svg?width=300>
> <http://purl.org/dc/elements/1.1/rights> <
> http://en.wikipedia.org/wiki/File:Airplane_silhouette.svg> .
>    1195 <
> http://commons.wikimedia.org/wiki/Special:FilePath/Airplane_silhouette.svg>
> <http://xmlns.com/foaf/0.1/thumbnail> <
> http://commons.wikimedia.org/wiki/Special:FilePath/Airplane_silhouette.svg?width=300>
> .
>    1195 <
> http://commons.wikimedia.org/wiki/Special:FilePath/Airplane_silhouette.svg>
> <http://purl.org/dc/elements/1.1/rights> <
> http://en.wikipedia.org/wiki/File:Airplane_silhouette.svg> .
>
>
>
> Top10 Subjects:
>    8118 <
> http://dbpedia.org/resource/Alphabetical_list_of_communes_of_Italy>
>    7110 <http://dbpedia.org/resource/List_of_places_in_Afghanistan>
>    6162 <
> http://dbpedia.org/resource/Index_of_Andhra_Pradesh-related_articles>
>    5857 <
> http://dbpedia.org/resource/List_of_populated_places_in_Bosnia_and_Herzegovina
> >
>    5712 <http://dbpedia.org/resource/2013_in_film>
>    5550 <http://dbpedia.org/resource/List_of_municipalities_of_Brazil>
>    5458 <http://dbpedia.org/resource/List_of_dialling_codes_in_Germany>
>    5405 <
> http://dbpedia.org/resource/IUCN_Red_List_vulnerable_species_(Plantae)>
>    5392 <
> http://dbpedia.org/resource/List_of_CJK_Unified_Ideographs,_part_3_of_4>
>    5392 <
> http://dbpedia.org/resource/List_of_CJK_Unified_Ideographs,_part_2_of_4>
>    5392 <
> http://dbpedia.org/resource/List_of_CJK_Unified_Ideographs,_part_1_of_4>
>
> Top10 Predicates:
> 149707899 <http://dbpedia.org/ontology/wikiPageWikiLink>
> 86391520 <http://www.w3.org/1999/02/22-rdf-syntax-ns#type>
> 33958849 <http://www.w3.org/2002/07/owl#sameAs>
> 18731754 <http://purl.org/dc/terms/subject>
> 13926391 <http://www.w3.org/2000/01/rdf-schema#label>
> 13494896 <http://dbpedia.org/ontology/wikiPageRevisionID>
> 13494875 <http://www.w3.org/ns/prov#wasDerivedFrom>
> 13494819 <http://dbpedia.org/ontology/wikiPageID>
> 10948106 <http://dbpedia.org/ontology/wikiPageOutDegree>
> 10948106 <http://dbpedia.org/ontology/wikiPageLength>
>
> Top10 Objects:
> 10948086 <http://xmlns.com/foaf/0.1/Document> .
> 10948086 "en"^^<http://www.w3.org/2001/XMLSchema#string> .
> 6239553 "1"^^<http://www.w3.org/2001/XMLSchema#nonNegativeInteger> .
> 2250659 <http://dbpedia.org/class/yago/PhysicalEntity100001930> .
> 2169386 <http://dbpedia.org/class/yago/Object100002684> .
> 2155200 <http://www.w3.org/2002/07/owl#Thing> .
> 1974654 <http://www.ontologydesignpatterns.org/ont/dul/DUL.owl#Agent> .
> 1974654 <http://dbpedia.org/ontology/Agent> .
> 1816213 <http://dbpedia.org/class/yago/YagoLegalActorGeo> .
> 1650316 <http://xmlns.com/foaf/0.1/Person> .
> 1649647 <http://wikidata.dbpedia.org/resource/Q5> .
> 1649647 <http://wikidata.dbpedia.org/resource/Q215627> .
> 1649647 <http://schema.org/Person> .
>
>
> Cheers,
> Jörn
>
>
>
> ------------------------------------------------------------------------------
> Dive into the World of Parallel Programming. The Go Parallel Website,
> sponsored by Intel and developed in partnership with Slashdot Media, is
> your
> hub for all things parallel software development, from weekly thought
> leadership blogs to news, videos, case studies, tutorials and more. Take a
> look and join the conversation now. http://goparallel.sourceforge.net/
> _______________________________________________
> Dbpedia-discussion mailing list
> Dbpedia-discussion@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/dbpedia-discussion
>
>
------------------------------------------------------------------------------
Dive into the World of Parallel Programming. The Go Parallel Website,
sponsored by Intel and developed in partnership with Slashdot Media, is your
hub for all things parallel software development, from weekly thought
leadership blogs to news, videos, case studies, tutorials and more. Take a
look and join the conversation now. http://goparallel.sourceforge.net/
_______________________________________________
Dbpedia-discussion mailing list
Dbpedia-discussion@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/dbpedia-discussion

Reply via email to