ISSUE-64: Predicate IRI design for foreign key does not handle common cases where same column sequence may be used for multiple foreign key constraints

Predicate IRI design for foreign key does not handle common cases where same column sequence may be used for multiple foreign key constraints

State:
CLOSED
Product:
Direct Mapping
Raised by:
Souripriya Das
Opened on:
2011-08-09
Description:
See the description in email [1] for a proposal.

Multiple foreign keys may use the same sequence of columns in the child table. Design for the predicate IRI corresponding to a foreign key, therefore, must include: 1) child table 2) sequence of columns in the child table 3) parent table 4) sequence of columns in the parent table.

Current design does not include the third and fourth item. Thus common cases cannot be handled by current predicate IRI design for foreign keys.

[1] http://lists.w3.org/Archives/Public/public-rdb2rdf-wg/2011Aug/0053.html
Related Actions Items:
Related emails:
  1. Minutes of 2011-08-23 telecon (from michael.hausenblas@deri.org on 2011-08-23)
  2. Re: Addressing ISSUE-64 and ISSUE-65 (from eric@w3.org on 2011-08-23)
  3. Re: Addressing ISSUE-64 and ISSUE-65 (from juanfederico@gmail.com on 2011-08-23)
  4. Re: Addressing ISSUE-64 and ISSUE-65 (from richard@cyganiak.de on 2011-08-23)
  5. Re: RDB2RDF WG agenda for 2011-08-23 meeting 1600 UTC (from michael.hausenblas@deri.org on 2011-08-23)
  6. Re: RDB2RDF WG agenda for 2011-08-23 meeting 1600 UTC (from marcelo.arenas1@gmail.com on 2011-08-23)
  7. Re: Addressing ISSUE-64 and ISSUE-65 (from eric@w3.org on 2011-08-23)
  8. Re: Addressing ISSUE-64 and ISSUE-65 (from richard@cyganiak.de on 2011-08-23)
  9. RDB2RDF WG agenda for 2011-08-23 meeting 1600 UTC (from michael.hausenblas@deri.org on 2011-08-23)
  10. Re: Addressing ISSUE-64 and ISSUE-65 (from juanfederico@gmail.com on 2011-08-22)
  11. Re: Addressing ISSUE-64 and ISSUE-65 (from richard@cyganiak.de on 2011-08-19)
  12. Re: Addressing ISSUE-64 and ISSUE-65 (from eric@w3.org on 2011-08-18)
  13. Re: Addressing ISSUE-64 and ISSUE-65 (from richard@cyganiak.de on 2011-08-17)
  14. Re: Addressing ISSUE-64 and ISSUE-65 (from juanfederico@gmail.com on 2011-08-17)
  15. Re: Addressing ISSUE-64 and ISSUE-65 (from michael.hausenblas@deri.org on 2011-08-16)
  16. Re: Addressing ISSUE-64 and ISSUE-65 (from eric@w3.org on 2011-08-16)
  17. RDB2RDF WG agenda for 2011-08-16 meeting 1600 UTC (from michael.hausenblas@deri.org on 2011-08-13)
  18. Re: Re: Addressing ISSUE-64 and ISSUE-65 (from eric@w3.org on 2011-08-10)
  19. Re: Addressing ISSUE-64 and ISSUE-65 (from souripriya.das@oracle.com on 2011-08-10)
  20. Re: Addressing ISSUE-64 and ISSUE-65 (from richard@cyganiak.de on 2011-08-10)
  21. Re: Addressing ISSUE-64 and ISSUE-65 (from dmcneil@revelytix.com on 2011-08-10)
  22. Re: Addressing ISSUE-64 and ISSUE-65 (from juanfederico@gmail.com on 2011-08-10)
  23. Re: Addressing ISSUE-64 and ISSUE-65 (from richard@cyganiak.de on 2011-08-10)
  24. Re: Addressing ISSUE-64 and ISSUE-65 (from juanfederico@gmail.com on 2011-08-10)
  25. Re: Addressing ISSUE-64 and ISSUE-65 (from dmcneil@revelytix.com on 2011-08-10)
  26. Addressing ISSUE-64 and ISSUE-65 (from juanfederico@gmail.com on 2011-08-10)
  27. ISSUE-64: Predicate IRI design for foreign key does not handle common cases where same column sequence may be used for multiple foreign key constraints [Direct Mapping] (from sysbot+tracker@w3.org on 2011-08-09)

Related notes:

Resolved as per 2011-08-23 [1]:

[[
RESOLUTION: Address ISSUE-64 by adding a note to the DM spec: "in the case of multiple FKs over the same sequence of columns, the DM generates the same property IRI" and close the issue
]]

[1] http://www.w3.org/2011/08/23-rdb2rdf-minutes.html#item04

Michael Hausenblas, 23 Aug 2011, 17:08:35

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