Difference between revisions of "DataMaster"

From Protege Wiki
Jump to: navigation, search
m
(Level of Support)
 
(4 intermediate revisions by 2 users not shown)
Line 34: Line 34:
 
A good overview of the functionality of the DataMaster plug-in is available in the [http://protege.stanford.edu/conference/2007/presentations/10.01_Nyulas.pdf abstract for the presentation about DataMaster] at the [http://protege.stanford.edu/conference/2007/index.html 10th International Protege Conference].
 
A good overview of the functionality of the DataMaster plug-in is available in the [http://protege.stanford.edu/conference/2007/presentations/10.01_Nyulas.pdf abstract for the presentation about DataMaster] at the [http://protege.stanford.edu/conference/2007/index.html 10th International Protege Conference].
  
More documentation to come very-very soon.
+
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 <code>mysql-connector-java-5.1.6-bin.jar</code> for MySQL) in the <br>
 +
&nbsp;&nbsp;&nbsp;&nbsp; <code> [PROTEGE_INSTALLATION_DIR]/plugins/edu.stanford.smi.protegex.datamaster </code> <br>
 +
directory and restart Protege.<br>
 +
In the DataMaster plug-in you will need to specify the full '''class name''' of the JDBC driver (for example <code>com.mysql.jdbc.Driver</code> for MySQL).
 +
 
 +
DataMaster comes with the <code>sun.jdbc.odbc.JdbcOdbcDriver</code>, 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 | xlSQL-Y8 driver]].
 
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 | xlSQL-Y8 driver]].
Line 40: Line 46:
 
== Level of Support  ==
 
== Level of Support  ==
  
Please post questions about the DataMaster plug-in to the [https://mailman.stanford.edu/mailman/listinfo/protege-discussion protege-discussion] or [https://mailman.stanford.edu/mailman/listinfo/protege-discussion  protege-discussion] mailing lists.
+
Please post questions about DataMaster on the [https://mailman.stanford.edu/mailman/listinfo/protege-user protege-user] mailing list.
  
 
The [http://smi-protege.stanford.edu/repos/protege/datamaster/trunk/ source code] for DataMaster is available from the Protege Subversion repository.
 
The [http://smi-protege.stanford.edu/repos/protege/datamaster/trunk/ source code] for DataMaster is available from the Protege Subversion repository.

Latest revision as of 01:38, July 11, 2014

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.

Versions & Compatibility

This section lists available versions of DataMaster.

VersionCompatible withDependencies
DataMaster 1.3.2Protege-OWL 3.4.2
Protege-Frames 3.4.2
Protege-OWL 3.4
Protege-Frames 3.4
Protege-OWL
DataMaster 1.3.1Protege-OWL 3.4.1
Protege-Frames 3.4.1
Protege-OWL 3.4
Protege-Frames 3.4
Protege-OWL
DataMaster 1.3Protege-OWL
DataMaster 1.2.1Protege-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.2Protege-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

VersionChanges in this version
DataMaster 1.3.2see page for more details
DataMaster 1.3.1see page for more details
DataMaster 1.3see page for more details
DataMaster 1.2.1see page for more details
DataMaster 1.2see page for more details
DataMaster 1.0initial 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.