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

Re: Tool that extracts ontologie from relational database

From: Kingsley Idehen <kidehen@openlinksw.com>
Date: Tue, 28 Jul 2009 14:31:21 +0100
Message-ID: <4A6EFDA9.3000107@openlinksw.com>
To: Juan Sequeda <jsequeda@cs.utexas.edu>
CC: ashok.malhotra@oracle.com, ticiana linhares <ticianalc@gmail.com>, public-xg-rdb2rdf <public-xg-rdb2rdf@w3.org>, jim.melton@acm.org
Juan Sequeda wrote:
> Hi Ticiana
>
> You can check out paper "Translating SQL Applications to the Semantic 
> Web" [1]. We present a set of formal and complete first order logic 
> rules to extract an ontology from the relational schema in SQL 
> DDL.This is part of a larger implementation that we are soon to 
> finalize. We will announce soon was we have this available for 
> download. You can also find a survey of existing approaches that 
> extract ontologies from relational databases here [2]
>
> There is also th RDBToOnto tool from the TAO Project [3]
>
> [1] http://www.springerlink.com/content/mv58805364k31734/
> [2] ftp://ftp.cs.utexas.edu/pub/techreports/tr09-04.pdf
> [3] 
> http://www.tao-project.eu/researchanddevelopment/demosanddownloads/RDBToOnto.html
>
> Juan Sequeda, Ph.D Student
> Dept. of Computer Sciences
> The University of Texas at Austin
> www.juansequeda.com <http://www.juansequeda.com>
> www.semanticwebaustin.org <http://www.semanticwebaustin.org>
>
>
> On Mon, Jul 27, 2009 at 11:39 PM, ashok malhotra 
> <ashok.malhotra@oracle.com <mailto:ashok.malhotra@oracle.com>> wrote:
>
>     I'm forwarding your request to the RDB2RDF mailing list.
>     There are many people on this list who are interested in this area
>     and will be able to
>     help you.
>     All the best, Ashok
>
>
>     ticiana linhares wrote:
>
>         Good Afternoon,
>
>         We are students of Federal University of Ceará, Brazil. We are
>         of group Advanced Research in Database and we are looking for
>         a tool for extracting ontologies from E/R diagram or
>         extracting ontologies from relational database. Do you know
>         any tool free that has this feature?
>         Thank you for your attention.
>
>         Cordially,
>
>         -- 
>         Advanced Researchs in Database Group
>         Computing Science
>
>         -- 
>         Ticiana Linhares
>         Ciência da Computação
>
>
>
Also note there is portal re. this information i.e., generating an 
Ontology from a Relational Schema.

Links:

1. http://esw.w3.org/topic/Rdb2RdfXG/StateOfTheArt
2. http://delicious.com/kidehen/rdb2rdf - my collection of links that 
include Virtuoso RDB2RDF functionality (note: this includes a Wizard for 
generating an Ontology and instance data for said ontology from ODBC or 
JDBC accessible Relational Schemas).

-- 


Regards,

Kingsley Idehen	      Weblog: http://www.openlinksw.com/blog/~kidehen
President & CEO 
OpenLink Software     Web: http://www.openlinksw.com
Received on Tuesday, 28 July 2009 13:32:09 GMT

This archive was generated by hypermail 2.2.0+W3C-0.50 : Tuesday, 28 July 2009 13:32:10 GMT