- From: Kingsley Idehen <kidehen@openlinksw.com>
- Date: Thu, 07 Jul 2011 21:22:35 +0100
- To: public-rdb2rdf-wg@w3.org
On 7/7/11 7:37 PM, Richard Cyganiak wrote: > Hi Kingsley, > > On 7 Jul 2011, at 13:43, Kingsley Idehen wrote: >> If you want, you can present SQL type mappings to XSD from one of the following: >> >> 1. ANSI SQL >> 2. ODBC >> 3. JDBC. > Can you share some experience regarding their relative importance for our work? Which of them reflects most closely what you see in the common RDBMS implementations? > > Best, > Richard > Richard, ODBC is the best basis for a collection SQL Types since all ODBC Drivers (provided by 3rd parties or RDBMS vendors) map to these from RDBMS specific types. Thus, if you need a collection of types for mapping to XSD you can grabs those used by ODBC. ODBC and JDBC are basically the standard SQL call level interfaces to all RDBMS engines. Their mappings [1] to ANSI SQL are also very clean. Links: 1. http://msdn.microsoft.com/en-us/library/ms710150(v=VS.85).aspx -- ODBC SQL 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 Thursday, 7 July 2011 20:23:00 UTC