ISSUE-65: For uniformity and performance, "literal" triples must be always generated for each child table column in a foreign key

For uniformity and performance, "literal" triples must be always generated for each child table column in a foreign key

State:

CLOSED

Product:

Direct Mapping

Raised by:

Souripriya Das

Opened on:

2011-08-09

Description:

The following portion within double quotes is from email [1]:

"
In section 2.1 we are NOT generating a literal triple for the column addr. So, we are only generating:
<People/ID=7> <People#addr> <Addresses/ID=18> .

I would propose that we generate two triples: one literal triple and one IRI triple:
<People/ID=7> <People#addr> "18"^^xsd:integer .
<People/ID=7> <People,Addresses#addr,Id> <Addresses/ID=18> .
"

Currently we are not generating literal columns for column included in a single-column foreign key. This introduces non-uniformity with multi-col foreign key case and introduces need for unnecessary join with the parent table to retrieve the value of the foreign key column.

[1] http://lists.w3.org/Archives/Public/public-rdb2rdf-wg/2011Aug/0055.html

Related Actions Items:

• ACTION-153 on Marcelo Arenas to Draft a solution for ISSUE-65 and send out to WG - due 2011-08-16, closed

Related emails:

1. Re: LC publication (from souripriya.das@oracle.com on 2011-09-15)
2. Re: LC publication (from michael.hausenblas@deri.org on 2011-09-15)
3. Re: LC publication (from souripriya.das@oracle.com on 2011-09-15)
4. Re: LC publication (from souripriya.das@oracle.com on 2011-09-15)
5. Re: LC publication (from michael.hausenblas@deri.org on 2011-09-15)
6. Re: LC publication (from souripriya.das@oracle.com on 2011-09-15)
7. Re: LC publication (from souripriya.das@oracle.com on 2011-09-15)
8. Re: LC publication (from michael.hausenblas@deri.org 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 michael.hausenblas@deri.org 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 bvillazon@fi.upm.es on 2011-09-15)
15. Re: LC publication (from SOURIPRIYA.DAS@oracle.com on 2011-09-14)
16. Re: LC publication (from bvillazon@fi.upm.es on 2011-09-14)
17. Re: LC publication (from bvillazon@fi.upm.es on 2011-09-14)
18. Re: LC publication (from souripriya.das@oracle.com on 2011-09-14)
19. LC publication (from michael.hausenblas@deri.org on 2011-09-14)
20. Minutes of 2011-09-13 telecon (from michael.hausenblas@deri.org on 2011-09-13)
21. Re: RDB2RDF WG agenda for 2011-09-13 meeting 1600 UTC (from bvillazon@fi.upm.es on 2011-09-13)
22. RDB2RDF WG agenda for 2011-09-13 meeting 1600 UTC (from Michael.Hausenblas@deri.org on 2011-09-12)
23. Re: RDB2RDF WG agenda for 2011-09-06 meeting 1600 UTC (from marcelo.arenas1@gmail.com on 2011-09-06)
24. Re: RDB2RDF WG agenda for 2011-09-06 meeting 1600 UTC (from bvillazon@fi.upm.es on 2011-09-06)
25. Re: RDB2RDF WG agenda for 2011-09-06 meeting 1600 UTC (from juanfederico@gmail.com on 2011-09-06)
26. Re: RDB2RDF WG agenda for 2011-09-06 meeting 1600 UTC (from auer@informatik.uni-leipzig.de on 2011-09-06)
27. RDB2RDF WG agenda for 2011-09-06 meeting 1600 UTC (from michael.hausenblas@deri.org on 2011-09-06)
28. Re: Proposal for ISSUE-65 (from tthibodeau@openlinksw.com on 2011-08-30)
29. Re: Proposal for ISSUE-65 (from eric@w3.org on 2011-08-30)
30. Re: Proposal for ISSUE-65 (from richard@cyganiak.de on 2011-08-30)
31. Re: RDB2RDF WG agenda for 2011-08-30 meeting 1600 UTC (from nuno.lopes@deri.org on 2011-08-30)
32. Re: Proposal for ISSUE-65 (from eric@w3.org on 2011-08-30)
33. Re: Proposal for ISSUE-65 (from tthibodeau@openlinksw.com on 2011-08-30)
34. Re: RDB2RDF WG agenda for 2011-08-30 meeting 1600 UTC (from privera.salas@gmail.com on 2011-08-30)
35. Re: RDB2RDF WG agenda for 2011-08-30 meeting 1600 UTC (from marcelo.arenas1@gmail.com on 2011-08-30)
36. Re: RDB2RDF WG agenda for 2011-08-30 meeting 1600 UTC (from juanfederico@gmail.com on 2011-08-29)
37. RDB2RDF WG agenda for 2011-08-30 meeting 1600 UTC (from michael.hausenblas@deri.org on 2011-08-29)
38. Re: Proposal for ISSUE-65 (from juanfederico@gmail.com on 2011-08-29)
39. Re: Proposal for ISSUE-65 (from richard@cyganiak.de on 2011-08-29)
40. Re: Proposal for ISSUE-65 (from eric@w3.org on 2011-08-29)
41. Re: Proposal for ISSUE-65 (from richard@cyganiak.de on 2011-08-29)
42. Re: Proposal for ISSUE-65 (from juanfederico@gmail.com on 2011-08-29)
43. Re: Proposal for ISSUE-65 (from richard@cyganiak.de on 2011-08-29)
44. Re: Proposal for ISSUE-65 (from juanfederico@gmail.com on 2011-08-28)
45. Re: Proposal for ISSUE-65 (from richard@cyganiak.de on 2011-08-28)
46. Re: Proposal for ISSUE-65 (from eric@w3.org on 2011-08-27)
47. Re: Proposal for ISSUE-65 (from juanfederico@gmail.com on 2011-08-25)
48. Re: Proposal for ISSUE-65 (from richard@cyganiak.de on 2011-08-25)
49. Re: Proposal for ISSUE-65 (from juanfederico@gmail.com on 2011-08-25)
50. Re: Proposal for ISSUE-65 (from richard@cyganiak.de on 2011-08-25)
51. Proposal for ISSUE-65 (from juanfederico@gmail.com on 2011-08-23)
52. Re: Addressing ISSUE-64 and ISSUE-65 (from eric@w3.org on 2011-08-23)
53. Re: Addressing ISSUE-64 and ISSUE-65 (from juanfederico@gmail.com on 2011-08-23)
54. Re: Addressing ISSUE-64 and ISSUE-65 (from richard@cyganiak.de on 2011-08-23)
55. Re: RDB2RDF WG agenda for 2011-08-23 meeting 1600 UTC (from michael.hausenblas@deri.org on 2011-08-23)
56. Re: RDB2RDF WG agenda for 2011-08-23 meeting 1600 UTC (from marcelo.arenas1@gmail.com on 2011-08-23)
57. Re: Addressing ISSUE-64 and ISSUE-65 (from eric@w3.org on 2011-08-23)
58. Re: Addressing ISSUE-64 and ISSUE-65 (from richard@cyganiak.de on 2011-08-23)
59. RDB2RDF WG agenda for 2011-08-23 meeting 1600 UTC (from michael.hausenblas@deri.org on 2011-08-23)
60. Re: Addressing ISSUE-64 and ISSUE-65 (from juanfederico@gmail.com on 2011-08-22)
61. Re: Addressing ISSUE-64 and ISSUE-65 (from richard@cyganiak.de on 2011-08-19)
62. Re: Addressing ISSUE-64 and ISSUE-65 (from eric@w3.org on 2011-08-18)
63. Re: Addressing ISSUE-64 and ISSUE-65 (from richard@cyganiak.de on 2011-08-17)
64. Re: Addressing ISSUE-64 and ISSUE-65 (from juanfederico@gmail.com on 2011-08-17)
65. Re: Addressing ISSUE-64 and ISSUE-65 (from michael.hausenblas@deri.org on 2011-08-16)
66. Re: Addressing ISSUE-64 and ISSUE-65 (from eric@w3.org on 2011-08-16)
67. RDB2RDF WG agenda for 2011-08-16 meeting 1600 UTC (from michael.hausenblas@deri.org on 2011-08-13)
68. Re: Re: Addressing ISSUE-64 and ISSUE-65 (from eric@w3.org on 2011-08-10)
69. Re: Addressing ISSUE-64 and ISSUE-65 (from souripriya.das@oracle.com on 2011-08-10)
70. Re: Addressing ISSUE-64 and ISSUE-65 (from richard@cyganiak.de on 2011-08-10)
71. Re: Addressing ISSUE-64 and ISSUE-65 (from dmcneil@revelytix.com on 2011-08-10)
72. Re: Addressing ISSUE-64 and ISSUE-65 (from juanfederico@gmail.com on 2011-08-10)
73. Re: Addressing ISSUE-64 and ISSUE-65 (from richard@cyganiak.de on 2011-08-10)
74. Re: Addressing ISSUE-64 and ISSUE-65 (from juanfederico@gmail.com on 2011-08-10)
75. Re: Addressing ISSUE-64 and ISSUE-65 (from dmcneil@revelytix.com on 2011-08-10)
76. Addressing ISSUE-64 and ISSUE-65 (from juanfederico@gmail.com on 2011-08-10)
77. ISSUE-65: For uniformity and performance, 'literal' triples must be always generated for each child table column in a foreign key (from sysbot+tracker@w3.org on 2011-08-09)

Related notes:

Display change log