[protege-discussion] FW: Ontology using mysql

[Jonathan Carter]

I assume that you are interested in querying the MySQL database  
directly, rather than just looking for the database to provide the  
persistence for your ontology?

Just to cover off the simpler scenario, Protege can use MySQL (or any  
JDBC database) to store your ontology rather than the project files. I  
should point out that my experience is mostly with Protege Frames (for  
which this is the discussion mail group) and Protege OWL could vary  
slightly.
To use what's called the "database backend" you simply create a user  
for Protege in MySQL, an empty database for which the Protege user has  
full rights, and then use the File->Convert Project To... and select  
the Protege Database option. Complete the form with the details of the  
username, password, database name etc. and Protege will create a  
single table in which the entire knowledge base is written into.
This works very well - particularly for large ontologies but querying  
that table using SQL is not straightforward as the contents are really  
in terms of Protege's own meta-meta model. There are some threads and  
I believe some documentation on the wiki about querying this, though.

Taking the other scenario, if you already have many (or all!) of your  
classes and instances defined in a MySQL database, you can try using  
the DataMaster tab to convert that database into a Protege Ontology.  
This works very well, and will be very straight-forward if your  
Protege ontology is empty.
If you are looking to import ontology information into an existing  
ontology in Protege (i.e. import more classes or more instances that  
you have captured in MySQL) then you can still use DataMaster to bring  
them in but you will have to do some work with the imported instances  
to move them into the existing classes that you have as required.

Hope this helps

Regards

Jonathan

_______________________________________

Jonathan Carter - Head of Technical Architecture
Enterprise Architecture Solutions Ltd
_______________________________________


Proud sponsors of The Essential Project.
The free open-source Enterprise Architecture Management Platform
www.enterprise-architecture.org
_______________________________________

On 19 Jun 2009, at 04:54, S G wrote:

>
>
> From: nvme_06 at hotmail.com
> To: protege-discussion at lists.stanford.edu
> Subject: Ontology using mysql
> Date: Thu, 18 Jun 2009 23:47:32 -0400
>
> Hello,
>
> I am new to using protege. Are there any articles and examples on  
> how to create a mysql database using owl ontology? I had created a  
> database using mysql with the tables that are classes in my  
> ontology. I am not sure if that is correct or if I need to create a  
> blank database and then connect it to protege and it will dump all  
> the classes, individuals, slots and etc into mysql. Any help will be  
> appreciated.  Thanks.
>
> Lauren found her dream laptop. Find the PC that’s right for you.
> Insert movie times and more without leaving Hotmail®. See  
> how._______________________________________________
> protege-discussion mailing list
> protege-discussion at lists.stanford.edu
> https://mailman.stanford.edu/mailman/listinfo/protege-discussion
>
> Instructions for unsubscribing: http://protege.stanford.edu/doc/faq.html#01a.03

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mailman.stanford.edu/pipermail/protege-discussion/attachments/20090623/9e965de2/attachment.html>