Re: Populate an owl ontology with mysql database

2013-05-19 Thread Diogo FC Patrao
>
> It's a java portal on a Tomcat server, maybe D2RQ could help me to define
> mappings and populate my owl ontology. Is that the right way to do that?
>
>
D2R can create a default mapping, but you'll end with one class per table,
and one property per column. If you need to map your relational db to
anything different, you'll need to customize the mapping file by hand.

good luck!

dfcp


>
> --
> David DE LA PEÑA
>
>
> On Sun, May 19, 2013 at 3:27 PM, Rob Walpole 
> wrote:
>
> > David,
> >
> > I would suggest using something like D2RQ to dump your data as RDF. You
> may
> > be able to get the mapping you want from this but if not, load it into
> TDB
> > and run some SPARQL transforms (constructs) to get it how you want it.
> >
> > Rob
> > On May 19, 2013 11:58 AM, "David De La Peña"  wrote:
> >
> > > Hello,
> > > could I use Jena to populate individuals form a mysql db to an owl
> > > ontology?
> > >
> > > Thank you,
> > >
> > > --
> > > David DE LA PEÑA
> > >
> >
>


Re: Populate an owl ontology with mysql database

2013-05-19 Thread David De La Peña
Thank you!
It seems to do want I want.

To explain what I'm doing : I've first create an ontology (owl file with
Protege 4) and now I am developing a web portal referring to this ontology
( but not directly linked to it ).
Now I want to display in this web portal the ontology populated with the
individuals that are stored in the portal db.

My Goal is to visualize in a web page of the portal, the ontology and his
individuals (populated dynamically from the portal db) using semantic
queries.

It's a java portal on a Tomcat server, maybe D2RQ could help me to define
mappings and populate my owl ontology. Is that the right way to do that?


-- 
David DE LA PEÑA


On Sun, May 19, 2013 at 3:27 PM, Rob Walpole  wrote:

> David,
>
> I would suggest using something like D2RQ to dump your data as RDF. You may
> be able to get the mapping you want from this but if not, load it into TDB
> and run some SPARQL transforms (constructs) to get it how you want it.
>
> Rob
> On May 19, 2013 11:58 AM, "David De La Peña"  wrote:
>
> > Hello,
> > could I use Jena to populate individuals form a mysql db to an owl
> > ontology?
> >
> > Thank you,
> >
> > --
> > David DE LA PEÑA
> >
>


Re: Populate an owl ontology with mysql database

2013-05-19 Thread Rob Walpole
David,

I would suggest using something like D2RQ to dump your data as RDF. You may
be able to get the mapping you want from this but if not, load it into TDB
and run some SPARQL transforms (constructs) to get it how you want it.

Rob
On May 19, 2013 11:58 AM, "David De La Peña"  wrote:

> Hello,
> could I use Jena to populate individuals form a mysql db to an owl
> ontology?
>
> Thank you,
>
> --
> David DE LA PEÑA
>


Re: Populate an owl ontology with mysql database

2013-05-19 Thread Diogo FC Patrao
Hello David

Not sure how your data is arranged on MySQL, but have a look on D2R (
http://d2rq.org/), which maps relational data to RDF.

cheers

--
diogo patrão




On Sun, May 19, 2013 at 7:57 AM, David De La Peña  wrote:

> Hello,
> could I use Jena to populate individuals form a mysql db to an owl
> ontology?
>
> Thank you,
>
> --
> David DE LA PEÑA
>


Re: Populate an owl ontology with mysql database

2013-05-19 Thread David De La Peña
Hello,
could I use Jena to populate individuals form a mysql db to an owl ontology?

Thank you,

-- 
David DE LA PEÑA