I'll just add that there are two ways to reconcile DBpedia and Freebase 
and they don't ~quite~ give the same answers.

    (1) you can use the /type/object/key with /wikipedia/(en|de...) and 
match that up with the dbpedia identifier,  or
    (2) you can use the numeric "en_id",  "de_id" and match that up with the 
number from dbpedia

Note you can generate a linkage file for (1) based entirely on the quad 
dump,  but to do (2) you need the page id's from DBpedia.

I've tried both of these and decided to use (2) based on a very superficial 
analysis for Ookaboo.  All I really know is that the results from (1) and 
(2) aren't quite the same.


-----Original Message----- 
From: Jona Christopher Sahnwaldt
Sent: Thursday, October 18, 2012 5:49 PM
To: Pablo N. Mendes
Cc: [email protected]
Subject: Re: [Dbpedia-discussion] sameAs links to Freebase

On Wed, Oct 17, 2012 at 3:20 PM, Pablo N. Mendes <[email protected]> 
wrote:
> Hi Marco,
> Can also be obtained via Wikipedia links in the Freebase Quad Dump:
>
> /m/0p_47        /type/object/key        /wikipedia/en   Steve_Martin
> /m/0p_47        /type/object/key        /wikipedia/de_id        107261
>
> http://wiki.freebase.com/wiki/Data_dumps#Quad_dump
>
> Would be sweet to have a Scala object that blazes through this dump and
> outputs the sameAs info.

Here you go:

http://dbpedia.hg.sourceforge.net/hgweb/dbpedia/extraction_framework/file/dump/scripts/src/main/scala/org/dbpedia/extraction/scripts/CreateFreebaseLinks.scala

The script currently only looks for wikipedia/en links, but it's
trivial to change that to another language (and very simple to add a
parameter for the language).

The script needs the DBpedia datasets Labels, Redirects and 
DisambiguationLinks.

Cheers,
JC

>
> Cheers,
> Pablo
>
>
> On Wed, Oct 17, 2012 at 2:04 PM, Dimitris Kontokostas <[email protected]>
> wrote:
>>
>> Hi Marco,
>>
>> In DBpedia Greek we created a script [1] where we created these links
>> transitively from the English datasets.
>> Note that it needs a few modifications to work with the new directory
>> structure.
>> If you find it handy and adapt it you can contribute it back for the 
>> other
>> chapters.
>>
>> Best,
>> Dimitris
>>
>> [1]
>> http://dbpedia.hg.sourceforge.net/hgweb/dbpedia/extraction_framework/file/7c499145af2c/scripts/shell-scripts/interlinking
>>
>>
>> On Wed, Oct 17, 2012 at 2:37 PM, Marco Fossati <[email protected]>
>> wrote:
>>>
>>> Forgot the links...
>>>
>>> [1] http://wiki.freebase.com/wiki/DBPedia
>>> [2]
>>>
>>> http://blog.dbpedia.org/2008/11/15/dbpedia-is-now-interlinked-with-freebase-links-to-opencyc-updated/
>>>
>>> On 10/17/12 1:30 PM, Marco Fossati wrote:
>>> > Hi everyone,
>>> >
>>> > In order to improve the Italian DBpedia interlinkage, it would be 
>>> > great
>>> > to add sameAs links to Freebase.
>>> > How did you guys do that on the English version?
>>> > I found a couple of posts in the Freebase wiki [1] and DBpedia blog 
>>> > [2]
>>> > saying it was done some years ago, but I can't find more details.
>>> > Could you please tell me more?
>>> > Thanks!
>>> >
>>> > Cheers,
>>> >
>>> > Marco
>>>
>>>
>>> ------------------------------------------------------------------------------
>>> Everyone hates slow websites. So do we.
>>> Make your web apps faster with AppDynamics
>>> Download AppDynamics Lite for free today:
>>> http://p.sf.net/sfu/appdyn_sfd2d_oct
>>> _______________________________________________
>>> Dbpedia-discussion mailing list
>>> [email protected]
>>> https://lists.sourceforge.net/lists/listinfo/dbpedia-discussion
>>
>>
>>
>>
>> --
>> Kontokostas Dimitris
>>
>>
>> ------------------------------------------------------------------------------
>> Everyone hates slow websites. So do we.
>> Make your web apps faster with AppDynamics
>> Download AppDynamics Lite for free today:
>> http://p.sf.net/sfu/appdyn_sfd2d_oct
>> _______________________________________________
>> Dbpedia-discussion mailing list
>> [email protected]
>> https://lists.sourceforge.net/lists/listinfo/dbpedia-discussion
>>
>
>
>
> --
> ---
> Pablo N. Mendes
> http://pablomendes.com
> Events: http://wole2012.eurecom.fr
>
>
> ------------------------------------------------------------------------------
> Everyone hates slow websites. So do we.
> Make your web apps faster with AppDynamics
> Download AppDynamics Lite for free today:
> http://p.sf.net/sfu/appdyn_sfd2d_oct
> _______________________________________________
> Dbpedia-discussion mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/dbpedia-discussion
>

------------------------------------------------------------------------------
Everyone hates slow websites. So do we.
Make your web apps faster with AppDynamics
Download AppDynamics Lite for free today:
http://p.sf.net/sfu/appdyn_sfd2d_oct
_______________________________________________
Dbpedia-discussion mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/dbpedia-discussion 


------------------------------------------------------------------------------
Everyone hates slow websites. So do we.
Make your web apps faster with AppDynamics
Download AppDynamics Lite for free today:
http://p.sf.net/sfu/appdyn_sfd2d_oct
_______________________________________________
Dbpedia-discussion mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/dbpedia-discussion

Reply via email to