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

Re: RDB structure to RDF mapping

From: Alessandro Seganti <a.seganti@cognitum.eu>
Date: Fri, 22 Apr 2016 09:47:16 +0200
Message-ID: <CALEY2L73W91+VKKE1PHBUFg5+ppCXs9-KS9ZdbcWDP4xkAQ0fA@mail.gmail.com>
To: Paul Tyson <phtyson@sbcglobal.net>
Cc: semantic-web@w3.org
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 07:47:48 UTC

This archive was generated by hypermail 2.3.1 : Friday, 22 April 2016 07:47:50 UTC