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

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.

-- 

Regards,

Kingsley Idehen 
President&  CEO
OpenLink Software
Web: http://www.openlinksw.com
Weblog: http://www.openlinksw.com/blog/~kidehen
Twitter/Identi.ca: kidehen

Received on Wednesday, 6 July 2011 12:26:31 UTC