ISSUE-22: Support for database vendor specific SQL statements.

vendor specific SQL

Support for database vendor specific SQL statements.

State:
CLOSED
Product:
R2RML
Raised by:
David McNeil
Opened on:
2011-02-01
Description:
Allow database vendor specific SQL statements to be embedded in R2RML mappings.

For example, this is needed if a mapping needs to use an Oracle specific statement that cannot be parsed as standard SQL.

A possible solution is to allow SQL statements to be flagged as "opaque".
This would indicate that the statements are not to be parsed by the mapping
tool, but simply passed down to the underlying database.

I interpret this statement in section 1.3 of the R2RML spec to preclude the use of vendor specific SQL:

"In places where SQL expressions are allowed, these *MUST* conform to Core
SQL 2008."
Related Actions Items:
No related actions
Related emails:
  1. Re: ACTION-133, ISSUE-22 (from eric@w3.org on 2011-07-05)
  2. Re: ACTION-133, ISSUE-22 (from richard@cyganiak.de on 2011-07-05)
  3. Re: ACTION-133, ISSUE-22 (from richard@cyganiak.de on 2011-06-21)
  4. Re: ACTION-133, ISSUE-22 (from eric@w3.org on 2011-06-21)
  5. Re: ACTION-133, ISSUE-22 (from richard@cyganiak.de on 2011-06-21)
  6. Re: ACTION-133, ISSUE-22 (from eric@w3.org on 2011-06-21)
  7. Re: ACTION-133, ISSUE-22 (from richard@cyganiak.de on 2011-06-21)
  8. Re: ACTION-133, ISSUE-22 (from michael.hausenblas@deri.org on 2011-06-21)
  9. ACTION-133, ISSUE-22 (from eric@w3.org on 2011-06-21)
  10. Minutes of 2011-06-14 telecon (from michael.hausenblas@deri.org on 2011-06-14)
  11. Re: Agenda for June 14 Telcon - Revision 1 (from franconi@inf.unibz.it on 2011-06-14)
  12. Re: Agenda for June 14 Telcon - Revision 1 (from marcelo.arenas1@gmail.com on 2011-06-14)
  13. Re: Agenda for June 14 Telcon - Revision 1 (from ashok.malhotra@oracle.com on 2011-06-13)
  14. Re: Agenda for June 14 Telcon (from juanfederico@gmail.com on 2011-06-13)
  15. Agenda for June 14 Telcon (from ashok.malhotra@oracle.com on 2011-06-13)
  16. Re: Re-opening ISSUE-22 on vendor-specific SQL (from richard@cyganiak.de on 2011-06-02)
  17. Re: Re-opening ISSUE-22 on vendor-specific SQL (from eric@w3.org on 2011-06-02)
  18. Re: Re-opening ISSUE-22 on vendor-specific SQL (from richard@cyganiak.de on 2011-06-02)
  19. Re: Re-opening ISSUE-22 on vendor-specific SQL (from eric@w3.org on 2011-06-01)
  20. Re: Re-opening ISSUE-22 on vendor-specific SQL (from richard@cyganiak.de on 2011-06-01)
  21. Re: Re-opening ISSUE-22 on vendor-specific SQL (from eric@w3.org on 2011-06-01)
  22. Re: Re-opening ISSUE-22 on vendor-specific SQL (from dmcneil@revelytix.com on 2011-06-01)
  23. Re: Re-opening ISSUE-22 on vendor-specific SQL (from richard@cyganiak.de on 2011-06-01)
  24. Re: Re-opening ISSUE-22 on vendor-specific SQL (from richard@cyganiak.de on 2011-06-01)
  25. Re: Re-opening ISSUE-22 on vendor-specific SQL (from eric@w3.org on 2011-06-01)
  26. Re: Re-opening ISSUE-22 on vendor-specific SQL (from ivan@w3.org on 2011-06-01)
  27. Re: Re-opening ISSUE-22 on vendor-specific SQL (from dmcneil@revelytix.com on 2011-06-01)
  28. Re: Re-opening ISSUE-22 on vendor-specific SQL (from ashok.malhotra@oracle.com on 2011-06-01)
  29. Re: Re-opening ISSUE-22 on vendor-specific SQL (from richard@cyganiak.de on 2011-06-01)
  30. Re: Re-opening ISSUE-22 on vendor-specific SQL (from dmcneil@revelytix.com on 2011-06-01)
  31. Re: Re-opening ISSUE-22 on vendor-specific SQL (from ivan@w3.org on 2011-06-01)
  32. Re: Re-opening ISSUE-22 on vendor-specific SQL (from dmcneil@revelytix.com on 2011-06-01)
  33. Re: Re-opening ISSUE-22 on vendor-specific SQL (from richard@cyganiak.de on 2011-05-31)
  34. Re: Re-opening ISSUE-22 on vendor-specific SQL (from dmcneil@revelytix.com on 2011-05-31)
  35. Re: Re-opening ISSUE-22 on vendor-specific SQL (from richard@cyganiak.de on 2011-05-31)
  36. Re: Re-opening ISSUE-22 on vendor-specific SQL (from dmcneil@revelytix.com on 2011-05-31)
  37. Re: Re-opening ISSUE-22 on vendor-specific SQL (from richard@cyganiak.de on 2011-05-31)
  38. Re: Re-opening ISSUE-22 on vendor-specific SQL (from dmcneil@revelytix.com on 2011-05-31)
  39. Re: Re-opening ISSUE-22 on vendor-specific SQL (from eric@w3.org on 2011-05-31)
  40. Re: Re-opening ISSUE-22 on vendor-specific SQL (from dmcneil@revelytix.com on 2011-05-31)
  41. Re: Proposal to resolve ISSUE-22 'vendor specific SQL' (from michael.hausenblas@deri.org on 2011-05-31)
  42. Proposal to resolve ISSUE-22 'vendor specific SQL' (from richard@cyganiak.de on 2011-05-30)
  43. Re-opening ISSUE-22 on vendor-specific SQL (from richard@cyganiak.de on 2011-05-30)
  44. Issues mentioned in R2RML draft (from richard@cyganiak.de on 2011-03-22)
  45. Re: Minutes of 2011-03-15 telecon (from eric@w3.org on 2011-03-17)
  46. Re: R2RML: publishing the second draft (from bvillazon@fi.upm.es on 2011-03-17)
  47. Re: R2RML: publishing the second draft (from me@alexdeleon.name on 2011-03-16)
  48. Re: R2RML: publishing the second draft (from rscanlon@revelytix.com on 2011-03-15)
  49. Re: R2RML: publishing the second draft (from bvillazon@fi.upm.es on 2011-03-15)
  50. Minutes of 2011-03-15 telecon (from michael.hausenblas@deri.org on 2011-03-15)
  51. Re: RDB2RDF WG agenda for 2011-03-15 meeting 1600 UTC (from bvillazon@fi.upm.es on 2011-03-15)
  52. Re: RDB2RDF WG agenda for 2011-03-15 meeting 1600 UTC (from juanfederico@gmail.com on 2011-03-15)
  53. Re: R2RML: publishing the second draft (from rscanlon@revelytix.com on 2011-03-15)
  54. Re: RDB2RDF WG agenda for 2011-03-15 meeting 1600 UTC (from marcelo.arenas1@gmail.com on 2011-03-15)
  55. Re: R2RML: publishing the second draft (from me@alexdeleon.name on 2011-03-15)
  56. RDB2RDF WG agenda for 2011-03-15 meeting 1600 UTC (from michael.hausenblas@deri.org on 2011-03-15)
  57. Re: R2RML: publishing the second draft (from bvillazon@fi.upm.es on 2011-03-15)
  58. R2RML: publishing the second draft (from souripriya.das@oracle.com on 2011-03-14)
  59. Re: RDB2RDF WG agenda for 2011-03-08 meeting 1700 UTC (from michael.hausenblas@deri.org on 2011-03-08)
  60. Re: RDB2RDF WG agenda for 2011-03-08 meeting 1700 UTC (from bertails@w3.org on 2011-03-07)
  61. RDB2RDF WG agenda for 2011-03-08 meeting 1700 UTC (from michael.hausenblas@deri.org on 2011-03-06)
  62. Re: SQL in R2RML mappings (from dmcneil@revelytix.com on 2011-02-01)
  63. ISSUE-22 (vendor specific SQL): Support for database vendor specific SQL statements. [R2RML] (from sysbot+tracker@w3.org on 2011-02-01)

Related notes:

Re-opening, as it is mentioned as open in the R2RML draft, I cannot recall a resolution, and no resolution is recorded in the last couple of emails.

Richard Cyganiak, 30 May 2011, 10:12:06

Resolution:
http://lists.w3.org/Archives/Public/public-rdb2rdf-wg/2011Jun/0088.html

[[
RESOLUTION: Re ISSUE-22 the WG decides to introduce an OPTIONAL
attribute. if attribute is present, we assume it's a specific dialect.
if attribute is absent, we do not know what dialect it is. we only
specify the behaviour of R2RML where the attribute says it's SQL-2008.
]]

Implementation in the Editor's Draft:
http://lists.w3.org/Archives/Public/public-rdb2rdf-wg/2011Jul/0007.html

Richard Cyganiak, 5 Jul 2011, 19:29:23

Closing per working group telecon discussion.

David McNeil, 19 Jul 2011, 16:39:20

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: 22.html,v 1.1 2012/10/16 16:28:35 vivien Exp $