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

Re: Merging Databases

From: Kingsley Idehen <kidehen@openlinksw.com>
Date: Mon, 20 Jul 2009 13:06:37 +0100
Message-ID: <4A645DCD.8000500@openlinksw.com>
CC: Amrapali Zaveri <amrapali.zaveri@gmail.com>, "public-lod@w3.org" <public-lod@w3.org>
Hugh Glaser wrote:
> And just in case you haven't found it, a load of these hard-won equivalences are collected together at sameas.org, such as
> http://sameas.org/?uri=http://data.linkedct.org/resource/intervention/51572
> Hugh
>
>   
seeAlso :

http://lod.openlinksw.com/describe/?url=http%3A%2F%2Fdata.linkedct.org%2Fresource%2Fintervention%2F51572&sid=32550&urilookup=1 
(A web page that allows provides powerful data exploration of this LOD 
Cloud Cache instance).


Note the "Statistics" link (look at the "Expanded Same As" Tab) or 
follow the Yago link for additional data.

Remember, the original de-referencable URIs are exposed in the @href of 
the anchor text associated with "About:" when looking at the Description 
Pages.

Kingsley
> On 20/07/2009 05:03, "Oktie Hassanzadeh" <oktie@cs.toronto.edu> wrote:
>
> On Sun, Jul 19, 2009 at 9:00 PM, Amrapali Zaveri <amrapali.zaveri@gmail.com> wrote:
> Hi all,
>
> I am attempting to merge 3 databases: (i) Clinicaltrials.gov <http://clinicaltrials.gov/>  , (ii) Geonames <http://www.geonames.org/>  , (iii) FDA <http://www.fda.gov/Drugs/InformationOnDrugs/ucm135162.htm>  based on ontologies.
>
> There are RDF Triples already defined for (i) http://linkedct.org/index.html and there is already an ontology present for (ii) http://www.geonames.org/ontology/ . However, there is no ontology present for    the FDA database. The field "Zip Code" is common for all the three databases.
>
>
> If the FDA datasets are not published as RDF yet, we can certainly take the lead in publishing them as a part of the Linking Open Drug Data [1] project.
>
> [1] http://esw.w3.org/topic/HCLSIG/LODD
>
> LinkedCT already provides links to Geonames, but please let me know if you see any missing links.
>
>
> Regards,
> Oktie
>
>
> Could anyone suggest possibilities of how to merge the three databases, based on ontologies?
>
> Thanks,
> Regards,
> Amrapali J Zaveri
>
>
>
>
>
>   


-- 


Regards,

Kingsley Idehen	      Weblog: http://www.openlinksw.com/blog/~kidehen
President & CEO 
OpenLink Software     Web: http://www.openlinksw.com
Received on Monday, 20 July 2009 12:07:20 UTC

This archive was generated by hypermail 2.4.0 : Thursday, 24 March 2022 20:29:44 UTC