ISSUE-48: Mapping SQL datatypes to RDF

sql-datatypes

Mapping SQL datatypes to RDF

State:
CLOSED
Product:
R2RML
Raised by:
Richard Cyganiak
Opened on:
2011-07-06
Description:
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.
Related Actions Items:
Related emails:
  1. Re: ISSUE-69 (datatype sizes): datatype sizes (from eric@w3.org on 2011-10-02)
  2. Re: ISSUE-69 (datatype sizes): datatype sizes (from richard@cyganiak.de on 2011-10-02)
  3. Re: ISSUE-69 (datatype sizes): datatype sizes (from eric@w3.org on 2011-10-01)
  4. Re: ISSUE-69 (datatype sizes): datatype sizes (from richard@cyganiak.de on 2011-09-30)
  5. ISSUE-69 (datatype sizes): datatype sizes (from sysbot+tracker@w3.org on 2011-09-30)
  6. Re: LC publication (from souripriya.das@oracle.com on 2011-09-15)
  7. Re: LC publication (from michael.hausenblas@deri.org on 2011-09-15)
  8. Re: LC publication (from souripriya.das@oracle.com on 2011-09-15)
  9. Re: LC publication (from souripriya.das@oracle.com on 2011-09-15)
  10. Re: LC publication (from michael.hausenblas@deri.org on 2011-09-15)
  11. Re: LC publication (from souripriya.das@oracle.com on 2011-09-15)
  12. Re: LC publication (from souripriya.das@oracle.com on 2011-09-15)
  13. Re: LC publication (from michael.hausenblas@deri.org on 2011-09-15)
  14. Re: LC publication (from souripriya.das@oracle.com on 2011-09-15)
  15. Re: LC publication (from michael.hausenblas@deri.org on 2011-09-15)
  16. Re: LC publication (from michael.hausenblas@deri.org on 2011-09-15)
  17. Re: LC publication (from souripriya.das@oracle.com on 2011-09-15)
  18. Re: LC publication (from michael.hausenblas@deri.org on 2011-09-15)
  19. Re: LC publication (from bvillazon@fi.upm.es on 2011-09-15)
  20. Re: LC publication (from SOURIPRIYA.DAS@oracle.com on 2011-09-14)
  21. Re: LC publication (from bvillazon@fi.upm.es on 2011-09-14)
  22. Re: LC publication (from bvillazon@fi.upm.es on 2011-09-14)
  23. Re: LC publication (from souripriya.das@oracle.com on 2011-09-14)
  24. LC publication (from michael.hausenblas@deri.org on 2011-09-14)
  25. Minutes of 2011-09-13 telecon (from michael.hausenblas@deri.org on 2011-09-13)
  26. Re: RDB2RDF WG agenda for 2011-09-13 meeting 1600 UTC (from bvillazon@fi.upm.es on 2011-09-13)
  27. RDB2RDF WG agenda for 2011-09-13 meeting 1600 UTC (from Michael.Hausenblas@deri.org on 2011-09-12)
  28. Re: Datatype handling added to R2RML spec (ISSUE-29, ISSUE-48, ISSUE-51) (from richard@cyganiak.de on 2011-09-08)
  29. Re: Datatype handling added to R2RML spec (ISSUE-29, ISSUE-48, ISSUE-51) (from dmcneil@revelytix.com on 2011-09-06)
  30. Re: RDB2RDF WG agenda for 2011-09-06 meeting 1600 UTC (from marcelo.arenas1@gmail.com on 2011-09-06)
  31. Re: RDB2RDF WG agenda for 2011-09-06 meeting 1600 UTC (from bvillazon@fi.upm.es on 2011-09-06)
  32. Re: RDB2RDF WG agenda for 2011-09-06 meeting 1600 UTC (from juanfederico@gmail.com on 2011-09-06)
  33. Re: RDB2RDF WG agenda for 2011-09-06 meeting 1600 UTC (from auer@informatik.uni-leipzig.de on 2011-09-06)
  34. RDB2RDF WG agenda for 2011-09-06 meeting 1600 UTC (from michael.hausenblas@deri.org on 2011-09-06)
  35. Re: RDB2RDF WG agenda for 2011-08-30 meeting 1600 UTC (from nuno.lopes@deri.org on 2011-08-30)
  36. Re: RDB2RDF WG agenda for 2011-08-30 meeting 1600 UTC (from privera.salas@gmail.com on 2011-08-30)
  37. Re: RDB2RDF WG agenda for 2011-08-30 meeting 1600 UTC (from marcelo.arenas1@gmail.com on 2011-08-30)
  38. Re: RDB2RDF WG agenda for 2011-08-30 meeting 1600 UTC (from juanfederico@gmail.com on 2011-08-29)
  39. RDB2RDF WG agenda for 2011-08-30 meeting 1600 UTC (from michael.hausenblas@deri.org on 2011-08-29)
  40. Re: Datatype handling added to R2RML spec (ISSUE-29, ISSUE-48, ISSUE-51) (from boris.villazon@deri.org on 2011-08-29)
  41. Re: Datatype handling added to R2RML spec (ISSUE-29, ISSUE-48, ISSUE-51) (from michael.hausenblas@deri.org on 2011-08-26)
  42. Datatype handling added to R2RML spec (ISSUE-29, ISSUE-48, ISSUE-51) (from richard@cyganiak.de on 2011-08-26)
  43. Re: RDB2RDF WG agenda for 2011-08-23 meeting 1600 UTC (from michael.hausenblas@deri.org on 2011-08-23)
  44. Re: RDB2RDF WG agenda for 2011-08-23 meeting 1600 UTC (from marcelo.arenas1@gmail.com on 2011-08-23)
  45. RDB2RDF WG agenda for 2011-08-23 meeting 1600 UTC (from michael.hausenblas@deri.org on 2011-08-23)
  46. RDB2RDF WG agenda for 2011-08-16 meeting 1600 UTC (from michael.hausenblas@deri.org on 2011-08-13)
  47. Re: Datatypes (ISSUE-48) (from richard@cyganiak.de on 2011-08-10)
  48. Re: Datatypes (ISSUE-48) (from nuno.lopes@deri.org on 2011-08-10)
  49. Re: Datatypes (ISSUE-48) (from richard@cyganiak.de on 2011-08-10)
  50. Re: Datatypes (ISSUE-48) (from nuno.lopes@deri.org on 2011-08-10)
  51. Re: Datatypes (ISSUE-48) (from ivan@w3.org on 2011-08-10)
  52. Re: Datatypes (ISSUE-48) (from dmcneil@revelytix.com on 2011-08-10)
  53. Re: Datatypes (ISSUE-48) (from richard@cyganiak.de on 2011-08-10)
  54. Re: Datatypes (ISSUE-48) (from nuno.lopes@deri.org on 2011-08-10)
  55. Re: Datatypes (ISSUE-48) (from ivan@w3.org on 2011-08-10)
  56. Re: Datatypes (ISSUE-48) (from ivan@w3.org on 2011-08-10)
  57. Re: Datatypes (ISSUE-48) (from richard@cyganiak.de on 2011-08-10)
  58. Re: Datatypes (ISSUE-48) (from richard@cyganiak.de on 2011-08-10)
  59. Re: Datatypes (ISSUE-48) (from nuno.lopes@deri.org on 2011-08-10)
  60. Re: Datatypes (ISSUE-48) (from ivan@w3.org on 2011-08-10)
  61. Re: Datatypes (ISSUE-48) (from richard@cyganiak.de on 2011-08-10)
  62. Re: Datatypes (ISSUE-48) (from richard@cyganiak.de on 2011-08-10)
  63. Re: Datatypes (ISSUE-48) (from ivan@w3.org on 2011-08-10)
  64. Re: Datatypes (ISSUE-48) (from nuno.lopes@deri.org on 2011-08-10)
  65. Re: Datatypes (ISSUE-48) (from nuno.lopes@deri.org on 2011-08-10)
  66. Datatypes (ISSUE-48) (from richard@cyganiak.de on 2011-08-09)
  67. Re: Proposal for the Direct Mapping (from eric@w3.org on 2011-08-05)
  68. Re: Proposal for the Direct Mapping (from eric@w3.org on 2011-08-05)
  69. Re: Proposal for the Direct Mapping (from richard@cyganiak.de on 2011-08-04)
  70. Re: Proposal for the Direct Mapping (from juanfederico@gmail.com on 2011-08-03)
  71. Re: Proposal for the Direct Mapping (from eric@w3.org on 2011-08-03)
  72. Re: Proposal for the Direct Mapping (from richard@cyganiak.de on 2011-08-02)
  73. ISSUE-48 (was: Re: ACTION-141) Create a SQL/XSD data dataype mapping (from richard@cyganiak.de on 2011-08-02)
  74. Re: Status of the R2RML document and going last call (from michael.hausenblas@deri.org on 2011-08-02)
  75. Status of the R2RML document and going last call (from richard@cyganiak.de on 2011-08-02)
  76. Re: RDB2RDF WG agenda for 2011-07-19 meeting 1600 UTC (from juanfederico@gmail.com on 2011-07-19)
  77. Re: RDB2RDF WG agenda for 2011-07-19 meeting 1600 UTC (from seema.sundara@oracle.com on 2011-07-19)
  78. Re: RDB2RDF WG agenda for 2011-07-19 meeting 1600 UTC (from marcelo.arenas1@gmail.com on 2011-07-19)
  79. RDB2RDF WG agenda for 2011-07-19 meeting 1600 UTC (from michael.hausenblas@deri.org on 2011-07-19)
  80. Re: Agenda for July 12 Telcon (from michael.hausenblas@deri.org on 2011-07-12)
  81. Re: Agenda for July 12 Telcon (from juanfederico@gmail.com on 2011-07-12)
  82. Re: Agenda for July 12 Telcon (from privera.salas@gmail.com on 2011-07-12)
  83. Re: Agenda for July 12 Telcon (from marcelo.arenas1@gmail.com on 2011-07-12)
  84. Agenda for July 12 Telcon (from ashok.malhotra@oracle.com on 2011-07-09)
  85. Re: ISSUE-48 (sql-datatypes): Mapping SQL datatypes to RDF (from richard@cyganiak.de on 2011-07-08)
  86. Re: ISSUE-48 (sql-datatypes): Mapping SQL datatypes to RDF (from kidehen@openlinksw.com on 2011-07-07)
  87. Re: ISSUE-48 (sql-datatypes): Mapping SQL datatypes to RDF (from richard@cyganiak.de on 2011-07-07)
  88. Re: ISSUE-48 (sql-datatypes): Mapping SQL datatypes to RDF (from kidehen@openlinksw.com on 2011-07-07)
  89. Re: ISSUE-48 (sql-datatypes): Mapping SQL datatypes to RDF (from richard@cyganiak.de on 2011-07-07)
  90. Re: ISSUE-48 (sql-datatypes): Mapping SQL datatypes to RDF (from bertails@w3.org on 2011-07-06)
  91. Re: ISSUE-48 (sql-datatypes): Mapping SQL datatypes to RDF (from bertails@w3.org on 2011-07-06)
  92. Re: ISSUE-48 (sql-datatypes): Mapping SQL datatypes to RDF (from kidehen@openlinksw.com on 2011-07-06)
  93. Re: ISSUE-48 (sql-datatypes): Mapping SQL datatypes to RDF (from kidehen@openlinksw.com on 2011-07-06)
  94. ISSUE-48 (sql-datatypes): Mapping SQL datatypes to RDF (from sysbot+tracker@w3.org on 2011-07-06)

Related notes:

I believe that this is addressed:
http://lists.w3.org/Archives/Public/public-rdb2rdf-wg/2011Aug/0142.html

Richard Cyganiak, 25 Aug 2011, 23:59:05

Resolved as of [1]:

[[
RESOLUTION: Close ISSUE-48 as it is addressed in http://www.w3.org/2001/sw/rdb2rdf/r2rml/#datatype-conversions
]]


[1] http://www.w3.org/2011/09/13-RDB2RDF-minutes.html#item02

Michael Hausenblas, 13 Sep 2011, 17:52:09

Display change log ATOM feed

Ashok Malhotra <ashok.malhotra@oracle.com>, Michael Hausenblas <michael.hausenblas@deri.org>, Chairs, Eric Prud'hommeaux <eric@w3.org>, Ivan Herman <ivan@w3.org>, Staff Contacts
Tracker: documentation, (configuration for this group), originally developed by Dean Jackson, is developed and maintained by the Systems Team <w3t-sys@w3.org>.
$Id: 48.html,v 1.1 2012/10/16 16:28:38 vivien Exp $