W3C home > Mailing lists > Public > semantic-web@w3.org > April 2016

Re: RDB structure to RDF mapping

From: Juan Sequeda <juanfederico@gmail.com>
Date: Fri, 22 Apr 2016 14:19:52 -0500
Message-ID: <CAMVTWDz2ddXPo5N=o0BFovqtk5o+BatEFkLnFJJaN-GRcNyJHg@mail.gmail.com>
To: Alessandro Seganti <a.seganti@cognitum.eu>
Cc: Paul Tyson <phtyson@sbcglobal.net>, Semantic Web <semantic-web@w3.org>
Alessandro,

I think that you are looking for something similar to Relational.OWL:
https://pdfs.semanticscholar.org/cd42/ec9399ff866a589f4f36a4e0c4ea1cf08caf.pdf
http://www.dbs.cs.uni-duesseldorf.de/RDF/relational.owl

To make things compatible with R2RML, what you would have to relate the
classes of your RDB ontology (i.e. ex:Table, ex:Column, etc) to the R2RML
predicates (rr:tableName, rr:column, etc).

It is not really a "standard for this kind of mapping". You want to define
is an ontology that describes the domain of relational database schemas.
Talk about being meta :)

What is your usecase? Why do you want to model the structure of a
relational database schema as RDF? Just curious.




--
Juan Sequeda, Ph.D
+1-575-SEQ-UEDA
www.juansequeda.com

On Fri, Apr 22, 2016 at 2:47 AM, Alessandro Seganti <a.seganti@cognitum.eu>
wrote:

> Thank you all for your answers!
> So if I understood correctly the answer is: there is no standard to deal
> with modeling of the structure of RDBs. I started doing this by using
> instances as it seems to me the simplest way. I am trying to make an
> ontology as much as possible compatible with R2RML but there is not much to
> use apart from logicalTable and a couple of relations.
>
> This said, do you think that is there a reason why none has thought of a
> standard for this kind of mapping? Maybe because in most use cases people
> want to map only specific queries to RDF graphs instead of mapping the
> whole database structure to an RDF graph?
>
> Regards,
> Alessandro
>
> *Alessandro Seganti Ph.D.*
>
> Cognitum Sp. z o.o., *Data Engineer*
>
> mail: a.seganti@cognitum.eu <email@cognitum.eu>, tel: +48 22 250 2541,
> fax: +48 22 250 28 98
>
> web: *http://www.cognitum.eu/ <http://www.cognitum.eu/>*, fb:
> facebook.com/cognitum.eu
>
> On Tue, Apr 19, 2016 at 8:13 PM, Paul Tyson <phtyson@sbcglobal.net> wrote:
>
>> On Mon, 2016-04-18 at 17:25 +0200, Alessandro Seganti wrote:
>> > Hi everyone,
>> > I want to formalize in RDF the table structure of a relational
>> > database. What I would like to do is to formalize the links that
>> > exists between all the tables inside a given relational database. This
>> > would result in a graph where the nodes are the tables and the links
>> > are the columns that can be used to join these tables.
>> >
>> >
>> > My question is: is there some standard/ontology to describe this?
>> >
>> >
>> > To my understanding the R2RML ontology is to describe mappings between
>> > RDB and RDF (no RDB structure is mentioned). I also found a document
>> > about direct mapping but no ontology is defined in this document.
>> >
>>
>> When the RDB2RDF WG was working I suggested including an RDB ontology.
>> But it was considered out of scope so nothing of the sort was included
>> in their final deliverables.
>>
>> http://lists.w3.org/Archives/Public/public-rdb2rdf-wg/2010Oct/0055.html
>>
>> My work didn't (and doesn't) involve RDBMS deeply enough to pursue this,
>> so I don't know how valuable this would be for practical tasks.
>>
>> Regards,
>> --Paul
>> >
>> >
>> >
>> > Thank you for your help.
>> > Alessandro Seganti Ph.D.
>> >
>> > Cognitum Sp. z o.o., Data Engineer
>> >
>> > mail: a.seganti@cognitum.eu, tel: +48 22 250 2541, fax: +48 22 250 28
>> > 98
>> >
>> > web: http://www.cognitum.eu/, fb: facebook.com/cognitum.eu
>> >
>> >
>>
>>
>>
>
Received on Friday, 22 April 2016 19:20:39 UTC

This archive was generated by hypermail 2.3.1 : Friday, 22 April 2016 19:20:43 UTC