< However, there is
no ontology present for the FDA database. The field "Zip Code" is common
for all the three databases.>
To add to Scott's response:
If you are trying to convert BMIS file to RDF, you can do so by using the
Spreadsheet importer. If you modify the text file to include column headings
as the first row, these will be automatically used as datatype properties.
In the import wizard you will also get to specify the class name, so a
simple initial ontology (single class with the columns as properties) will
be automatically created.
Once in RDF you can run queries or use "Extract class" to make the FDA
receipt dates separate resources distinct from the investigators.
After you do the merge (by as Scott suggested importing all datasets into a
common one), you may decide to do the same for zip codes and treat them as
resources. I do not know your use case and can't comment if this would be
the right thing to do.
A simpler merging option is to make all three different zip code properties
a subproperty of the new "zip code integration" property you define in the
integration ontology. With that you can run queries as follows:
SELECT ?s ?p ?o
WHERE {?zip rdfs:subPropertyOf integration:zipcode.
?s ?zip "10580".
?s ?p ?o.}
This query returns everything you know about a resource that has a zipcode
value of 10580 irrespective of which of the 3 RDF datasets this information
is coming from.
-----Original Message-----
From: [email protected]
[mailto:[email protected]] On Behalf Of Scott
Henninger
Sent: Sunday, July 19, 2009 9:17 PM
To: TopBraid Composer Users
Subject: [tbc-users] Re: Merging Databases
You can use owl:imports. Create a file for each ontology in Composer,
be it in an RDF serialization (.n3, .rdf, .rdfs, .owl, .nt) or in an
external rdf data store (.sesame, .allegro, .oracle, etc.). Then
import into one of the files or create a fourth that imports all
three. In Composer, this can be done through a drag/drop to the
imports view.
-- Scott
To kee the files independent,
On Jul 19, 7:58 pm, Amrapali Zaveri <[email protected]> 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.
>
> Could anyone suggest possibilities of how to merge the three databases,
> based on ontologies?
>
> Thanks,
> Regards,
> Amrapali J Zaveri
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"TopBraid Composer Users" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/topbraid-composer-users?hl=en
-~----------~----~----~----~------~----~------~--~---
