[Freebase-discuss] Querying Freebase for a relationship between nodes

Spencer Kelly spencerkelly86 at gmail.com
Wed Mar 23 10:09:51 UTC 2011


hey shahar, you've hit the nail on the head.
marriage in freebase is stored in a 'compound value type', so things
get a little more complicated.
its helpful maybe to think of this as a 1.5 ply connection
you can get the contents of a cvt by getting a topics incoming links,
then getting those outgoing links.
http://tinyurl.com/4sk9m36

On Wed, Mar 23, 2011 at 7:42 AM, Shahar Solomianik <shahar at triond.com> wrote:
> I think this query is starting to look like what I need... thanks.
>
> However, when I look at David Beckham's page in freebase (
> http://www.freebase.com/view/en/david_beckham)
> <http://www.freebase.com/view/en/david_beckham> I can see relations to
> Victoria Beckham ( http://www.freebase.com/view/en/victoria_beckham) and
> Manchester United F.C. (
> http://www.freebase.com/view/en/manchester_united_fc).
>
> However, those aren't anywhere to find in the query results. Any idea why?
> or how to rewrite the query so when the input is /en/david_beckham I get
> /en/victoria_beckham and /en/manchester_united_fc?
>
> Spencer Kelly wrote:
>>
>> hey david, this is a good question,
>> i've been thinking about this too
>>
>> this will get all the outgoing links for beckham
>> [{
>>  "id": "/en/david_beckham",
>>  "/type/reflect/any_master": [{
>>    "id":     null,
>>  }]
>> }]
>>
>> and then you can get the links of those links:
>> [{
>>  "id": "/en/david_beckham",
>>  "/type/reflect/any_master": [{
>>    "id":     null,
>>       "/type/reflect/any_master": [{
>>       "id":     null,
>>        }]
>>  }]
>> }]
>>
>>
>> you can query his relationships to other topics this way,
>> but it gets messy with permissions, cvts, non-reversed links etc.
>>
>> i played around with 2-ply relationships over here ->
>> http://between.freebaseapps.com/
>> i don't know if anyone has done a nice app for this type of analysis
>> yet, but it is certainly possible
>>
>>
>>
>> On Tue, Mar 15, 2011 at 1:00 PM, Shahar Solomianik <shahar at triond.com>
>> wrote:
>>
>>>
>>> David Seaman (http://rdf.freebase.com/ns/en/david_seaman) was the
>>> goalkeeper
>>> of Arsenal Football Club (http://rdf.freebase.com/ns/en/arsenal_fc).
>>>
>>> Having those two entities (nodes?), what is the right MQL syntax to find
>>> out
>>> the relationship? (i.e. wasTheGoalkeeper or whatever...)
>>>
>>> _______________________________________________
>>> You are receiving this message because you are subscribed to the
>>> Freebase-discuss mailing list.
>>> To post a message to the list: Freebase-discuss at freebase.com
>>> To unsubscribe, view archives, etc:
>>> http://lists.freebase.com/mailman/listinfo/freebase-discuss
>>>
>>>
>>
>> _______________________________________________
>> You are receiving this message because you are subscribed to the
>> Freebase-discuss mailing list.
>> To post a message to the list: Freebase-discuss at freebase.com
>> To unsubscribe, view archives, etc:
>> http://lists.freebase.com/mailman/listinfo/freebase-discuss
>>
>
> --
> Shahar Solomianik
> CEO, Triond Inc.
> http://triond.com
> +972-54-7600708
>
>
> _______________________________________________
> You are receiving this message because you are subscribed to the
> Freebase-discuss mailing list.
> To post a message to the list: Freebase-discuss at freebase.com
> To unsubscribe, view archives, etc:
> http://lists.freebase.com/mailman/listinfo/freebase-discuss
>


More information about the Freebase-discuss mailing list