Re: ISSUE-48 (sql-datatypes): Mapping SQL datatypes to RDF

On Wed, 2011-07-06 at 13:25 +0100, Kingsley Idehen wrote:
> On 7/6/11 1:11 PM, RDB2RDF Working Group Issue Tracker wrote:
> > ISSUE-48 (sql-datatypes): Mapping SQL datatypes to RDF
> >
> > http://www.w3.org/2001/sw/rdb2rdf/track/issues/48
> >
> > Raised by: Richard Cyganiak
> > On product:
> >
> > Neither R2RML nor the Direct Mapping currently specify how exactly SQL types are mapped to RDF.
> >
> > To address this, a careful comparison of standard SQL types and XSD types is required.
> >
> > Part of this problem is the question of vendor-specific types. Most databases use vendor-specific types. Their treatment (even if it is: ignore these columns) has to be specified.
> >
> >
> >
> >
> 
> A little clearer:
> 
> Map ANSI SQL Types to XSD Types.
> 
> Stay away from the vendor specific stuff. Leave those implementing R2RML 
> to handle DBMS vendor SQL type mapping to ANSI SQL and from there to XSD 
> types.
> 

I agree it's gonna be difficult (if possible) to map any SQL datatype.
But some datatypes are available everywhere. These should be part of the
Direct Mapping.

Alexandre.

Received on Wednesday, 6 July 2011 13:26:21 UTC