I have data in MySQL and I want to convert it into RDF. How can I do this? Should I write my own code for this conversion?

(After this conversion I am going to fire SPARQL queries over the RDF, and I am also going to combine two different RDF graphs to get the result of my query.)

asked 03 Jan '13, 06:33

rrk's gravatar image

rrk
194
accept rate: 0%

edited 03 Jan '13, 13:10

Signified's gravatar image

Signified ♦
23.7k1623

Near-duplicate of: "Converting existing relational data to RDF/OWL"

http://answers.semanticweb.com/questions/2020/converting-existing-relational-data-to-rdfowl

(03 Jan '13, 13:09) Signified ♦ Signified's gravatar image

R2RML would be the recommended generic method of creating such mappings, then you can use any of the tools out there like Virtuoso, D2R Server, Spyder or other supporting R2RML to perform the mapping ...

link

answered 03 Jan '13, 09:27

HughWilliams's gravatar image

HughWilliams
941
accept rate: 33%

I second R2RML. If you use C# go ahead and try http://r2rml.net. NOTE: I'm it's creator. NOTE2: It's very new and possibly unpolished. You have been warned :)

(04 Jan '13, 06:16) Tomasz Plusk... Tomasz%20Pluskiewicz's gravatar image

http://www.w3.org/2001/sw/rdb2rdf/ and projects such as http://d2rq.org/ should be helpful - there should be some similar questions with pointers to other similar projects (eg. spyder)

link

answered 03 Jan '13, 06:39

Sweet%20Burlap's gravatar image

Sweet Burlap
2.7k38
accept rate: 18%

Should I write my own code for this conversion?

No, there is a method of automatic RDB to RDF mapping called Direct Mapping where you don't even need to write any mapping rules explicitly. However, one drawback is that you can't really customize the data model of the generated RDF data. There are slides explaining Direct Mapping in detail on this link. Moreover, D2RQ already supports Direct Mapping.

link

answered 10 Feb '13, 18:08

fadirra's gravatar image

fadirra
1.2k310
accept rate: 21%

edited 10 Feb '13, 18:10

Instead of writing your own, you should consider D2RQ on a D2R server - see SPARQL on SQL Experiences.

link

answered 11 Feb '13, 04:49

scotthenninger's gravatar image

scotthenninger ♦
7.5k813
accept rate: 17%

Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "Title")
  • image?![alt text](/path/img.jpg "Title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Tags:

×866
×9
×9

Asked: 03 Jan '13, 06:33

Seen: 1,907 times

Last updated: 11 Feb '13, 04:49