15:57:41 RRSAgent has joined #rdb2rdf 15:57:41 logging to http://www.w3.org/2010/07/20-rdb2rdf-irc 15:57:43 RRSAgent, make logs world 15:57:43 Zakim has joined #rdb2rdf 15:57:45 Zakim, this will be 7322733 15:57:45 ok, trackbot; I see SW_RDB2RDF()12:00PM scheduled to start in 3 minutes 15:57:46 Meeting: RDB2RDF Working Group Teleconference 15:57:46 Date: 20 July 2010 15:57:50 hhalpin has changed the topic to: Call for July 20th 15:57:59 Agenda: http://lists.w3.org/Archives/Public/public-rdb2rdf-wg/2010Jul/0030.html 15:58:03 Chair: Michael 15:58:13 regrets+ LiMa 15:59:15 Marcelo has joined #rdb2rdf 15:59:17 juansequeda has joined #RDB2RDF 15:59:52 Ashok has joined #rdb2rdf 16:00:16 SW_RDB2RDF()12:00PM has now started 16:00:23 + +1.562.249.aaaa 16:00:59 +[IPcaller] 16:01:10 seema has joined #rdb2rdf 16:01:34 Zakim, code? 16:01:34 the conference code is 7322733 (tel:+1.617.761.6200 tel:+33.4.26.46.79.03 tel:+44.203.318.0479), mhausenblas 16:01:48 +Kingsley_Idehen 16:01:57 Zakim, Kingsley_Idehen is OpenLink_Software 16:01:57 +OpenLink_Software; got it 16:01:58 + +1.603.897.aabb 16:02:05 Zakim, OpenLink_Software is temporarily me 16:02:05 +MacTed; got it 16:02:12 + +3539149aacc 16:02:15 Zakim, mute me 16:02:15 MacTed should now be muted 16:02:15 cygri has joined #rdb2rdf 16:02:17 Zakim, aabb is me 16:02:17 +seema; got it 16:02:29 Zakim, unmute me 16:02:29 MacTed should no longer be muted 16:02:40 Zakim, who's here? 16:02:40 On the phone I see +1.562.249.aaaa, [IPcaller], MacTed, seema, +3539149aacc 16:02:42 On IRC I see cygri, seema, Ashok, juansequeda, Marcelo, Zakim, RRSAgent, hhalpin, mhausenblas, boris, LeeF, MacTed, nunolopes, ericP, trackbot, iv_an_ru 16:02:46 aacc is me 16:02:54 Zakim, mute me 16:02:57 MacTed should now be muted 16:02:58 soeren has joined #RDB2RDF 16:03:01 Zakim, aacc is me 16:03:09 Zakim, TF, wake up you stupid bot 16:03:21 +mhausenblas; got it 16:03:25 Zakim, nunolopes is with mhausenblas 16:03:28 dan has joined #RDB2RDF 16:03:31 + +49.322.222.0.aadd 16:03:33 I don't understand 'TF, wake up you stupid bot', mhausenblas 16:03:34 Zakim, IPcaller is me 16:03:36 Zakim, cygri is with mhausenblas 16:03:36 Zakim, aaaa is me 16:03:37 +Ashok_Malhotra 16:03:47 zakim, aadd is me 16:03:50 Zakim, boris is with mhausenblas 16:03:51 +nunolopes; got it 16:03:59 +juansequeda; got it 16:04:03 +cygri; got it 16:04:05 +Marcelo; got it 16:04:06 hhalpin - do you have the new UK number? 16:04:10 Zakim, who's here? 16:04:13 +soeren; got it 16:04:15 +boris; got it 16:04:17 On the phone I see Marcelo, juansequeda, MacTed (muted), seema, mhausenblas, soeren, Ashok_Malhotra 16:04:21 mhausenblas has mhausenblas, nunolopes, cygri, boris 16:04:26 +44.203.318.0479 (London) 16:04:29 On IRC I see dan, soeren, cygri, seema, Ashok, juansequeda, Marcelo, Zakim, RRSAgent, hhalpin, mhausenblas, boris, LeeF, MacTed, nunolopes, ericP, trackbot, iv_an_ru 16:04:32 MacTed see above 16:04:52 mhausenblas - not for me, for hhalpin :-) +44.203.318.0479 16:05:01 Zakim, pick a victim 16:05:01 Not knowing who is chairing or who scribed recently, I propose seema 16:05:02 Souri has joined #rdb2rdf 16:05:09 +[IPcaller] 16:05:13 Zakim, who's noisy? 16:05:22 Zakim, [IPcaller] is hhalpin 16:05:22 +hhalpin; got it 16:05:24 MacTed, listening for 10 seconds I heard sound from the following: 8 (41%), soeren (64%), Ashok_Malhotra (19%), mhausenblas (51%), seema (58%) 16:05:36 scribenick: seema 16:05:40 +Souri 16:05:44 + +1.512.471.aaee 16:05:47 Zakim, who's here? 16:05:47 On the phone I see Marcelo, juansequeda, MacTed (muted), seema, mhausenblas, soeren, Ashok_Malhotra, hhalpin, Souri, +1.512.471.aaee 16:05:50 mhausenblas has mhausenblas, nunolopes, cygri, boris 16:05:51 On IRC I see Souri, dan, soeren, cygri, seema, Ashok, juansequeda, Marcelo, Zakim, RRSAgent, hhalpin, mhausenblas, boris, LeeF, MacTed, nunolopes, ericP, trackbot, iv_an_ru 16:06:04 aaee is dan 16:06:14 http://lists.w3.org/Archives/Public/public-rdb2rdf-wg/2010Jul/0030.html 16:06:25 Topic: Admin 16:06:42 +1 16:06:43 PROPOSAL: Accept the minutes of last meeting, see http://www.w3.org/2010/07/13-rdb2rdf-minutes.html 16:07:16 RESOLUTION: minutes of last meeting http://www.w3.org/2010/07/13-rdb2rdf-minutes.html accepted 16:07:27 Topic: Meetings in July/August 16:07:32 http://doodle.com/u6qg5z7gmfhc2zak 16:08:37 alexdeleon has joined #RDB2RDF 16:09:06 Topic: R2RML Semantics 16:09:39 angela has joined #RDB2RDF 16:09:41 +Lee_Feigenbaum 16:09:50 Notes according to schedule we were supposed to get first draft of mapping language out in June... 16:10:04 I'll ask for a 3 month extension, but even something very rough out by end of August would be ideal. 16:10:11 http://lists.w3.org/Archives/Public/public-rdb2rdf-wg/2010Jul/0028.html 16:10:36 +[IPcaller] 16:10:42 q+ 16:10:48 ack hhalpin 16:10:51 ack hhalpin 16:11:00 Zakim, who' s here? 16:11:00 I don't understand your question, mhausenblas. 16:11:06 Zakim, who's here? 16:11:06 On the phone I see Marcelo, juansequeda, MacTed (muted), seema, mhausenblas, soeren, Ashok_Malhotra, hhalpin, Souri, +1.512.471.aaee, Lee_Feigenbaum, [IPcaller] 16:11:09 mhausenblas has mhausenblas, nunolopes, cygri, boris 16:11:11 On IRC I see angela, alexdeleon, Souri, dan, soeren, cygri, seema, Ashok, juansequeda, Marcelo, Zakim, RRSAgent, hhalpin, mhausenblas, boris, LeeF, MacTed, nunolopes, ericP, 16:11:14 ... trackbot, iv_an_ru 16:11:18 Zakim, aaee is here 16:11:18 +here; got it 16:11:26 Zakim, aaee is dan 16:11:26 sorry, mhausenblas, I do not recognize a party named 'aaee' 16:11:35 Harry: would like summer meetings so that we can continue to work on the mapping language charter 16:11:40 Zakim, aaee is really dan 16:11:40 sorry, mhausenblas, I do not recognize a party named 'aaee' 16:12:15 Zakim, here is really dan 16:12:15 +dan; got it 16:12:31 Zakim, who's on the phone? 16:12:31 On the phone I see Marcelo, juansequeda, MacTed (muted), seema, mhausenblas, soeren, Ashok_Malhotra, hhalpin, Souri, dan, Lee_Feigenbaum, [IPcaller] 16:12:34 mhausenblas has mhausenblas, nunolopes, cygri, boris 16:12:53 https://docs.google.com/document/pub?id=1APTqD2lJLRjwV6gmPKqDRqC3aT8bozHF0udIXndMNWQ 16:13:56 http://www.w3.org/2001/sw/rdb2rdf/wiki/Database-Instance-Only_and_Database-Instances-and-Schema_Mapping 16:14:00 FYI you can often get HTML from google docs that can be pasted into the wiki after the fact 16:14:27 Zakim, here is really dan 16:14:27 sorry, mhausenblas, I do not recognize a party named 'here' 16:14:34 https://docs.google.com/document/pub?id=1APTqD2lJLRjwV6gmPKqDRqC3aT8bozHF0udIXndMNWQ 16:14:36 Zakim, who's here? 16:14:36 On the phone I see Marcelo, juansequeda, MacTed (muted), seema, mhausenblas, soeren, Ashok_Malhotra, hhalpin, Souri, dan, Lee_Feigenbaum, [IPcaller] 16:14:39 mhausenblas has mhausenblas, nunolopes, cygri, boris 16:14:40 On IRC I see angela, alexdeleon, Souri, dan, soeren, cygri, seema, juansequeda, Marcelo, Zakim, RRSAgent, hhalpin, mhausenblas, boris, LeeF, MacTed, nunolopes, ericP, trackbot, 16:14:43 ... iv_an_ru 16:14:46 rrsagent, draft minutes 16:14:46 I have made the request to generate http://www.w3.org/2010/07/20-rdb2rdf-minutes.html mhausenblas 16:14:49 Ashok has joined #rdb2rdf 16:15:03 Datalog, SQL, RIF, Eric - https://docs.google.com/document/pub?id=1APTqD2lJLRjwV6gmPKqDRqC3aT8bozHF0udIXndMNWQ 16:15:09 http://www.w3.org/2001/sw/rdb2rdf/wiki/Database-Instance-Only_and_Database-Instances-and-Schema_Mapping 16:15:09 RRSAgent, make logs public 16:16:40 Marcelo: Idea is to have a running example in our document. DB instance mapping is the default mapping 16:17:03 +[IPcaller.a] 16:17:26 Zakim, IPcaller.a is angela 16:17:26 +angela; got it 16:17:33 .. the 3 rules can also be generated automatically 16:17:35 Zakim, who's here? 16:17:35 On the phone I see Marcelo, juansequeda, MacTed (muted), seema, mhausenblas, soeren, Ashok_Malhotra, hhalpin, Souri, dan, Lee_Feigenbaum, [IPcaller], angela 16:17:39 mhausenblas has mhausenblas, nunolopes, cygri, boris 16:17:41 On IRC I see Ashok, angela, alexdeleon, Souri, dan, soeren, cygri, seema, juansequeda, Marcelo, Zakim, RRSAgent, hhalpin, mhausenblas, boris, LeeF, MacTed, nunolopes, ericP, 16:17:44 ... trackbot, iv_an_ru 16:18:12 q+ 16:18:25 ack Ashok 16:18:36 ..no ontology used in case 2 and case 3. hence the rules can be generated automatically 16:18:56 The IPcaller must be me 16:19:08 Ashok : why start with an example, instead of starting with the rules of the language 16:19:43 Marcelo: the example is just to make the rules easier to undestand 16:20:06 q+ 16:20:34 which case are you explaining? 16:21:00 q+ 16:22:12 q+ 16:22:16 q? 16:22:21 ack cygri 16:22:43 Zakim, code? 16:22:43 the conference code is 7322733 (tel:+1.617.761.6200 tel:+33.4.26.46.79.03 tel:+44.203.318.0479), ericP 16:22:51 Richard : can we use aggregates in queries? 16:23:07 Marcelo: yes, the predicate can be replaced with aggregates 16:23:08 good question - we need to figure out what fragment of Datalog aggregates is in, and if we can do that in RIF as well. 16:23:11 ack Ashok 16:23:13 Zakim, please dial ericP-mom 16:23:13 ok, ericP; the call is being made 16:23:13 +EricP 16:23:52 ack Souri 16:24:06 -[IPcaller] 16:25:16 Souri: In datalog, is there a limit to the language we can use ? 16:25:19 +??P0 16:25:27 Using Datalog is still up for debate I think. 16:25:43 q+ 16:25:43 Zakim, who's here? 16:25:44 On the phone I see Marcelo, juansequeda, MacTed (muted), seema, mhausenblas, soeren, Ashok_Malhotra, hhalpin, Souri, dan, Lee_Feigenbaum, angela, EricP, ??P0 16:25:46 q? 16:25:48 mhausenblas has mhausenblas, nunolopes, cygri, boris 16:25:50 On IRC I see Ashok, angela, Souri, dan, soeren, cygri, seema, juansequeda, Marcelo, Zakim, RRSAgent, hhalpin, mhausenblas, boris, LeeF, MacTed, nunolopes, ericP, trackbot, iv_an_ru 16:25:56 datelog has aggregates? 16:26:02 Marcelo: up to us to decide what to include.. maybe a simplification..no recursion, no aggregates ..most basic form of SQL 16:26:07 alexdeleon has joined #RDB2RDF 16:26:34 ack hhalpin 16:26:39 -??P0 16:27:00 +q 16:27:03 q? 16:27:50 can someone fill in me on who is speaking ? is it MacTed? 16:27:58 its harry 16:27:58 hhalpin 16:28:00 q+ 16:28:03 thx 16:28:09 q? 16:28:31 Can't people use SQL to produce whatever views they want before applying RDB2RDF standards *regardless* of what the syntax of the RDB2RDF mapping standard looks like? 16:28:54 +1 to LeeF 16:29:02 LeeF: +1 16:29:04 Harry: do we assume that users will know SQL ? so that we allow additional SQL power to the language ? 16:30:02 q? 16:30:06 ack soeren 16:30:14 q+ 16:30:18 ack Ashok 16:30:19 q? 16:30:23 on DAWG & SPARQL WG, SteveH is fond of telling me that SQL does not at all line up with relational algebra (though the details are way beyond me) 16:30:43 q+ 16:31:03 +1 to ashok 16:31:07 q? 16:31:10 ack juansequeda 16:31:40 LeeF, true and that's one way to do it but then what would RDB2RDF do precisely... 16:31:52 q+ 16:32:01 q? 16:32:17 ack Marcelo 16:32:18 the issue is that most people will be much happier probably using SQL than either RIF or some weird custom XML syntax IMHO 16:32:29 scribenick: mhausenblas 16:32:35 q+ 16:32:43 Marcelo: I agree with juansequeda 16:32:45 q? 16:32:46 note that SQL-92 (aka SQL-2) has levels -- Entry, Intermediate, and Full ... SQL-99 (aka SQL-3) and later, have similar levels 16:33:00 SPARQL is a bit less mature, but I think the same should be coming 16:33:01 q+ 16:33:02 q? 16:33:03 q? 16:33:06 ack hhalpin 16:33:06 ack hhalpin 16:33:13 seema has joined #rdb2rdf 16:33:22 q+ SQL levels... 16:33:25 scribenick: seema 16:33:27 grrr 16:33:33 q- SQL levels... 16:33:38 sorry, got kicked out of irc 16:33:39 q+ 16:33:59 q+ 16:34:11 im q+ 16:34:22 Zakim, unmute me 16:34:22 MacTed should no longer be muted 16:34:34 q? 16:34:34 Marcelo: whatever is represented in Datalog can be represented easily in other languages. 16:35:15 ack cygri 16:35:30 q+ 16:35:34 q? 16:35:53 Richard: agree that datalog has well defined semantics. However SQL is richer. 16:37:04 Marcelo: do you want to consider different implementation by diff vendors and base a standard on that ? Would not agree with that. 16:37:06 +1 to Richard 16:37:35 s/Marcelo: do you want/Richard: do you want 16:37:39 RRSAgent, draft minutes 16:37:39 I have made the request to generate http://www.w3.org/2010/07/20-rdb2rdf-minutes.html mhausenblas 16:37:41 q? 16:37:47 ack juansequeda 16:37:48 thanks Michael 16:37:55 If the mapping language is a pretty thin wrapper around SQL & punts on the semantics of the wrapped SQL... that doesn't seem all too useful to me (off the top of my head) 16:38:46 q? 16:38:58 ack MacTed 16:39:03 +1 to going around in circles a lot :D 16:39:47 agree with macted 16:39:57 q? 16:40:12 MacTed: SQL is not monolithic or simple. Lots of things in standard that leave specific implementation out to the vendor. 16:40:26 I agree with the levels of SQL that MacTed is talking about. We should have levels of our mapping language 16:40:29 .. we have slightly diff syntax per vendor 16:41:10 .. however DB vendors can declare compliance to a SQL level 16:41:19 q? 16:41:35 +1 to MacTed's simple and to-the-point view 16:41:45 SQL *query* standards could be used as a guideline. But, are we saying that SQL??? features {x,y,z,a,...} are the only ones that are supported OR, going the other way, saying that SQL??? features {u,v,w,...} may *not* be portable? 16:41:48 Souri: the query portion of SQL is standard. 16:42:13 q? 16:42:18 ack Souri 16:42:50 q? 16:43:02 ack Marcelo 16:43:09 RRSAgent, draft minutes 16:43:09 I have made the request to generate http://www.w3.org/2010/07/20-rdb2rdf-minutes.html mhausenblas 16:43:30 Souri: we could have vendors state something along the likes of SQL quote above..some parts are portable, others are not 16:43:59 marcelo: datalog can be easily converted to SQL. then SQL can be enhanced. 16:44:19 q+ 16:44:38 ack Ashok 16:44:43 q+ 16:44:47 q+ 16:44:54 Marcelo: people in DB industry doing data integration use Datalog, not SQL 16:45:26 q? 16:45:37 ack dan 16:46:40 Dan is talking about : https://docs.google.com/document/pub?id=1APTqD2lJLRjwV6gmPKqDRqC3aT8bozHF0udIXndMNWQ 16:46:57 q+ 16:47:03 q+ to ask what piece of datalog we're talking about 16:47:11 q? 16:48:01 Ashok, mhausenblas - if we were going to take a straw poll on this conversation now... what would the question be? i'm still not convinced we all agree/understand what the exact question under debate is 16:48:11 Steps: 0) (not a step) you have a db schema present, 1) you want to transform it to a desired schema (=> do it using SQL query), 2) use a mapping language to map the interface of the queries to the OWL classes and datatype properties 3) use a mapping language to map the ref integrity constraints to OWL object properties 16:48:22 the question is the meta-level approach. 16:48:28 Good question LeeF - I'm still trying to figure ... 16:48:32 +1 to Lee 16:48:37 q? 16:48:39 Datalog is just an "option" to bridge SQL and RIF/RDF approaches. 16:48:46 Zakim, mute me 16:48:46 MacTed should now be muted 16:49:37 hhalpin, what other options of bridges do we have? I'd be interested if somebody could propose something else 16:49:41 LeeF care to do q+ and ask this to everyone? :) 16:49:43 q? 16:49:57 q+ because mhausenblas asked me to 16:50:04 q+ to ask what we're debating 16:50:12 ack hhalpin 16:50:13 So, a basic question is what should be the mapping langauge? Does user have to write the mapping in datalog? Do we have to write a parser for translating the datalog spec to SQL query? 16:50:42 1) Use all of SQL, basic mapping in XML. 16:50:54 2) Use a default mapping, then do mapping in RIF 16:51:29 Souri, datalog as a syntax... but we don't have to use that. We can define another syntax if we want 16:51:29 3) Which part of SQL and RIF can we hold in common (Datalog ,which is just a semantics to my knowledge) 16:51:39 q? 16:52:08 The fact is... we have SQL to transform between relational models. 16:52:17 And we have RIF (or SPARQL) to translate between RDF models (sort of). 16:52:17 q+ 16:52:18 alexdeleon has joined #RDB2RDF 16:52:25 q? 16:52:26 So the only gap is that bit in between (creating URIs, data types, etc.) 16:52:34 so let's just define the simple simple mapping and call it a day 16:52:52 q+ 16:52:58 we talked a bit at SemTech about enumerating the list of things that would need to be in that mapping 16:53:00 q? 16:53:17 ack cygri 16:54:08 Richard: address Harry's options : 1 would not be very popular, though easy to understand 16:54:40 or SPARQL Constructs rather than RIF. 16:55:00 q- 16:55:06 .. option 2 addresses RDF audience..but they don't use RIF currently 16:55:13 he said just using all of SQL would be popular. 16:55:24 thanks LeeF ! 16:55:36 cygri: RDF to RDF is something we shouldnt address +1 16:55:39 +1 16:56:31 q? 16:56:35 ack me 16:56:36 ericP, you wanted to ask what piece of datalog we're talking about 16:56:37 ack ericP 16:56:59 Richard, could you write mail summarizing what you said and we can discuss next Tuesday 16:57:17 s/1 would not be very popular/using all of SQL would be popular 16:57:31 Ashok: ok 16:57:43 thanks cygri 16:57:52 RRSAgent, draft minutes 16:57:52 I have made the request to generate http://www.w3.org/2010/07/20-rdb2rdf-minutes.html mhausenblas 16:58:00 q? 16:58:29 ack dan 16:59:10 alexdeleon has joined #RDB2RDF 16:59:14 good observation, Dan! 16:59:18 ack Marcelo 16:59:24 Dan: as an audience for this document : 1 audience is us, 2 is folks not us but implementing the audience, 3) folks who have to live with this 16:59:24 curious who _is_ going to implement this 16:59:27 would Informatica implement this? 17:00:00 The implementers are obviously database vendors. 17:00:09 Therefore, we have to be *most* sensitive to their needs. 17:00:45 hhalpin I wouldn't be that sure (re obviously database vendors) - there are others ATM and there may be others 17:01:02 what goes to the database has to be a SQL query 17:01:05 Well, if database vendors don't implement it, it won't get into the hands of end-users 17:01:09 but I agree that we should be very sensitive re DB vendors, yes 17:01:11 +1 Souri. 17:01:24 q? 17:01:25 Marcelo: Language for mapping in commercial tools is often Datalog 17:01:29 -Lee_Feigenbaum 17:01:59 -dan 17:02:01 Topic: AOB 17:02:07 question is what is the mapping language to use? the spec of course needs to get translated to SQL before sending it to the database. 17:02:09 thanks - go t to go... 17:02:19 So whatever mapping language we use has to either be SQL or be a fragment of SQL with some definite extensibility, or easily translated into SQL. 17:02:34 -mhausenblas 17:02:37 -soeren 17:02:40 -angela 17:02:41 Michael: all the best in taking this further, see you in late August 17:02:51 ok, seema, let's wrap up 17:02:56 RRSAgent, draft minutes 17:02:56 I have made the request to generate http://www.w3.org/2010/07/20-rdb2rdf-minutes.html mhausenblas 17:03:01 -Marcelo 17:03:01 Zakim, list attendees 17:03:02 As of this point the attendees have been +1.562.249.aaaa, +1.603.897.aabb, MacTed, +3539149aacc, seema, mhausenblas, +49.322.222.0.aadd, Ashok_Malhotra, nunolopes, juansequeda, 17:03:05 ... cygri, Marcelo, soeren, boris, hhalpin, Souri, +1.512.471.aaee, Lee_Feigenbaum, [IPcaller], dan, angela, EricP 17:03:11 RRSAgent, draft minutes 17:03:11 I have made the request to generate http://www.w3.org/2010/07/20-rdb2rdf-minutes.html mhausenblas 17:04:46 ScribeOptions: -final -noEmbedDiagnostics 17:04:55 RRSAgent, draft minutes 17:04:55 I have made the request to generate http://www.w3.org/2010/07/20-rdb2rdf-minutes.html mhausenblas 17:05:16 Zakim, bye 17:05:16 leaving. As of this point the attendees were +1.562.249.aaaa, +1.603.897.aabb, MacTed, +3539149aacc, seema, mhausenblas, +49.322.222.0.aadd, Ashok_Malhotra, nunolopes, 17:05:16 Zakim has left #rdb2rdf 17:05:19 ... juansequeda, cygri, Marcelo, soeren, boris, hhalpin, Souri, +1.512.471.aaee, Lee_Feigenbaum, [IPcaller], dan, angela, EricP 17:05:21 RRSAgent, bye 17:05:21 I see no action items