Thanks, I get this table is pretty cool (and yeah, I thought Aristotle
would be first but I was wrong) but I'd like to keep my table in this
form: *Influencee
: Influencer *so I can actually plot it in Gephi and then do the rest. I
think the earlier query you mentioned does that, however, my question was,
does it capture the truth as the two earlier individual tables did
individually? I just wanted to be sure it does. Moreover, my it would be
nice to modify the query to include persons as I did in my Question
originally, because at this stage, it gives you stuff like "Java
Programming Language", which is funny as I'd not like it to be there,
specially for my analysis of the 'most powerful men in history'. Thanks
Josh.
On Sat, Dec 21, 2013 at 7:33 PM, Joshua TAYLOR <joshuaaa...@gmail.com>wrote:
>
> On Sat, Dec 21, 2013 at 2:24 PM, Ali Gajani <aligaj...@gmail.com> wrote:
>
>> Firstly, thank you so much for helping me discover new knowledge (for
>> myself) through this beautifully crafted SPARQL. This makes a lot more
>> sense that you have used the DISTINCT keyword to actually eliminate any
>> duplicates, but will this query ensure the truth is captured in one table
>> in the same way as the individual two tables did, because I want to make
>> sure I can use this dataset to count indegrees (high influencers) properly.
>> It is impossible to survey all the rows to ensure the knowledge is true,
>> but I am asking anyway.
>
>
> If that's what you're trying to measure, then you could use a query like
>
> select ?influencer (count(distinct ?influencee) as ?numberOfInfluencees)
> where {
> ?influencer dbpedia-owl:influenced|^dbpedia-owl:influencedBy ?influencee
> }
> group by ?influencer
> order by desc(?numberOfInfluencees)
> limit 100
>
> to find out how many distinct influencees each influencer had. (Karl Marx
> is pretty influential.)
>
>
>
> --
> Joshua Taylor, http://www.cs.rpi.edu/~tayloj/
>
--
Ali Gajani
Founder at Mr. Geek
www.mrgeek.me
www.aligajani.com
------------------------------------------------------------------------------
Rapidly troubleshoot problems before they affect your business. Most IT
organizations don't have a clear picture of how application performance
affects their revenue. With AppDynamics, you get 100% visibility into your
Java,.NET, & PHP application. Start your 15-day FREE TRIAL of AppDynamics Pro!
http://pubads.g.doubleclick.net/gampad/clk?id=84349831&iu=/4140/ostg.clktrk
_______________________________________________
Dbpedia-discussion mailing list
Dbpedia-discussion@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/dbpedia-discussion
