2008-11-06T03:15:31Z

Lenyabloko: /* Installation */

{{Plugin
|Description=OntoBase is a plug-in that allows Protégé to be used as "Model" and "View" for simple database applications. OntoBase can be simply “snapped on” any relational database to provide access to data, virtually without any programming.
|PluginType=Tab Widget
|PluginType2=Import
|ForApplication1=Protege-Frames
|Screenshot=ontobase.jpg
|HomepageURL=http://www.ontospace.net
|DeveloperID1=Len Yabloko
|LastUpdated=October 26, 2008
|Topic4=Query
|Topic5=Import
|Topic6=Export
|License=MIT License
|Affiliation1=OntoSpace
}}
<div style="float:left;">
== More Details ==

=== Description ===

OntoBase is a plug-in that turns any relational database into ontology. You can define new classes by mapping slots to columns of one or more tables. It allows Protégé to be used as "Model" and "View" for simple database applications. In its current form OntoBase can be simply “snapped on” any relational database to provide access to data, virtually without any programming.

=== Installation ===

The ONTOBaseTab can work with "basic" or "full" installation of Protege 3.x running in JRE 1.5 or higher.
To make sure Protege loads with correct JVM change following line in protege.lax file

<pre><nowiki>lax.nl.current.vm=C:\\Program Files\\Java\\jre1.6.0_04\\bin\\java.exe</nowiki></pre>

1) Extract OntoBase_X.X.X.zip into Protege installation root directory.

2) Open New Project using Protege files(.pont and .pins) or XML file

3) Go to Project->Configure and check ONTOBaseTab box.

4) When OntoBase window appears enter JDBC address of database and click connect button.<br>
Following are some examples of JDBC database URLs:
<pre><nowiki>
jdbc:oracle:thin:@machine_name:port_number:instance_name
jdbc:mysql://host_name:port/dbname
</nowiki></pre>

Note: JDBC driver corresponding to entered URL must be provided either by placing it directly in Protege root directory under name driver0.jar (or driver1.jar, driver2.jar), or by placing it in location specified in following line of protege.lax file

<pre><nowiki>lax.class.path=protege.jar;...;dbdrivers/sqljdbc.jar; dbdrivers/ojdbc6.jar; dbdrivers/mysql-connector-java-5.1.6-bin.jar...</nowiki></pre>

Drivers tested with OntoBase:

http://dev.mysql.com/downloads/connector/j/5.1.html

http://download.oracle.com/otn/utilities_drivers/jdbc/111060/lib/ojdbc6.jar

http://download.microsoft.com/download/b/4/7/b4761c5f-2d80-40dc-aa86-0795c70893e8/Download_SQL_JDBC_Driver_12.htm

5) Wait until connection is established and then click on "run" icon.

Note: If import does not start in a few moments or if it later stops before reaching 100%, then you may need to adjust application memory allocation by editing following line in protege.lax file

<pre><nowiki>lax.nl.java.option.java.heap.size.initial=100000000</nowiki></pre>

The protege.lax file is located in the root directory of your Protege installation

6) After import of database schema is finished OntoBase will re-load and check sign will appear next to imported url.
At this point Protege project will contain "ground" ontology generated by OntoBase with four top level classes:
<pre><nowiki>
:THING
:SYSTEM-CLASS
.TUPLE
~STREAM
@GROUND
=SERVICE
</nowiki></pre>

Note: All top level classes (except ~STREAM) should have sub-classes corresponding to each table in the database.

7) To test generated "ground" ontology simply select any sub-class of @GROUND (each corresponding to a table) and press "create" button on OntoBase tab. You should see a popup asking for primary key of the table. Fill-in the values and close the popup - this should result in fetching a requested row of the table.

8) Now you are ready to use OntoBase for defining entities and relations. To begin find and select a sub-class of =SERVICE that will be used for "seeding" new service. Seed name must always begin with "=" and correspond to a database table containing resulting "output" of some service. With the seed selected in Protege class browser press OntoBase "create" button.
If everything is normal you should see a dialog window asking to use existing entity name (by selecting and pressing "Ok") or to create a new one (by pressing "Cancel"). Then simply follow instructions provided by OntoBase in each newly created class documentation (after reading you can clear or replace it).

<pre><nowiki>If you have any problems or questions contact support@ontospace.net</nowiki></pre>

=== Extending database support ===

Support for database engines can be added or extended by implementing new JDBC protocol adapters. OntoBase distribution now includes Java sources for MySql 5, Oracle 11 and MS SQL 2005 adapters used by ONTOBaseTab.

You can download connectors separately at http://projects.semwebcentral.org/projects/ontobase/