How do people go about mapping their existing data into an ontology? I must be missing something very basic here.

I have identified an OWL ontology that (for the most part) covers the data in my database but I am confused as to how to build the triples. Is this normally a manual process? Should I be writing code to run through my existing data and build the triples one by one or are there tools out there to do this type of thing?

I keep thinking that I should be able to find something that lays out my ontology (i.e. Protege) on one side and my db schema on the other and let me connect the two to generate the triples.

Can someone point me to any reference material in regards to how to do this as my head is killing me from banging it against this wall.

asked 22 Oct '10, 03:50

Marc%201's gravatar image

Marc 1
accept rate: 0%

edited 03 Jan '13, 13:22

Signified's gravatar image

Signified ♦

Also have a look at this related question: http://www.semanticoverflow.com/questions/1898/how-to-use-large-databases-in-semantic-web-applications/1900#1900

(25 Oct '10, 07:31) Jeen Broekstra ♦ Jeen%20Broekstra's gravatar image


The W3C RDB2RDF Working Group works on this very topic.

Their stated goals are

To examine and classify existing approaches to mapping relational data into RDF [...]

To examine and classify existing approaches to mapping OWL classes to Relational data, or, more accurately, SQL queries [...]

The earlier Incubator Group published a report here and here.

If like me, you're somewhat impatient, try seeing if D2RQ or Triplify meet your requirements. A detailed breakdown of other options are in the report above.

permanent link

answered 22 Oct '10, 04:02

Signified's gravatar image

Signified ♦
accept rate: 37%

edited 22 Oct '10, 17:11


I think you mean the RDB2RDF WG? The incubator finished last year. http://www.w3.org/2001/sw/rdb2rdf/

(22 Oct '10, 09:48) Comment Bot Comment%20Bot's gravatar image

Doh. I knew that too. Momentary lapse of brain function. Cheers.

(22 Oct '10, 17:12) Signified ♦ Signified's gravatar image
Your answer
toggle preview

Follow this question

By Email:

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



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:


question asked: 22 Oct '10, 03:50

question was seen: 2,662 times

last updated: 03 Jan '13, 13:22