W3C home > Mailing lists > Public > www-rdf-interest@w3.org > May 2001

Re: relational mapping?

From: Seth Russell <seth@robustai.net>
Date: Thu, 3 May 2001 08:55:06 -0700
Message-ID: <010001c0d3e9$6e53cbc0$b17ba8c0@c1457248a.sttls1.wa.home.com>
To: "Jan Grant" <Jan.Grant@bristol.ac.uk>, "Danny Ayers" <danny@panlanka.net>
Cc: "Www-Rdf-Logic" <www-rdf-logic@w3.org>, "RDF-Interest" <www-rdf-interest@w3.org>
From: "Jan Grant" <Jan.Grant@bristol.ac.uk>

> On Thu, 3 May 2001, Danny Ayers wrote:
>
> > Has anyone come across a mapping of the relational model to RDF? I'm
sure
> > there's a pretty direct one possible at a low level (tuple to tuple I
> > suppose), but it'll save me some thought and a lot of time if someone's
> > already looked into this. Alternatively, if there's an RDFS around that
> > contains RDBMS terms (schema, table, column etc) I'd very much like to
hear
> > about it. I'm wanting to operate at this latter level, but it would be
nice
> > to be on firm foundations.
>
> I've done quite a bit of thinking about it; got some paper notes which
> I'm in the (slow) process of typing up. You're right, there's a simple
> mechanical mapping of rows in a table to RDF; what you lose by this is
> the natural linking of properties.
>
> For a sufficiently normalised relational schema*, you can generally
> produce a mapping
> (primary key) -> resource
> (other values) -> properties
> (foreign key) -> link to resource representing primary key for
> foreign table
>

No doubt you are aware of the list of these recorded at [1], to which list I
have added the structure diagrammed at [2].

[1] http://www-db.stanford.edu/~melnik/rdf/db.html
[2] http://robustai.net/mentography/SemStructure.gif

Seth
Received on Thursday, 3 May 2001 12:01:20 GMT

This archive was generated by hypermail 2.2.0+W3C-0.50 : Monday, 7 December 2009 10:51:49 GMT