14:55:22 RRSAgent has joined #RDB2RDF 14:55:22 logging to http://www.w3.org/2009/10/29-RDB2RDF-irc 14:55:24 RRSAgent, make logs world 14:55:26 Zakim, this will be 7322733 14:55:27 Meeting: RDB2RDF Working Group Teleconference 14:55:27 Date: 29 October 2009 14:55:27 ok, trackbot; I see SW_RDB2RDF()11:00AM scheduled to start in 5 minutes 14:55:48 Chair: Ahmed 14:55:55 Agenda: http://lists.w3.org/Archives/Public/public-rdb2rdf-wg/2009Oct/0034.html 14:55:56 soeren has joined #RDB2RDF 14:56:00 whalb has joined #RDB2RDF 14:56:01 -> previous http://www.w3.org/2009/10/22-RDB2RDF-minutes.html 14:56:11 rrsagent, draft minutes 14:56:11 I have made the request to generate http://www.w3.org/2009/10/29-RDB2RDF-minutes.html mhausenblas 14:56:17 Scribenick: mhausenblas 14:57:42 angela has joined #rdb2rdf 14:58:05 Ahmed has joined #RDB2RDF 14:58:18 Zakim, agenda+ Introductions 14:58:18 agendum 8 added 14:58:21 Hi Harry 14:58:22 Zakim, agenda? 14:58:22 I see 2 items remaining on the agenda: 14:58:23 7. "Orri Erlang (OpenLink)" [from hhalpin] 14:58:24 8. Introductions [from hhalpin] 14:58:28 Zakim, drop agendum 7 14:58:28 agendum 7, "Orri Erlang (OpenLink)", dropped 14:58:45 Zakim, agenda+ Future Meetings 14:58:45 agendum 9 added 14:58:50 Zakim, agenda+ WG Tools 14:58:50 agendum 10 added 14:58:58 Souri has joined #rdb2rdf 14:59:02 Zakim, agenda+ Objectives 14:59:02 ahm, hhalpin am I scribing or you? 14:59:03 agendum 11 added 14:59:04 Zakim, agenda+ AOB 14:59:05 SW_RDB2RDF()11:00AM has now started 14:59:06 agendum 12 added 14:59:12 +??P21 14:59:21 well, then .. 14:59:33 +Souri 14:59:35 -??P21 14:59:37 +??P21 14:59:39 Marcelo has joined #rdb2rdf 14:59:46 please leave it to me - there are plenty of useless topics on the agenda, hence ... 15:00:10 Seema has joined #RDB2RDF 15:00:20 Ashok has joined #rdb2rdf 15:00:20 +mhausenblas 15:00:44 + +1.508.358.aaaa 15:00:47 +Seema 15:01:00 +whalb 15:01:00 Zakim, who's here? 15:01:01 On IRC I see Ashok, Seema, Marcelo, Souri, Ahmed, angela, whalb, soeren, RRSAgent, mhausenblas, MacTed, hhalpin, nunolopes, iv_an_ru, Zakim, trackbot 15:01:06 On the phone I see ??P21, Souri, mhausenblas, +1.508.358.aaaa, Seema, whalb 15:01:24 + +039046188aabb 15:01:28 +??P31 15:01:35 +??P32 15:01:39 Zakim, ??P32 is hhalpin 15:01:41 +hhalpin; got it 15:01:47 Zakim, who's on the phone? 15:01:47 On the phone I see ??P21, Souri, mhausenblas, +1.508.358.aaaa, Seema, whalb, +039046188aabb, ??P31, hhalpin 15:02:11 Topic: Admin 15:02:15 +Ashok_Malhotra 15:02:20 039046188aabb is Angela 15:02:55 + +049341973aacc 15:02:58 Topic: Admin 15:03:06 PROPOSAL: accept minutes of previous telecon http://www.w3.org/2009/10/22-RDB2RDF-minutes.html 15:03:08 BenSzekely has joined #rdb2rdf 15:03:19 +soeren 15:03:35 aacc is soeren 15:03:41 Zakim, nunolopes is with mhausenblas 15:03:41 +nunolopes; got it 15:03:46 +1 15:03:52 Zakim, who's here? 15:03:52 On the phone I see ??P21, Souri, mhausenblas, +1.508.358.aaaa, Seema, whalb, +039046188aabb, ??P31, hhalpin, Ashok_Malhotra, +049341973aacc 15:03:54 On IRC I see BenSzekely, Ashok, Seema, Marcelo, Souri, Ahmed, angela, whalb, soeren, RRSAgent, mhausenblas, MacTed, hhalpin, nunolopes, iv_an_ru, Zakim, trackbot 15:03:55 Zakim, aacc is soeren 15:03:59 mhausenblas has mhausenblas, nunolopes 15:04:00 +soeren; got it 15:04:40 For Triplify presentation, are we using the 22-slide pdf file? 15:04:42 +??P39 15:04:56 RESOLUTION: minutes from last telecon accepted 15:05:21 Topic: ACTION review 15:05:28 http://www.w3.org/2001/sw/rdb2rdf/track/actions/open 15:05:47 rrsagent, draft minutes 15:05:47 I have made the request to generate http://www.w3.org/2009/10/29-RDB2RDF-minutes.html mhausenblas 15:06:57 Ashok: next week is TPAC 15:07:00 http://www.w3.org/2001/sw/rdb2rdf/wiki/images/6/6d/Triplify.pdf 15:07:09 that's the triplify presentation 15:07:24 +1 to skipping telecon next week. 15:07:47 Then we also get to reconfigure time today. 15:07:55 yes, indeed 15:08:35 ACTION-8? 15:08:35 ACTION-8 -- Harry Halpin to double-check EricP's status and have him send in his proposals about mapping -- due 2009-10-29 -- OPEN 15:08:35 http://www.w3.org/2001/sw/rdb2rdf/track/actions/8 15:08:49 close ACTION-8 15:08:49 ACTION-8 Double-check EricP's status and have him send in his proposals about mapping closed 15:09:00 ACTION-10 15:09:03 ACTION-10? 15:09:03 ACTION-10 -- Harry Halpin to will add 10 more participants to telecon -- due 2009-10-29 -- OPEN 15:09:03 http://www.w3.org/2001/sw/rdb2rdf/track/actions/10 15:09:09 close ACTION-10 15:09:09 ACTION-10 Will add 10 more participants to telecon closed 15:09:19 close ACTION-11 15:09:19 ACTION-11 Ask EricP for back-up closed 15:09:30 http://www.w3.org/2001/sw/rdb2rdf/wiki/Requirements 15:10:11 Notes "The mapping language MUST define the set of relational algebra to be supported in the first release. This set to be supported SHOULD be as complete as possible and be defined as soon as possible after the WG official launch." 15:10:35 I expect that we should have Marcelo give a presentation on his work on formal semantics ASAP after we're done with the implementation overviews. 15:11:04 T+4: Requirements and Use Cases for the RDB2RDF Mapping Language (R2RML) 15:12:58 Topic: Presentation of Triplify 15:13:16 slides see http://www.w3.org/2001/sw/rdb2rdf/wiki/images/6/6d/Triplify.pdf 15:13:34 About the requirements 'SHOULD' portion: What is "human-readable"? Is SQL query human-readable? 15:13:49 soeren: our group works on couple of tools (DL Learner, etc.) as well as onTriplify 15:14:07 slide 2 15:14:14 TriplifyBig Picture 15:14:21 slide 3 15:14:28 motivation 15:14:47 many DB-backed applications 15:15:16 idea: when we're able to RDFise the content of these DB, we gain quite a bit - Web of Data 15:15:49 most of the tools are OSS, should be easy to integrate 15:15:55 slide 4 15:16:26 configure once, use often 15:16:33 slide 5 15:16:54 solution: uses SQL to transform 15:17:30 extends SQL with some syntactic constructs 15:17:51 maps URI patterns to set of SQL patterns 15:18:09 according to the Linked Data principles 15:18:14 slide 6 15:18:30 Ashok: will you talk about the extensions? 15:18:34 soeren: yes 15:18:42 soeren: just some conventions, actually 15:20:15 soeren: few tables anyway, no automatic generation, hence 15:21:04 ... conventions, such as first col must be an ID, the col name should refer to RDF properties 15:21:41 q+ 15:21:58 ack Souri 15:22:15 Souri: conceptual mapping or materialising? 15:22:20 soeren: view 15:22:25 slide 7 15:22:49 soeren: here is an example mapping a WP blog post 15:23:06 http://blog.aksw.org/triplify/post/(xxx) 15:23:31 SELECT id, post_authorAS 'sioc:has_creator->user', 15:23:31 post_title AS 'dc:title', 15:23:31 post_content AS 'sioc:content', post_date AS 15:23:32 'dcterms:modified^^xsd:dateTime‘, 15:23:32 post_modified AS 'dcterms:created^^xsd:dateTime' 15:23:32 FROM posts 15:23:33 WHERE post_status='publish‘ (ANDid=xxx) 15:25:36 q+ 15:26:21 ack Souri 15:26:49 Souri: we took the same approach 15:27:14 Souri: our work was so far only internally 15:28:01 Souri: there are two approaches to address the datatype 15:28:48 soeren: needed to overwrite the default (Triplify supports both) 15:29:14 Souri: I think we need a consistency check - explicit might be more benfical 15:29:36 slide 8 15:30:08 shows the actual RDF conversion 15:30:10 slide 9 15:30:22 summarises the implementation of Triplify 15:30:38 design principle is KISS 15:30:49 no new mapping language (SQL is used) 15:31:14 available for popular languages 15:31:26 works with most DBs 15:32:08 rrsagent, draft minutes 15:32:08 I have made the request to generate http://www.w3.org/2009/10/29-RDB2RDF-minutes.html mhausenblas 15:32:18 slide 10 15:32:31 an example of an WP blog configuration 15:32:35 nine queries 15:33:56 slide 11 15:34:08 we offer a configuration repository 15:34:19 slide 12 15:34:23 slide 13 15:34:27 two extensions 15:34:32 a temporal extension 15:34:51 address the 'when to crawl data' 15:34:53 slide 14 15:35:31 shows how this works in Triplify 15:36:34 Michael: would be good to know the update voc URI 15:36:39 slide 15 15:37:09 LOD update log generation 15:37:37 LOD means ??? 15:37:39 slide 16 15:37:43 Linked Open Data 15:37:47 Spatial Extension 15:37:51 Thanks. 15:37:54 yw 15:37:58 see linkeddata.org 15:38:46 soeren: used the spatial extension to create linked data version of OpenStreetMap 15:39:33 slide 17 15:39:50 example from http://linkedgeodata.org/ 15:41:49 q+ 15:42:36 ack Souri 15:42:50 Souri: which query interface do you support? 15:42:55 soeren: based on URIs 15:43:41 skip to slide 19 15:43:51 RDB2RDF tool comparison 15:44:06 Triplify, D2R and Virtuoso views 15:45:42 slide 20 15:46:01 soeren: Triplifysupports the “long tail” of deployed Web applications 15:46:51 soeren: that's it - questions? 15:47:17 http://www2009.eprints.org/63/ 15:47:59 Ashok: license? 15:48:09 soeren: it's OSS 15:48:51 soeren: more background on Triplify see WWW paper above, will send to list and update Wiki 15:49:03 Topic: Meeting schedule 15:49:13 http://www.w3.org/2002/09/wbs/43889/TELECON/results 15:49:34 hhalpin: did the voting 15:50:11 11 EST 15:50:19 Which would be 8AM EST on Tuesday. 15:50:36 8AM PST Tuesday 11 EST. 15:50:48 Ashok - you can do 9AM Tuesday but not 8AM. 15:51:17 That is correct 15:51:38 9am PST, 12 noon EST Tues 15:52:13 Souri, I hope that's OK for you 15:52:25 everyone should check with http://www.timeanddate.com/worldclock/converter.html 15:52:31 Ashok it is okay for me 15:52:42 4:00 PM UTC. 15:53:07 http://www.timeanddate.com/worldclock/fixedtime.html?day=4&month=11&year=2009&hour=8&min=0&sec=0&p1=137 15:53:53 ACTION: hhalpin to inform li ma 15:53:54 Created ACTION-12 - Inform li ma [on Harry Halpin - due 2009-11-05]. 15:54:32 next meeting is on Tuesday 10 November 2009 at 16:00 UTC 15:54:43 RESOLVED: To meet 10 Nov. 2009 16:00 UTC. 15:54:44 -??P21 15:54:45 take care! 15:54:46 -Seema 15:54:48 - +1.508.358.aaaa 15:54:48 -Souri 15:54:49 - +039046188aabb 15:54:49 -mhausenblas 15:54:51 -whalb 15:54:51 -??P39 15:54:54 rrsagent, draft minutes 15:54:54 I have made the request to generate http://www.w3.org/2009/10/29-RDB2RDF-minutes.html mhausenblas 15:54:57 -soeren 15:55:02 trackbot, end meeting 15:55:02 Zakim, list attendees 15:55:02 As of this point the attendees have been Souri, mhausenblas, +1.508.358.aaaa, Seema, whalb, +039046188aabb, hhalpin, Ashok_Malhotra, +049341973aacc, nunolopes, soeren 15:55:03 Marcelo has left #rdb2rdf 15:55:03 RRSAgent, please draft minutes 15:55:03 I have made the request to generate http://www.w3.org/2009/10/29-RDB2RDF-minutes.html trackbot 15:55:04 RRSAgent, bye 15:55:04 I see 1 open action item saved in http://www.w3.org/2009/10/29-RDB2RDF-actions.rdf : 15:55:04 ACTION: hhalpin to inform li ma [1] 15:55:04 recorded in http://www.w3.org/2009/10/29-RDB2RDF-irc#T15-53-53