From Protege Wiki
|Type||Tab Widget, Import|
|Last Update||June 24, 2008|
|License||Mozilla Public License.|
DataMaster is a Protege plug-in for importing schema structure and data from relational databases into Protege.
Versions & Compatibility
This section lists available versions of DataMaster.
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!
|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|
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.
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.
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
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-discussion mailing list.
The source code for DataMaster is available from the Protege Subversion repository.
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.