W3C home > Mailing lists > Public > public-lod@w3.org > November 2009

Re: [Dbpedia-discussion] ANN: DBpedia 3.4 released

From: Sebastian Hellmann <hellmann@informatik.uni-leipzig.de>
Date: Thu, 12 Nov 2009 15:05:21 +0000
Message-ID: <4AFC2431.6090003@informatik.uni-leipzig.de>
To: nathan@webr3.org
CC: Bernhard Schandl <bernhard.schandl@univie.ac.at>, public-lod <public-lod@w3.org>, dbpedia-discussion@lists.sourceforge.net
Hi,
Yes, it is a simple sparql query, but quite heavy in performance.
The public store is limited (I think result set size=1000 and max of 200 
seconds).
I always keep some ready images here:  http://downloads.dbpedia.org/ see 
the tar.gzs, but haven't had the time to load 3.4 in our local mirror 
store.  I can probably produce the numbers for 3.3 quite easily, as we 
have the data set loaded into a virtuoso here locally.  If you want to 
do it yourself, you can use the query below and modify it a little bit.
Regards,
Sebastian, AKSW


Select
    ?template ?property count(?property) as ?count
 From <http://dbpedia.org> {
?s <http://dbpedia.org/property/wikiPageUsesTemplate> ?template .
?s ?property ?o.
Filter (?property LIKE <http://dbpedia.org/property/%> && ?property != 
<http://dbpedia.org/property/wikiPageUsesTemplate>) .
}
GROUP BY ?template ?property
ORDER BY DESC(?template ) DESC(?count)
;


Nathan schrieb:
> Bernhard Schandl wrote:
>   
>> On Nov 12, 2009, at 14:13 , Bernhard Schandl wrote:
>>
>>     
>>> I would be interested in statistics per resources, e.g., the average
>>> and maximum number of triples per subject. Can you provide such numbers?
>>>       
>> Sorry, this is maybe a little bit too unspecific; especially the
>> distribution of triple numbers (i.e., how many resources have 1-10
>> triples, how many have 11-100, and so on) would be of interest.
>>
>> Best, Bernhard
>>
>>     
>
> couldn't you SPARQL that yourself?
>
> as in; it's my understanding (at my current newbie level of knowledge)
> that this information should be accessible via some SPARQL queries,
> indeed my understanding of RDF was to expose data so that just such
> information could be extracted - ie surely that's the point of rdf and
> sparql?
>
> regards!
>
>
>   


-- 
Dipl. Inf. Sebastian Hellmann
Department of Computer Science, University of Leipzig
Homepage: http://bis.informatik.uni-leipzig.de/SebastianHellmann
Research Group: http://aksw.org
Received on Thursday, 12 November 2009 15:06:14 UTC

This archive was generated by hypermail 2.4.0 : Friday, 17 January 2020 16:20:54 UTC