ISSUE-18: Allow SQL queries to be reused in a mapping

SQL query reuse

Allow SQL queries to be reused in a mapping

State:
CLOSED
Product:
R2RML
Raised by:
David McNeil
Opened on:
2011-02-01
Description:
Allow SQL queries to be reused in a mapping.

For example, consider the case where several tables must be joined in order
to identify the rows to map. If these rows are to be used in multiple TriplesMaps, then the entire query must be copied.

A possible solution is to allow the SQLQuery property to point to a URI rather than just a string literal.
Related Actions Items:
Related emails:
  1. Re: v.164 has ISSUE-18 resolution related changes (from souripriya.das@oracle.com on 2011-06-15)
  2. Re: v.164 has ISSUE-18 resolution related changes (from bvillazon@fi.upm.es on 2011-06-15)
  3. Re: v.164 has ISSUE-18 resolution related changes (from souripriya.das@oracle.com on 2011-06-15)
  4. v.164 has ISSUE-18 resolution related changes (from souripriya.das@oracle.com on 2011-06-14)
  5. Re: ISSUE-32 resolution implemented (rr:joinCondition) (from me@alexdeleon.name on 2011-05-31)
  6. Re: ISSUE-32 resolution implemented (rr:joinCondition) (from me@alexdeleon.name on 2011-05-25)
  7. Re: ACTION-122: Proposal for ISSUE-18 (from souripriya.das@oracle.com on 2011-05-10)
  8. Re: ACTION-122: Proposal for ISSUE-18 (from michael.hausenblas@deri.org on 2011-05-04)
  9. Re: ACTION-122: Proposal for ISSUE-18 (from dmcneil@revelytix.com on 2011-05-04)
  10. Re: ACTION-122: Proposal for ISSUE-18 (from souripriya.das@oracle.com on 2011-05-04)
  11. Re: ACTION-122: Proposal for ISSUE-18 (from ashok.malhotra@oracle.com on 2011-05-04)
  12. Re: ACTION-122: Proposal for ISSUE-18 (from bertails@w3.org on 2011-05-04)
  13. Re: ACTION-122: Proposal for ISSUE-18 (from me@alexdeleon.name on 2011-05-04)
  14. Re: ACTION-122: Proposal for ISSUE-18 (from ivan@w3.org on 2011-05-04)
  15. Re: ACTION-122: Proposal for ISSUE-18 (from souripriya.das@oracle.com on 2011-05-04)
  16. Re: ACTION-122: Proposal for ISSUE-18 (from souripriya.das@oracle.com on 2011-05-04)
  17. Re: ACTION-122: Proposal for ISSUE-18 (from dmcneil@revelytix.com on 2011-05-04)
  18. Re: ACTION-122: Proposal for ISSUE-18 (from dmcneil@revelytix.com on 2011-05-04)
  19. ACTION-122: Proposal for ISSUE-18 (from me@alexdeleon.name on 2011-05-04)
  20. Re: Agenda for RB2RDF Teleconference Aprrl 26, 2011 (from seema.sundara@oracle.com on 2011-04-26)
  21. Re: Agenda for RB2RDF Teleconference Aprrl 26, 2011 (from souripriya.das@oracle.com on 2011-04-26)
  22. Re: Agenda for RB2RDF Teleconference Aprrl 26, 2011 (from soeren.auer@gmail.com on 2011-04-26)
  23. Re: D2R's many-to-many definition (from michael.hausenblas@deri.org on 2011-04-26)
  24. Re: Agenda for RB2RDF Teleconference Aprrl 26, 2011 (from marcelo.arenas1@gmail.com on 2011-04-26)
  25. D2R's many-to-many definition (from eric@w3.org on 2011-04-26)
  26. Re: Agenda for RB2RDF Teleconference Aprrl 26, 2011 (from michael.hausenblas@deri.org on 2011-04-25)
  27. Agenda for RB2RDF Teleconference Aprrl 26, 2011 (from ashok.malhotra@oracle.com on 2011-04-25)
  28. Minutes of 2011-04-19 telecon (from michael.hausenblas@deri.org on 2011-04-19)
  29. Re: RDB2RDF WG agenda for 2011-03-29 meeting 1600 UTC (from privera.salas@gmail.com on 2011-03-29)
  30. Re: RDB2RDF WG agenda for 2011-03-29 meeting 1600 UTC (from nuno.lopes@deri.org on 2011-03-29)
  31. Re: RDB2RDF WG agenda for 2011-03-29 meeting 1600 UTC (from richard@cyganiak.de on 2011-03-25)
  32. Re: RDB2RDF WG agenda for 2011-03-29 meeting 1600 UTC (from ivan@w3.org on 2011-03-25)
  33. RDB2RDF WG agenda for 2011-03-29 meeting 1600 UTC (from michael.hausenblas@deri.org on 2011-03-25)
  34. Re: SQL in R2RML mappings (from dmcneil@revelytix.com on 2011-02-01)
  35. ISSUE-18 (SQL query reuse): Allow SQL queries to be reused in a mapping [R2RML] (from sysbot+tracker@w3.org on 2011-02-01)

Related notes:

This issue does not need to be addressed for the imminent publication of an updated draft of the R2RML spec.

David McNeil, 22 Mar 2011, 16:25:01

Seema and I had a discussion session and came up with the following proposal:
1) extend rr:SQLQuery to allow values of type IRI as well, and
2) introduce a new property, rr:hasStringValue to associate an IRI with a string.

Typical usage for addressing the requirement identified in this ISSUE would be as follows:

<sqlString1> rr:hasStringValue "Select ... FROM ... WHERE ..." .

<TriplesMap1> rr:SQLQuery <sqlString1> .

<TriplesMap2> rr:SQLQuery <sqlString1> .

Souripriya Das, 3 May 2011, 15:44:51

WG resolved this: http://www.w3.org/2011/06/21-rdb2rdf-minutes.html#item03

Michael Hausenblas, 21 Jun 2011, 16:31:40

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