- From: Kingsley Idehen <kidehen@openlinksw.com>
- Date: Thu, 07 Jul 2011 13:43:24 +0100
- To: Alexandre Bertails <bertails@w3.org>
- CC: public-rdb2rdf-wg@w3.org
On 7/6/11 2:26 PM, Alexandre Bertails wrote: > 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. > > > If you want, you can present SQL type mappings to XSD from one of the following: 1. ANSI SQL 2. ODBC 3. JDBC. -- 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 Thursday, 7 July 2011 12:44:01 UTC