ISSUE-9: Generate Blank Nodes for duplicate tuples bn_directmapping Generate Blank Nodes for duplicate tuples State: OPEN Product: [22]Direct Mapping Raised by: [23]Juan Sequeda Opened on: 2011-01-21 Description: Given a table that does not have a primary key, which has duplicate tuples, a different blank node must be created for each tuple. In the Direct Mapping as rules section of the Direct Mapping document, we described this scenario by using all the values of the tuple to create the blank node [$1\47] [$1\47]. However, there is a bug, raised by Alexandre [$1\47]. The issue is that datalog cannot deal with duplicate. Consequently, Marcelo raised the point that we can use simple versions of datalog that can deal with duplicate solutions. Possible solutions: 1) assume that each table implicitly has a row id which is part of its set of attributes. The row id is unique. 2) associates to each tuple an annotation that corresponds to the multiplicity of the tuple in the database. This annotation function corresponds to the function card in the definition of the semantics of SPARQL [$1\47] [24]http://www.w3.org/TR/2010/WD-rdb-direct-mapping-20101118/ #rules_table_triples_no_pk [$1\47] [25]http://www.w3.org/TR/2010/WD-rdb-direct-mapping-20101118/ #rules_literal_triples_no_pk [$1\47] [26]http://lists.w3.org/Archives/Public/public-rdb2rdf-wg/201 1Jan/0044.html [24] http://www.w3.org/TR/2010/WD-rdb-direct-mapping-20101118/#rules_table_triples_no_pk [25] http://www.w3.org/TR/2010/WD-rdb-direct-mapping-20101118/#rules_literal_triples_no_pk [26] http://lists.w3.org/Archives/Public/public-rdb2rdf-wg/2011Jan/0044.html Related Actions Items: No related actions Related emails: 1. [27]Minutes of 2011-03-08 telecon (from michael.hausenblas@deri.org on 2011-03-08) 2. [28]Re: RDB2RDF WG agenda for 2011-03-08 meeting 1700 UTC (from michael.hausenblas@deri.org on 2011-03-08) 3. [29]Re: RDB2RDF WG agenda for 2011-03-08 meeting 1700 UTC (from bertails@w3.org on 2011-03-07) 4. [30]RDB2RDF WG agenda for 2011-03-08 meeting 1700 UTC (from michael.hausenblas@deri.org on 2011-03-06) 5. [31]Minutes of 2011-03-01 telecon (from michael.hausenblas@deri.org on 2011-03-01) 6. [32]Re: Test cases to check (from ivan@w3.org on 2011-02-03) 7. [33]Re: ISSUE-9 Another question about Generate Blank Nodes (from phayes@ihmc.us on 2011-02-02) 8. [34]Re: Test cases to check (from eric@w3.org on 2011-02-02) 9. [35]Fwd: Re: ISSUE-9 Another question about Generate Blank Nodes (from souripriya.das@oracle.com on 2011-02-02) 10. [36]Re: ISSUE-9 Another question about Generate Blank Nodes (from ivan@w3.org on 2011-02-02) 11. [37]Re: ISSUE-9 Another question about Generate Blank Nodes (from ivan@w3.org on 2011-02-02) 12. [38]Re: ISSUE-9 Another question about Generate Blank Nodes (from eric@w3.org on 2011-02-02) 13. [39]Re: ISSUE-9 Another question about Generate Blank Nodes (from auer@informatik.uni-leipzig.de on 2011-02-02) 14. [40]Re: ISSUE-9 Another question about Generate Blank Nodes (from SOURIPRIYA.DAS@oracle.com on 2011-02-01) 15. [41]Re: ISSUE-9 Another question about Generate Blank Nodes (from eric@w3.org on 2011-02-01) 16. [42]Re: ISSUE-9 Another question about Generate Blank Nodes (from bertails@w3.org on 2011-02-01) 17. [43]Re: ISSUE-9 Another question about Generate Blank Nodes (from ashok.malhotra@oracle.com on 2011-02-01) 18. [44]Re: ISSUE-9 Another question about Generate Blank Nodes (from bertails@w3.org on 2011-02-01) 19. [45]Re: ISSUE-9 Another question about Generate Blank Nodes (from auer@informatik.uni-leipzig.de on 2011-02-01) 20. [46]Re: Test cases to check (from eric@w3.org on 2011-02-01) 21. [47]Re: Test cases to check (from ivan@w3.org on 2011-02-01) 22. [48]Test cases to check (from bvillazon@fi.upm.es on 2011-02-01) 23. [49]Re: ISSUE-9 Another question about Generate Blank Nodes (from juanfederico@gmail.com on 2011-01-31) 24. [50]Re: ISSUE-9 Another question about Generate Blank Nodes (from eric@w3.org on 2011-01-31) 25. [51]ISSUE-9 Another question about Generate Blank Nodes (from juanfederico@gmail.com on 2011-01-31) 26. [52]Re: ISSUE-9 (bn_directmapping): Generate Blank Nodes for duplicate tuples [Direct Mapping] (from juanfederico@gmail.com on 2011-01-31) 27. [53]ISSUE-9 (bn_directmapping): Generate Blank Nodes for duplicate tuples [Direct Mapping] (from sysbot+tracker@w3.org on 2011-01-21) [27] http://www.w3.org/mid/316ADBDBFE4F4D4AA4FEEF7496ECAEF90557EF9B%2540EVS1.ac.nuigalway.ie [28] http://www.w3.org/mid/C5996532-0249-4930-AC02-50EF7C2B943D%2540deri.org [29] http://www.w3.org/mid/1299557844.2740.2.camel%2540simplet [30] http://www.w3.org/mid/64FDBE52-D3B0-42A2-BBC1-43B0ACACED31%2540deri.org [31] http://www.w3.org/mid/4CE3DB4C-1E7A-42D6-8429-C0BB878648C8%2540deri.org [32] http://www.w3.org/mid/DDC03D3D-7FE4-43B4-AF85-009BE828A9DE%2540w3.org [33] http://www.w3.org/mid/C9BFF8FA-2F1D-42E4-B87D-B5F3B36D57C9%2540ihmc.us [34] http://www.w3.org/mid/20110203032322.GA7042%2540w3.org [35] http://www.w3.org/mid/4D49D24F.9020902%2540oracle.com [36] http://www.w3.org/mid/33C0520D-96A3-487A-B579-EC50871FCA55%2540w3.org [37] http://www.w3.org/mid/C43A565A-5B09-4D7B-B4B9-5DFDB8C3260C%2540w3.org [38] http://www.w3.org/mid/20110202051418.GE2894%2540w3.org [39] http://www.w3.org/mid/4D489851.9090506%2540informatik.uni-leipzig.de [40] http://www.w3.org/mid/cdf6e7ca-6592-4d51-8282-a279bb6ddba1%2540default [41] http://www.w3.org/mid/20110202011620.GD2894%2540w3.org [42] http://www.w3.org/mid/1296603995.26739.351.camel%2540simplet [43] http://www.w3.org/mid/4D489850.80209%2540oracle.com [44] http://www.w3.org/mid/1296600889.26739.341.camel%2540simplet [45] http://www.w3.org/mid/4D488517.3030805%2540informatik.uni-leipzig.de [46] http://www.w3.org/mid/20110201170229.GB2894%2540w3.org [47] http://www.w3.org/mid/8CEED7BD-8431-4BD4-BD09-8A1603F7F50A%2540w3.org [48] http://www.w3.org/mid/4D476B0F.1050101%2540fi.upm.es [49] http://www.w3.org/mid/AANLkTimoOjuGwGSA71maepRr-bqey27zX%253D81nHmZfF9%253D%2540mail.gmail.com [50] http://www.w3.org/mid/20110131193416.GD27056%2540w3.org [51] http://www.w3.org/mid/AANLkTin%253D6g4M%252Bt9D19PPXA0jVowf_J5bq-WA1YuL3ZKJ%2540mail.gmail.com [52] http://www.w3.org/mid/AANLkTikXF5OA_w5gpG2%252B6fWfT05o3kvDQPFUmsa06hLj%2540mail.gmail.com [53] http://www.w3.org/mid/E1PgNnV-0007re-MN%2540stu.w3.org