I'm doing a project to transform the Relational Database to RDF database to support the semantic web and ontology.

I found many approached for doing that, and some tools. For who have an experience in that topic.

My question is: what are the current improvements (or gaps) that I can do to improve the transformation process of Relational database to RDF (like transform additional constraints, or store RDF as graph to increase the query performance, or improve the data integration process between relational databases etc)???

Thanks,

asked 31 Jan '13, 10:29

prof's gravatar image

prof
654
accept rate: 0%


I'd like to see a tool that converts relational data (JDBC, ODBC, etc.) to into a correct and compatible N-Triples file(s) that I can feed into triple stores, map/reduce pipelines, etc. The basic mapping should be compatible with

http://www.w3.org/TR/2011/WD-rdb-direct-mapping-20110324/

MOST IMPORTANT: I've seen open source tools that do this, but they create data structures in RAM which grow along with the size of the data set and eventually cause memory exhaustion. The system must process data in a streaming mode and the map/reduce architecture works so well for that.

If you built something like this on top of Hadoop you could certainly build a cluster that could suck up a relational database of the size of the Pentagon's.

This is based on a faith that RDF is the "universal solvent", that it is the best data integration tool, that a combination of databases and logic, rules and queries. We can write rules in the RDF world to match up the hash that comes out of the direct mapping to our point-of-view vocabulary.

permanent link

answered 31 Jan '13, 12:39

database_animal's gravatar image

database_animal ♦
8.4k1612
accept rate: 15%

1

Your link to direct mapping is to an old working draft. Now it's a recommendation and it's at http://www.w3.org/TR/rdb-direct-mapping/.

(02 Feb '13, 14:01) Antoine Zimm... ♦ Antoine%20Zimmermann's gravatar image

Why do you need to transform it? You can keep the relational database and have it generate triples. Just like many millions of websites generate HTML out of their relational database content, you can do the same with RDF. After all, RDF is a resource description, and it doesn't mean you need an RDF database to generate RDF.

permanent link

answered 31 Jan '13, 17:00

Luca%20Matteis's gravatar image

Luca Matteis
1.6k139
accept rate: 13%

Be sure to look into existing open source tools so you can what others have done. For instance, check out this question: "R2RML processor for PostgreSQL databases?"

Also, search this site for R2RML to see what you can learn about it. You'll find other exisitng tools such as Spyder.

permanent link

answered 31 Jan '13, 21:55

harschware's gravatar image

harschware ♦
7.7k1616
accept rate: 20%

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

Question tags:

×885
×69
×9

question asked: 31 Jan '13, 10:29

question was seen: 869 times

last updated: 02 Feb '13, 14:01