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

RE: relational mapping?

From: Danny Ayers <danny@panlanka.net>
Date: Wed, 9 May 2001 23:07:04 +0600
To: "Andrei S. Lopatenko" <andrei@derpi.tuwien.ac.at>, <www-rdf-interest@w3.org>
Message-ID: <EBEPLGMHCDOJJJPCFHEFIEHNDFAA.danny@panlanka.net>
I'd very much like to hear of your work on this front.

My current idea is to start with a manually concocted RDF file (a rough one
in source.rdf) containing connection details and any info that isn't
machine-obtainable. This is loaded into the system which then automatically
extracts metadata from the database, writing RDF in accordance with an
ontology given in an RDF Schema (rdb-exposed.rdfs). An example of the result
is attached (anrdftest.rdf) along with the SQL to build the tables.

The data I'm putting into the RDF goes from column names (and whether key)
upwards. The plan is to also access to the contained data as XML, backed by
an XML Schema.

There is a very good reason for using RDF - so that reasoning agents of the
semantic web will be able to understand the metadata.

I've got some pretty diagrams from the RDF(S) but unfortunately the ISP I
use is down, though I'll put these online ASAP.

This is a work in progress, BTW ;-)

Cheers,
DAnny.

---
Danny Ayers
http://www.isacat.net

>-----Original Message-----
>From: www-rdf-interest-request@w3.org
>[mailto:www-rdf-interest-request@w3.org]On Behalf Of Andrei S. Lopatenko
>Sent: 04 May 2001 15:02
>To: www-rdf-interest@w3.org
>Subject: Re: relational mapping?
>
>
>> [skipped]
>> > [1] http://www-db.stanford.edu/~melnik/rdf/db.html
>> > [2] http://robustai.net/mentography/SemStructure.gif
>>
>> Neat; but these seem to be "storing RDF in RDBMS" as opposed to
>> "producing RDF from a (legacy?) RDBMS"
>> Actually.
>
>But what we think when we say that we produce RDF represantation
>of RDBMS. Does it mean that we produce isomorphic
>structure or something, representing information in terms table,
>row, column?
>For producing RDF data I currently use some kind of operational
>semantic which allows you to having description of
>RDF schema to describe how data from RDBMS are mapping into RDF.
>If you mean do describe data in RDF in temrs of RDBMS then we can
>use XML work for such aims, which can be done more
>suitable by using RDF
>Standard MDIS allows to describe relational data  in XML
>Best regards
>Andrei S. Lopatenko
>Researcher
>CSTIT RAS
>andreyl@ccas.ru
>alopatenko@hotmail.com
>
>
>


Received on Wednesday, 9 May 2001 13:12:41 GMT

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