16:58:26 RRSAgent has joined #rdb2rdf 16:58:26 logging to http://www.w3.org/2010/03/02-rdb2rdf-irc 16:58:28 RRSAgent, make logs world 16:58:28 Zakim has joined #rdb2rdf 16:58:30 Zakim, this will be 7322733 16:58:30 ok, trackbot; I see SW_RDB2RDF()12:00PM scheduled to start in 2 minutes 16:58:31 Meeting: RDB2RDF Working Group Teleconference 16:58:31 Date: 02 March 2010 16:58:41 whalb has joined #rdb2rdf 16:58:47 Agenda: http://lists.w3.org/Archives/Public/public-rdb2rdf-wg/2010Mar/0000.html 16:58:56 Chair: Ahmed 16:59:07 iv_an_ru: are you ready to scribe? 16:59:18 RRSAgent, draft minutes 16:59:18 I have made the request to generate http://www.w3.org/2010/03/02-rdb2rdf-minutes.html mhausenblas 16:59:24 rrsagent, make logs public 16:59:32 Marcelo has joined #rdb2rdf 16:59:38 regrets+ Seema 16:59:56 Zakim, cygri is with mhausenblas 16:59:56 sorry, mhausenblas, I do not recognize a party named 'mhausenblas' 17:00:09 Ahmed has joined #RDB2RDF 17:00:57 li_ma has joined #rdb2rdf 17:01:06 hhalpin seems iv_an_ru can't make it - can you scribe, please? 17:01:58 Ashok has joined #rdb2rdf 17:02:06 Zakim, cygri is with mhausenblas 17:02:06 sorry, mhausenblas, I do not recognize a party named 'mhausenblas' 17:02:10 Zakim, this is 7322733 17:02:11 ok, MacTed; that matches SW_RDB2RDF()12:00PM 17:02:19 Zakim, cygri is with mhausenblas 17:02:19 + +49.322.222.0.aabb 17:02:19 +[IPcaller.a] 17:02:21 +cygri; got it 17:02:24 Zakim, nunolopes is with mhausenblas 17:02:25 +nunolopes; got it 17:02:25 + +1.603.897.aacc 17:02:27 something didn't start right ... 17:02:31 Zakim, who's here? 17:02:31 On the phone I see [IPcaller], whalb, +1.562.249.aaaa, juansequeda, ??P27, OpenLink_Software, mhausenblas, [IPcaller.a], +49.322.222.0.aabb, +1.603.897.aacc 17:02:34 mhausenblas has mhausenblas, cygri, nunolopes 17:02:35 scribenick: hhalpin 17:02:36 On IRC I see Ashok, li_ma, Ahmed, Marcelo, whalb, Zakim, RRSAgent, cygri, angela_UNITN, juansequeda, hhalpin, mhausenblas, MacTed, LeeF, nunolopes, iv_an_ru, trackbot, ericP 17:02:40 Zakim, OpenLink_Software is temporarily me 17:02:42 Zakim, mute me 17:02:43 rrsagent, draft minutes 17:02:43 I have made the request to generate http://www.w3.org/2010/03/02-rdb2rdf-minutes.html mhausenblas 17:02:45 +MacTed; got it 17:02:47 MacTed should now be muted 17:02:47 soeren has joined #RDB2RDF 17:02:59 Souri has joined #rdb2rdf 17:03:03 + +39.046.128.aadd 17:03:05 +Ashok_Malhotra 17:03:23 zakim, who is on the phone? 17:03:23 On the phone I see [IPcaller], whalb, +1.562.249.aaaa, juansequeda, ??P27, MacTed (muted), mhausenblas, [IPcaller.a], +49.322.222.0.aabb, +1.603.897.aacc, +39.046.128.aadd, 17:03:27 ... Ashok_Malhotra 17:03:29 mhausenblas has mhausenblas, cygri, nunolopes 17:03:41 Zakim, please dial ericP 17:03:42 I am sorry, ericP; I do not know a number for ericP 17:03:44 zakim, aacc is Souri 17:03:44 +Souri; got it 17:03:46 +??P51 17:03:48 Zakim, please dial ericP-office 17:03:50 ok, ericP; the call is being made 17:03:52 Zakim, ??P51 is hhalpin 17:03:52 +EricP 17:04:00 +hhalpin; got it 17:04:21 Topic: Admin 17:04:41 zakim, who is on the phone? 17:04:41 On the phone I see [IPcaller], whalb, +1.562.249.aaaa, juansequeda, ??P27, MacTed (muted), mhausenblas, [IPcaller.a], +49.322.222.0.aabb, Souri, +39.046.128.aadd, Ashok_Malhotra, 17:04:44 ... hhalpin, EricP 17:04:45 mhausenblas has mhausenblas, cygri, nunolopes 17:04:48 +??P45 17:06:26 BenSzekely has joined #RDB2RDF 17:06:27 PROPOSAL: accept minutes http://www.w3.org/2010/02/23-rdb2rdf-minutes.html 17:06:31 thanks! 17:06:39 +1 17:06:47 ACCEPTED: as minutes Feb 23rd: http://www.w3.org/2010/02/23-rdb2rdf-minutes.html 17:06:57 Open actions http://www.w3.org/2001/sw/rdb2rdf/track/actions/open 17:07:08 ACTION-19? 17:07:08 ACTION-19 -- Harry Halpin to put Souri's draft into a WBS poll and notify the WG -- due 2010-01-19 -- OPEN 17:07:08 http://www.w3.org/2001/sw/rdb2rdf/track/actions/19 17:07:32 Souri, what that's a draft of? 17:07:42 Souri: describe the SQL approach 17:07:55 ... what is the SQL-based approach? 17:08:05 ... relevance of the action has been taken of 17:08:06 juansequeda, any interest in working with the FeDeRate code? 17:08:23 ... working as a sub-groups already 17:08:27 ... to note differences 17:08:38 close ACTION-19 17:08:38 ACTION-19 Put Souri's draft into a WBS poll and notify the WG closed 17:08:46 ericP, lets talk afterwards 17:09:01 ACTION-28? 17:09:01 ACTION-28 -- Harry Halpin to check on dependencies with non-free ISO -- due 2010-03-02 -- OPEN 17:09:01 http://www.w3.org/2001/sw/rdb2rdf/track/actions/28 17:09:27 done by Harry, see http://lists.w3.org/Archives/Public/public-rdb2rdf-wg/2010Feb/0028.html 17:09:51 ACTION-28? 17:09:51 ACTION-28 -- Harry Halpin to check on dependencies with non-free ISO -- due 2010-03-02 -- CLOSED 17:09:51 http://www.w3.org/2001/sw/rdb2rdf/track/actions/28 17:10:09 ACTION-29? 17:10:09 ACTION-29 -- Eric Prud'hommeaux to create Wiki page for RDF team and link from homepage -- due 2010-03-02 -- OPEN 17:10:09 http://www.w3.org/2001/sw/rdb2rdf/track/actions/29 17:10:47 ACTION-29? 17:10:47 ACTION-29 -- Eric Prud'hommeaux to create Wiki page for RDF team and link from homepage -- due 2010-03-09 -- OPEN 17:10:47 http://www.w3.org/2001/sw/rdb2rdf/track/actions/29 17:10:50 -> http://www.w3.org/2010/02/09-RDB2RDF-minutes Feb 09 minutes 17:11:54 ericP: old minutes from last week, approved last meeting 17:12:07 thanks a lot for this, ericP 17:12:08 ... : Do we have a wiki-page for the SQL team? 17:12:23 soeren: so far we have a wiki page, its a bit unorganized 17:12:35 ... but basically its the same ideas, trying to align our syntax 17:12:38 http://www.w3.org/2001/sw/rdb2rdf/wiki/RDB-to-RDF_mapping:_A_SQL-based_Approach 17:12:51 ... so then our goals can be merged and aligned. 17:12:53 http://www.w3.org/2001/sw/rdb2rdf/wiki/R2RML_SQL_View_Annotation 17:13:14 ericP: trying to figure out what to put in this page 17:13:17 q+ 17:13:23 ack hhalpin 17:14:05 http://dvcs.w3.org/hg/FeDeRate/file/636ceb7f6d4d/src/test/scala/SparqlToSparqlToSqlTest.scala#l83 17:14:14 http://dvcs.w3.org/hg/FeDeRate/file/636ceb7f6d4d/src/test/scala/SparqlToSparqlToSqlTest.scala#l83 17:14:31 hhalpin: we'd just need an English-language spec-like text for the code that is under development 17:14:51 ericP: I'm happy to document 17:14:57 ... test-cases are the most important 17:14:59 +1 test cases 17:15:03 -> http://dvcs.w3.org/hg/FeDeRate/file/636ceb7f6d4d/src/test/scala/SparqlToSparqlToSqlTest.scala#l72 test case 17:15:12 -> http://dvcs.w3.org/hg/FeDeRate/file/636ceb7f6d4d/src/test/scala/SparqlToSparqlToSqlTest.scala#l83 resulting view 17:15:52 Souri: We want a mapping portion description without looking at query, so for example, D2RQ used some mappings. 17:16:20 ... I don't see it or it's not very prominent 17:16:28 ericP: line 72, line 80 17:17:02 val view = toView(List(hr2foaf), HR, StemURI("http://hr.example/DB/")) 17:17:04 angela has joined #RDB2RDF 17:17:34 ericP: we just take stem URI and map the SPARQL query to SQL 17:17:50 -??P45 17:18:27 juansequada: yes, that's very close to Ultrawrap 17:19:13 +[IPcaller.aa] 17:19:16 ericP: is this consistent for the expressivity we need?, re ultrawrap and/or tripify? 17:19:44 thats pretty different from what we have in mind 17:20:51 soeren: we don't have a triple table, we have a sql table 17:20:57 ... not just a view, just the base table 17:21:03 ... this is the most common-case 17:22:13 -[IPcaller.a] 17:23:01 ericP: is there some way triplify or ultrawrap folks can use same config file/snyntax to produce triple-view or convert SPARQL to SQL queires 17:23:06 soeren: we are working on that now 17:23:51 ericP: I am also looking at expressivity, want to see if we match the expressivitiy we want 17:24:07 soeren: discuss expressivity and common gaps 17:24:18 s/soeren/ericP 17:24:43 http://www.w3.org/2001/sw/rdb2rdf/wiki/RDB-to-RDF_mapping:_A_SQL-based_Approach 17:24:57 souri: the main difference between ericP and us in DDL 17:25:06 ... go down to bottom of the page 17:26:07 ... the main thing connected with SQL is the strings, instance URIs, and connecting to 17:26:24 ... via the XML the class and its propertie sto the SQL database 17:26:34 ... and then we describe the object propertie s etc. 17:26:41 ... this is the maping what is the schema? 17:26:58 ... what is the schema that people will see even if they do not kniw underlying data? 17:27:08 ericP: I'd like to see the DDL that this sis supposed to run over 17:27:23 SourI: I can put dictionary info on there for integrity constraints 17:27:34 s/SourI/Souri 17:27:44 ... we have more or less agreement on this, DTD or XML Schema 17:27:53 ... finally what we generate is RDF schema for us all to see 17:28:34 juansequada: I have a FOL paper that shows this off in Datalog 17:28:54 ericP: you got soundness and completeness for arbitrary SQL schema to RDF schema 17:29:24 me 17:29:35 Marcelo: Yes, my paper shows the mapping 17:30:02 ericP: My question is whether or not predicates are labelled in table or derived from some function of column heading 17:30:02 actually, it is not my paper, it is Claudio Gutierrez's paper 17:30:10 Can we post a link to the paper? 17:30:12 to IRC 17:30:24 s/my paper/Caludio Gutierrez's paper/ 17:30:30 This is the paper: R. Angles, C. Gutierrez, The Expressive Power of SPARQL International Semantic Web Conference 2008. 17:30:59 Souri: the way we are translating this it is not doing it as a 2-way join, both are going back to same table 17:31:24 ... common domains 17:31:33 ... have a normalized schema 17:31:36 link to the paper: http://www.dcc.uchile.cl/~cgutierr/papers/expPowSPARQL.pdf 17:31:53 ... properties from the same row, as if join had been pre-done and sitting there in shortage 17:32:00 ericP: I'd like to see use-cases 17:32:08 ... stuck in some for BioPax 17:32:24 i will put mine tomorrow 17:32:27 ...would like to see all the use-cases 17:32:47 Souri: We will definitely augment it to show peopl, hat we are thinking 17:33:08 ericP: We need a use-case 17:34:14 T+7: Requirements and Use Cases for the RDB2RDF Mapping Language (R2RML) 17:34:23 We'll add dictionary info for the tables and the RDF schema that gets generated from the specified mapping (for the SPARQL query writer) 17:34:43 ericP: should we push something for 3 months 17:34:59 mhausenblas: We could then get out use-cases as soon as possible 17:35:31 -Ashok_Malhotra 17:35:56 Note that the use-cases will be technically separate from the test-cases, which we will keep adding through the life of the project 17:36:07 So let's push out a use-case document 17:36:21 by end of the month, and then a month to finalize into requirements 17:37:20 ericP: Soeren, can you put this Web-pubishing schemas over the doc 17:37:30 juansequada: We are testing the berlin benchmark 17:37:45 ... we have some r&a databases to the world 17:37:49 ... we could use. 17:38:20 ericP: Not sure if we want Berlin SPARQL benchmark in use-case, so let's leave that out. 17:38:33 Ahmed: I like the use-case that had integration from multiple data-sources 17:38:39 Angela: I can put that use-case in tomorrow 17:38:50 should we make these actions?? 17:39:56 ACTION: angela to put up data integration use-case 17:39:56 Created ACTION-30 - Put up data integration use-case [on Angela Fogarolli - due 2010-03-09]. 17:40:06 tables, triples, and approach 17:40:20 ACTION: Soeren web-publishing use-case 17:40:20 Sorry, couldn't find user - Soeren 17:41:07 ACTION: juansequada RNA alignment sequence use-cases 17:41:07 Sorry, couldn't find user - juansequada 17:41:11 ACTION: juansequada RNA alignment sequence use-cases 17:41:11 Sorry, couldn't find user - juansequada 17:41:15 ACTION: jsequada RNA alignment sequence use-cases 17:41:15 Sorry, couldn't find user - jsequada 17:41:21 ACTION: sequada RNA alignment sequence use-cases 17:41:21 Sorry, couldn't find user - sequada 17:41:35 ACTION: jsequeda RNA alignment sequence use-cases 17:41:35 Created ACTION-31 - RNA alignment sequence use-cases [on Juan Sequeda - due 2010-03-09]. 17:42:02 ACTION: sauer use-case for web-publishing 17:42:02 Created ACTION-32 - Use-case for web-publishing [on Sören Auer - due 2010-03-09]. 17:42:39 if we can push even a working draft out then we can push it 17:43:17 mhausenblas: happy to do it manually 17:43:39 s/happy/ok 17:44:24 just note that its use-case is a Working Group document 17:44:41 Working Group Note rather than Rec-track draft 17:44:50 ericP: publish early and often 17:46:08 Ahmed: I think it's useful to do any updates as early as possible 17:46:24 ericP: let's aim for Sunday night 17:47:21 Marcelo: I am having some trouble with the 12-1 time, could we switch to another time? 17:47:36 ericP: 1-2 time? 17:47:43 18-19:00UTC 17:47:57 juansequada: I can't. 17:48:13 Ahmed: All week except Tuesday we're booked 17:48:33 q+ 17:48:57 ack hhalpin 17:49:14 Marcelo: If it doesn't work, I'll somehow manage, with new meetings coming in. 17:49:18 what is the concrete option? 17:49:30 options? 17:49:40 s/Marcelo/Souri 17:50:14 Thursday anytime is good for me 17:50:26 hmmm 17:52:11 ACTION: Harry to find old WBS in order to help determine what schedule works 17:52:11 Created ACTION-33 - Find old WBS in order to help determine what schedule works [on Harry Halpin - due 2010-03-09]. 17:52:53 Ahmed: 8-9 AM Tuesdays 17:52:55 Tues 11-12 is ok for me 17:53:00 ... is only time that works for me. 17:53:08 11-12 EST (sorry) 17:53:38 -MacTed 17:55:29 Michael: For the record - I repeat what I've said several times - don't change the time, we're set now, will just cause confusion and more work 17:56:34 -??P27 17:56:35 -mhausenblas 17:56:35 - +49.322.222.0.aabb 17:56:40 -Souri 17:56:41 - +39.046.128.aadd 17:56:42 -whalb 17:56:44 -[IPcaller] 17:56:45 -juansequeda 17:56:45 -EricP 17:56:47 -[IPcaller.aa] 17:56:51 - +1.562.249.aaaa 18:12:01 RRSAgent, draft minutes 18:12:01 I have made the request to generate http://www.w3.org/2010/03/02-rdb2rdf-minutes.html mhausenblas 18:12:39 Zakim, list attendees 18:12:39 As of this point the attendees have been [IPcaller], whalb, +1.562.249.aaaa, juansequeda, mhausenblas, +49.322.222.0.aabb, cygri, nunolopes, +1.603.897.aacc, MacTed, 18:12:43 ... +39.046.128.aadd, Ashok_Malhotra, Souri, EricP, hhalpin 18:12:46 RRSAgent, draft minutes 18:12:46 I have made the request to generate http://www.w3.org/2010/03/02-rdb2rdf-minutes.html mhausenblas 18:13:07 RRSAgent, bye 18:13:07 I see 9 open action items saved in http://www.w3.org/2010/03/02-rdb2rdf-actions.rdf : 18:13:07 ACTION: angela to put up data integration use-case [1] 18:13:07 recorded in http://www.w3.org/2010/03/02-rdb2rdf-irc#T17-39-56 18:13:07 ACTION: Soeren web-publishing use-case [2] 18:13:07 recorded in http://www.w3.org/2010/03/02-rdb2rdf-irc#T17-40-20 18:13:07 ACTION: juansequada RNA alignment sequence use-cases [3] 18:13:07 recorded in http://www.w3.org/2010/03/02-rdb2rdf-irc#T17-41-07 18:13:07 ACTION: juansequada RNA alignment sequence use-cases [4] 18:13:07 recorded in http://www.w3.org/2010/03/02-rdb2rdf-irc#T17-41-11 18:13:07 ACTION: jsequada RNA alignment sequence use-cases [5] 18:13:07 recorded in http://www.w3.org/2010/03/02-rdb2rdf-irc#T17-41-15 18:13:07 ACTION: sequada RNA alignment sequence use-cases [6] 18:13:07 recorded in http://www.w3.org/2010/03/02-rdb2rdf-irc#T17-41-21 18:13:07 ACTION: jsequeda RNA alignment sequence use-cases [7] 18:13:07 recorded in http://www.w3.org/2010/03/02-rdb2rdf-irc#T17-41-35 18:13:07 ACTION: sauer use-case for web-publishing [8] 18:13:07 recorded in http://www.w3.org/2010/03/02-rdb2rdf-irc#T17-42-02 18:13:07 ACTION: Harry to find old WBS in order to help determine what schedule works [9] 18:13:07 recorded in http://www.w3.org/2010/03/02-rdb2rdf-irc#T17-52-11