DataMaster

From Protege Wiki

Jump to: navigation, search

DataMaster

by Csongor Nyulas

Screenshot

Type Tab Widget, Import
Author(s) Csongor Nyulas
Last Update June 24, 2008
License Mozilla Public License.
Homepage not available
For Application
Topic(s)
Affiliation

DataMaster is a Protege plug-in for importing schema structure and data from relational databases into Protege.

Contents


Versions & Compatibility

This section lists available versions of DataMaster.

Version Compatible with Dependencies
DataMaster 1.3.2 Protege-OWL 3.4.2
Protege-Frames 3.4.2
Protege-OWL 3.4
Protege-Frames 3.4
Protege-OWL
DataMaster 1.3.1 Protege-OWL 3.4.1
Protege-Frames 3.4.1
Protege-OWL 3.4
Protege-Frames 3.4
Protege-OWL
DataMaster 1.3 Protege-OWL
DataMaster 1.2.1 Protege-OWL 3.4
Protege-OWL 3.3.1
Protege-OWL 3.2.1
Protege-OWL 2.1.2
Protege-Frames 3.4
Protege-Frames 3.3.1
Protege-Frames 3.2.1
Protege-Frames 2.1.2
Protege-OWL
DataMaster 1.2 Protege-OWL 3.4
Protege-OWL 3.3.1
Protege-Frames 3.4
Protege-Frames 3.3.1
DataMaster 1.0

If you click on the button below to add a new version of DataMaster, you will be asked to define a page title for the new version. Please adhere to the naming convention of DataMaster X.X.X when you define the new page!

Changelog

Version Changes in this version
DataMaster 1.3.2 see page for more details
DataMaster 1.3.1 see page for more details
DataMaster 1.3 see page for more details
DataMaster 1.2.1 see page for more details
DataMaster 1.2 see page for more details
DataMaster 1.0 initial version - no changelog available


Description

DataMaster is a Protege plug-in for importing schema structure and data from relational databases into Protege. DataMaster supports both OWL and frame-based ontologies and can be used with any relational database with JDBC/ODBC drivers.

Part of the rationale for developing DataMaster was that existing Protege plug-ins such as DataGenie do not support OWL ontologies or schema-only imports.

This plug-in is NOT a database back-end. The typical use-case for this plug-in is importing legacy data into Protege before doing additional knowledge acquisition or knowledge modeling. This plug-in currently does not include any capability for moving data in the opposite direction, i.e., from Protege classes and instances into a relational database. Another use-case for this plug-in might be to import a database schema as classes or instances in the ontology which may be later used to dynamically query the content of the database using SQWRL queries. DataMaster could be also used as a database viewer. For efficiency, a database might be stored as a set of custom-designed database tables, but then DataMaster could be used to view portions of the schema from within Protege user interface.

Installation

DataMaster is bundled with the "full" installation of Protege (versions 3.3.1 and higher).

For instructions related to JDBC driver installation please read the Documentation section below.

Documentation

A good overview of the functionality of the DataMaster plug-in is available in the abstract for the presentation about DataMaster at the 10th International Protege Conference.

In order to access a database using a specific JDBC driver, you have to put the JAR file containing the JDBC driver in your classpath. The most convenient way to realize this is to put the JAR file containing the JDBC driver (for example mysql-connector-java-5.1.6-bin.jar for MySQL) in the
     [PROTEGE_INSTALLATION_DIR]/plugins/edu.stanford.smi.protegex.datamaster
directory and restart Protege.
In the DataMaster plug-in you will need to specify the full class name of the JDBC driver (for example com.mysql.jdbc.Driver for MySQL).

DataMaster comes with the sun.jdbc.odbc.JdbcOdbcDriver, which can be used to connect to ODBC data sources, and with the MySQL JDBC drivers by default.

DataMaster can be also used to import database schema and data from MS Excel spreadsheets, by using an enhanced version of the xlSQL JDBC driver. For instructions please read the special wiki page created for the xlSQL-Y8 driver.

Level of Support

Please post questions about DataMaster on the protege-user mailing list.

The source code for DataMaster is available from the Protege Subversion repository.

Acknowledgements

This work was supported by the Centers for Disease Control and Prevention under grant number SPO-34603. We would also like to acknowledge the DataGenie plug-in, parts of which were adopted by DataMaster.


Personal tools