Chameleon Metadata OWL-RDF-1: Convert MySQL Database & Dump As RDF Records

1.5.1 NOTE: Since this software was last release in June of 2012, we will update the java MySQL connector .jar file that was included with D2R Server back then

1.5.2 COPY FROM...... D:/d2rq-0.8.1.zip/OWL-RDF-1_mysql-connector-java-5.1.39/mysql-connector-java-5.1.39.jar

1.5.3 PASTE TO......... D:/d2rq-0.8.1.zip/lib/db-drivers/mysql-connector-java-5.1.39.jar

1.6 (OPTIONAL) Download MySQL DDL to Create & Load Learning Lab Tables (ZIP File)

1.6.1 http://ChameleonMetadata.com/Education/Learning_Lab_File_Vault/OWL-RDF-1_Tables-DDL-(MySQL-chameleon_2016_v09).zip

See related topics and documents

http://ChameleonMetadata.com/Education/Learning_Lab_File_Vault/OWL-RDF-1_Tables-DDL-(MySQL-chameleon_2016_v09).zip

1.6.1.1 NOTE: If you would rather connect to one of your existing databases, you can skip this step. But, do update the connector anyway

1.6.2 Execute the SQL statements inside file OWL-RDF-1_Tables-DDL-(MySQL-chameleon_2016_v09).sql

1.6.2.1 NOTE: You made need to make slight changes to the DDL SQL

(i.e. depending on your database, you may need to move all the foreign key constraints to the bottom of the file AFTER the tables have been physically created, etc.)

1.7 NOTE: D2R Server dropped with drivers for MySQL and PostgreSQL (if you use PostgreSQL, you should still update the connector just as we did for MySQL).

1.7.1 NOTE: D2R Server dropped with drivers for MySQL and PostgreSQL (if you use PostgreSQL, you should still update the connector just as we did for MySQL).

1.7.2 For other databases (i.e. Oracle, SQL Server, etc.), just like MySQL, download its DB Connector .jar file and paste it into D:/d2rq-0.8.1.zip/lib/db-drivers

1.7.3 Here is a URL for more information on the D2R Server connectors: http://d2rq.org/generate-mapping#connection

See related topics and documents

http://d2rq.org/generate-mapping#connection

2. PATH - Add D2R Server directory to Windows PATH

2.1 WARNING: DON'T REMOVE ANYTHING FROM YOUR PATH. Just add the D2R Server directory immediately after everything (;D:/d2rq-0.8.1 in this case)

2.2 Add ";D:/d2rq-0.8.1" (no quotes, semicolon in front of the drive letter) to the end of your Windows PATH

3. VERIFY PATH - Verify D2R Server directory is in the Windows PATH

3.1 Open a Windows Command Prompt window (example below uses "D:/d2rq-0.8.1" as the D2R Server's unZIP location)

3.2 Run Command: path

3.3 The directory added in Step B.2 should be at the end - in this case (without quotes): "D:/d2rq-0.8.1"

4. MAP DATABASE - Create a RDF mapping of a MySQL database using D2R Server

4.1 Use the still open Windows Command Prompt which was opened during Step C

4.2 Run Command: D:

4.3 Run Command: cd d2rq-0.8.1

4.4 In this case the command prompt will look like this (without quotes): "D:/d2rq-0.8.1>"

4.5 Run Command: generate-mapping -o your-output-file-name-here.ttl -u your-userid-here -p your-password-here jdbc:mysql://localhost/your-database-name-here

4.5.1 Red Text should be entered as is. And, while not required, you should use .ttl as the output files' suffix as it is common practice for TURTLE files

4.5.2 Black Text should be adjusted according to your specifics

4.5.3 Blue Text shows we will map a MySQL database using the connecter from Step A.5

4.5.3.1 NOTE: For any database other than MySQL you need to do (Step A.3 - A.5) obtaining the correct drivers for your database type.

4.5.3.2 Even though D2R Server drops with MySQL and PostgreSQL connectors, the latest version of D2R is from 2012, so you should definitely update them as I show for MySQL

4.5.3.3 If you are connecting to a different database type, change it accordingly (i.e. copy an Oracle connector at Step A.5 and use jdbc:oracle:// instead)

4.6 Go view the mapping file. In our example and without quotes, the file will be here: "D:/d2rq-0.8.1/your-output-file-name-here.ttl"

5. START D2R SERVER - Start the D2R Server Web Interface

5.1 Use the still open Windows Command Prompt which was opened during Step C

5.2 Run Command: d2r-server your-output-file-name-here.ttl

5.3 View the D2R web interface at: http://localhost:2020

6. DUMP DATABASE - Create a RDF mapping of a MySQL database using D2R Server

6.1 Use the still open Windows Command Prompt opened during Step C

6.2 Run Command: dump-rdf -f RDF/XML -b http://localhost:2020/ your-output-file-name-here.ttl > your-output-file-name-here.rdf

6.2.1 Red Text should be entered as is. And, while not required, you should use .ttl as the output files' suffix as it is common practice for TURTLE files

6.2.2 Black Text should be adjusted according to your specifics

6.2.3 Blue Text shows we will dump in RDF/XML format (the "-f" being the format flag) with records based on the mapping from Step E.3

6.2.3.1 If you DUMP to a different format, I suggest using a different file suffix. Flags and options for D2R Dump are available here: http://d2rq.org/dump-rdf

See related topics and documents

http://d2rq.org/dump-rdf

6.3 Go view the RDF dump file you created in Step F.2. In our example, the file will be here: D:/d2rq-0.8.1/your-output-file-name-here.rdf

7. Mission Accomplished

Top

	Home \| Table of Contents \| Overview Map \| Icon Legend
	OWL-RDF-1: Install and Execute D2R Server
	Send questions or comments to: et@chameleonmetadata.com

©2016 – Dynamic Database Support Systems, Inc. and ChameleonMetadata.com – All Rights Reserved	This website is for educational purposes only and no guarantees or warranty are made for any of its content. By using this website, you agree that our liability for negligence, mistakes, or omissions is limited to an aggregate sum not to exceed $1.00 (one U.S. Dollar), and that you waive all rights to sue for damages for any reason whatsoever
	Last updated: 9/26/2016