Difference between revisions of "DataMaster"
Holger Lewen (talk | contribs) |
(→Level of Support) |
||
| (14 intermediate revisions by 4 users not shown) | |||
| Line 1: | Line 1: | ||
| − | {{Plugin| | + | {{Plugin |
| − | + | |Description=DataMaster is a Protege plug-in for importing schema structure and data from relational databases into Protege. | |
| − | + | |PluginType=Tab Widget | |
| − | + | |PluginType2=Import | |
| − | + | |ForApplication1=Protege-Frames | |
| − | + | |ForApplication2=Protege-OWL | |
| − | + | |Screenshot=DataMaster_screenshot.png | |
| − | + | |DeveloperID1=Csongor Nyulas | |
| − | + | |LastUpdated=June 24, 2008 | |
| − | + | |Topic1=Import | |
| − | + | |License=Mozilla Public License. | |
| − | + | |Affiliation1=Stanford Medical Informatics | |
| + | |Affiliation2=Stanford University | ||
| + | }} | ||
| − | + | <div style="width:100%;float:left;"> | |
| − | <div style="float:left;"> | + | == Description == |
| − | ==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. | 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. | ||
| Line 20: | Line 21: | ||
Part of the rationale for developing DataMaster was that existing Protege plug-ins such as [http://protege.cim3.net/cgi-bin/wiki.pl?DataGenie DataGenie] do not support OWL ontologies or schema-only imports. | Part of the rationale for developing DataMaster was that existing Protege plug-ins such as [http://protege.cim3.net/cgi-bin/wiki.pl?DataGenie 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 [http://protege.cim3.net/cgi-bin/wiki.pl?SQWRL 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 [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]. | ||
| + | |||
| + | 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> | ||
| + | <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]]. | ||
| − | == | + | == Level of Support == |
| − | + | 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. | |
| + | == 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 [http://protege.cim3.net/cgi-bin/wiki.pl?DataGenie DataGenie] plug-in, parts of which were adopted by DataMaster. | ||
</div> | </div> | ||
Latest revision as of 00:38, July 11, 2014
DataMaster
| 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.
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.
