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

RE: Storing RDF in a relational database

From: Danny Ayers <danny.ayers@btinternet.com>
Date: Mon, 18 Jun 2001 22:16:45 +0100
To: "Aaron Swartz" <aswartz@upclink.com>
Cc: "RDF-Interest" <www-rdf-interest@w3.org>
Message-ID: <EBEPLGMHCDOJJJPCFHEFGEJADKAA.danny.ayers@btinternet.com>
I've had a look at the SWAP (I assume you're meaning the internals of cwm)
but still haven't grokked what's going on with the _ids - perhaps you could
help me with an example, what would go in the various fields with the (all
too familiar ;-)example below.

Cheers,
Danny.

<?xml version="1.0"?>
<rdf:RDF
  xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#"
  xmlns:s="http://description.org/schema/">
  <rdf:Description about="http://www.w3.org/Home/Lassila">
    <s:Creator>Ora Lassila</s:Creator>
  </rdf:Description>
</rdf:RDF>



>-----Original Message-----
>From: Aaron Swartz [mailto:aswartz@upclink.com]
>Sent: 18 June 2001 21:52
>To: Danny Ayers
>Cc: RDF-Interest
>Subject: Re: Storing RDF in a relational database
>
>
>On Monday, June 18, 2001, at 03:31  PM, Danny Ayers wrote:
>
>> What tables/columns/relationships?
>
>It's pretty plain right now:
>
>CREATE TABLE statements (
>        context          text,
>        context_id       int2,
>        predicate        text,
>        predicate_id     int2,
>        subject          text,
>        subject_id       int2,
>        object           text,
>        object_id        int2
>);
>
>The IDs correspond to the constants in the SWAP stuff --
>LITERAL, RESOURCE, FORMULA, ANONYMOUS, etc.
>
>--
>[ "Aaron Swartz" ; <mailto:me@aaronsw.com> ; <http://www.aaronsw.com/> ]
Received on Monday, 18 June 2001 17:42:49 GMT

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