Training:Advanced Ontology Engineering at FOI - 2011/Reengineering

From Odp

Revision as of 14:33, 3 October 2011 (view source) EvaBlomqvist (Talk | contribs) ← Previous diff		Revision as of 14:41, 3 October 2011 (view source) EvaBlomqvist (Talk | contribs) Next diff →
Line 11:		Line 11:
	host: mysql315.loopia.se		host: mysql315.loopia.se
		+
	user name: d2r@o45820		user name: d2r@o45820
		+
	password: (given at the course)		password: (given at the course)
		+
	database name: ontology_se_db_2		database name: ontology_se_db_2
		+
		+	Content: The database contains information about a past ISWC conference, and in one table called "persons" there is information about the people that organized or attended the conference.
		+
		+
		+	'''Task 1:'''
		+
		+	Your task is to use Semion to express this data in terms of the FOAF vocabulary, at the following URI: foaf="http://xmlns.com/foaf/0.1/
		+
		+
		+	=== Using D2R ===
		+
		+	Now, you should try to use D2R to instead create a runtime mapping to the DB, so that you can query the DB using SPARQL.
		+
		+	'''Task 2:'''
		+
		+	Use the same database as above, and run the following tutorial:
		+	http://sw.cs.technion.ac.il/d2rq/tutorial
		+
		+	The example data is already loaded into the database, but you have to edit the example mapping to reflect the details of the database above. Then you can run the D2R server (with the mapping file in the same directory) and try accessing the DB through SPARQL in your browser.

---

Revision as of 14:41, 3 October 2011

Tutorial	Training:Advanced Ontology Engineering at FOI - 2011
Title	Reengineering

Solutions:

Reengineering and Refactoring using Semion

In this exercise you will use the Semion tool to reengieer a database table from an example database into RDF, and then to refactor it so that the data is expressed using the FOAF vocabulary.

The database:

host: mysql315.loopia.se

user name: d2r@o45820

password: (given at the course)

database name: ontology_se_db_2

Content: The database contains information about a past ISWC conference, and in one table called "persons" there is information about the people that organized or attended the conference.

Task 1:

Your task is to use Semion to express this data in terms of the FOAF vocabulary, at the following URI: foaf="http://xmlns.com/foaf/0.1/

Using D2R

Now, you should try to use D2R to instead create a runtime mapping to the DB, so that you can query the DB using SPARQL.

Task 2:

Use the same database as above, and run the following tutorial: http://sw.cs.technion.ac.il/d2rq/tutorial

The example data is already loaded into the database, but you have to edit the example mapping to reflect the details of the database above. Then you can run the D2R server (with the mapping file in the same directory) and try accessing the DB through SPARQL in your browser.