15:57:45 RRSAgent has joined #rdb2rdf 15:57:45 logging to http://www.w3.org/2010/08/24-rdb2rdf-irc 15:57:47 RRSAgent, make logs world 15:57:47 Zakim has joined #rdb2rdf 15:57:49 Zakim, this will be 7322733 15:57:49 ok, trackbot; I see SW_RDB2RDF()12:00PM scheduled to start in 3 minutes 15:57:50 Meeting: RDB2RDF Working Group Teleconference 15:57:50 Date: 24 August 2010 15:58:09 Chair: Michael 15:58:25 Agenda: http://lists.w3.org/Archives/Public/public-rdb2rdf-wg/2010Aug/0029.html 15:59:07 Souri has joined #rdb2rdf 16:00:13 SW_RDB2RDF()12:00PM has now started 16:00:21 + +3539149aaaa 16:00:33 Zakim, aaaa is me 16:00:33 +mhausenblas; got it 16:00:41 boris has joined #RDB2RDF 16:00:41 Zakim, nunolopes is with me 16:00:41 +nunolopes; got it 16:00:52 Zakim, boris is with me 16:00:52 +boris; got it 16:01:22 cygri has joined #rdb2rdf 16:01:57 Zakim, cygri is with me 16:01:57 +cygri; got it 16:02:20 +Souri 16:02:47 regrets+ Harry 16:02:55 regrets+ Li_Ma 16:03:01 RRSAgent, draft minutes 16:03:01 I have made the request to generate http://www.w3.org/2010/08/24-rdb2rdf-minutes.html mhausenblas 16:03:09 RRSAgent, make the logs public, please 16:03:09 I'm logging. I don't understand 'make the logs public', mhausenblas. Try /msg RRSAgent help 16:03:15 RRSAgent, make the logs public 16:03:15 I'm logging. I don't understand 'make the logs public', mhausenblas. Try /msg RRSAgent help 16:03:52 RRSAgent, make record public 16:03:53 Angela has joined #RDB2RDF 16:04:18 Zakim, please dial ericP-office 16:04:18 ok, ericP; the call is being made 16:04:20 +EricP 16:04:32 apologies, cornered in the lunchline 16:05:03 Zakim, who's around? 16:05:03 I don't understand your question, mhausenblas. 16:05:08 Zakim, who's here? 16:05:08 On the phone I see mhausenblas, Souri, EricP 16:05:09 mhausenblas has mhausenblas, nunolopes, boris, cygri 16:05:11 On IRC I see Angela, cygri, boris, Souri, Zakim, RRSAgent, juansequeda, mhausenblas, nunolopes, MacTed, LeeF, iv_an_ru, ericP, trackbot 16:05:37 regrets+ Ashok 16:07:00 whatz the problem, juansequeda? 16:07:03 juansequeda, via voip? 16:07:13 says passcode not valid 16:07:29 Divan, following Turkey, instead of a chair 16:07:53 hehe, iv_an_ru 16:07:58 juansequeda try +1-617-761-6200 16:08:04 I am 16:08:29 last week I had the same problem and I spoke with the operator and that is how I got in. but the operator isn't picking up 16:08:53 juansequeda, what's your no? 16:08:58 maybe i can conference you 16:09:01 512-471-9541 16:09:07 (given 20 or so tries) 16:10:20 Angela, do you plan to dial in? 16:10:25 Zakim, ericP has ericP, juansequeda, dan 16:10:25 +ericP, juansequeda, dan; got it 16:10:28 Zakim, who's here? 16:10:28 On the phone I see mhausenblas, Souri, EricP 16:10:29 EricP has ericP, juansequeda, dan 16:10:31 mhausenblas has mhausenblas, nunolopes, boris, cygri 16:10:33 On IRC I see Angela, cygri, boris, Souri, Zakim, RRSAgent, juansequeda, mhausenblas, nunolopes, MacTed, LeeF, iv_an_ru, ericP, trackbot 16:10:51 no i can not 16:11:09 but I am trying to participate in IRC 16:11:27 scribenick: ericP 16:11:36 I don't have a phone...and I can not connect through skype 16:11:53 too bad Angela, sorry 16:12:03 Angela, got a skype-in no? 16:12:12 no 16:12:17 anyway do not worry 16:12:21 thanks 16:12:26 try to follow on IRC 16:12:37 the scribe will try to be expository 16:12:39 should be no prob with such an excellent scribe ;) 16:12:47 :) 16:12:53 topic: admin 16:13:09 PROPOSED accept minutes of 17 Aug 2010 16:13:16 +1 16:13:21 APPROVED 16:13:52 topic: conclude SQL-based comments with cygri 16:14:02 +OpenLink_Software 16:14:10 Zakim, OpenLink_Software is temporarily me 16:14:10 +MacTed; got it 16:14:12 Zakim, mute me 16:14:12 MacTed should now be muted 16:14:24 Agenda is here: +1-617-761-6200 16:14:29 http://lists.w3.org/Archives/Public/public-rdb2rdf-wg/2010Aug/0029.html 16:14:48 topic: RDB2RDF telecon -- agenda: http://lists.w3.org/Archives/Public/public-rdb2rdf-wg/2010Aug/0029 16:15:00 http://lists.w3.org/Archives/Public/public-rdb2rdf-wg/2010Aug/0004.html 16:15:03 ericP has changed the topic to: RDB2RDF telecon -- agenda: http://lists.w3.org/Archives/Public/public-rdb2rdf-wg/2010Aug/0029 16:15:07 topic: conclude SQL-based comments with cygri 16:15:22 cygri: without knowing what happened last meeting.. 16:15:27 ... i expected: 16:15:31 ... .. uri templates 16:15:46 ... .. multiple maps for a single class 16:16:28 ... .. refer to table instead of query or view (where you don't need a query-created view) 16:17:23 ... .. allow queries instead of column names (e.g. in view def, you want only tuples with a given value for an attribute) 16:17:44 Souri: some discussion based upon cygri's comments 16:18:00 ... 3.1, makes sense, but URI templates isn't a standard yet 16:18:29 mhausenblas: if we use it, it will likely become an RFC 16:19:11 cygri: trivial matter, /foo/{attribute}/bar (in d2r, we used "@@"s) 16:19:31 Souri: the pattern should translate to a SQL expression 16:19:57 cygri: just a concatonation? 16:21:53 Souri: we should consider automatic derivation of the inverse expression 16:22:02 RRSAgent, draft minutes 16:22:02 I have made the request to generate http://www.w3.org/2010/08/24-rdb2rdf-minutes.html mhausenblas 16:22:29 Souri, per comment 3.2 16:23:03 Souri: per comment 3.2, we're talking about a viewmaps V1, V2, and i want them to be in the same class 16:23:30 ... that's an important requirement. we could define a superclass of C1 C2 16:23:34 Michael: note re URI templates - let's use http://tools.ietf.org/html/draft-gregorio-uritemplate as the URI (will always point to the latest version) 16:24:08 cygri: i think we're coflating two things: 16:24:56 ... .. i want to map staff and student to foaf:Person, i don't want to have to create new OWL classes for my:Staff and my:Person 16:26:49 Souri: it's like you want to hide the implied class from the generated schema 16:27:13 ... we could have instead compound class maps 16:28:15 cygri: that seems more complicated than just allowing one to map staff and student to foaf:Person 16:28:57 ericP: i think is a usability trade-off: simplicity of model vs. simplicty of user interface 16:29:06 mhausenblas: how much has this come up? 16:29:24 cygri: if you're mapping 50 tables, i expect it to come up at least once 16:29:59 Souri: for performance reasons, i want to be able to specify C1 (my:staff) 16:30:11 Zakim, unmute me 16:30:11 MacTed should no longer be muted 16:30:17 cygri: what's executed in the database will be the same 16:30:52 Souri: for foaf:Person, yes, but my requirement is to be able to restrict to myfoaf:StaffPerson 16:31:25 cygri: but that's a modeling issue. the model must be aware when they map lots of stuff to a common base class 16:32:29 ... frequently, i don't want to expose the schema of the database 16:33:06 q+ to paint a query in which the common base class doesn't cost anything 16:33:25 q+ to talk about test cases 16:34:03 Souri: if i define V1 and V2, there is a utility to have them distinguishable 16:34:19 q+ to suggest both plans are fine as options, but need clear declaration of what the trade-offs are 16:34:25 ack ericP 16:34:25 ericP, you wanted to paint a query in which the common base class doesn't cost anything 16:34:45 juansequeda: from DI of the 90s (Simms), each table becomes a class 16:36:10 q+ 16:37:11 ack me 16:37:11 mhausenblas, you wanted to talk about test cases 16:37:15 what if the two "sub" classes have shared attributes? 16:37:33 http://lists.w3.org/Archives/Public/public-rdb2rdf-wg/2010Aug/0034.html 16:38:00 what I am saying I guess translates to allowing "compound" classes 16:38:16 Souri, i think in any scenario you come up with, there will be some distinguishing characteristic in a realistic query 16:38:33 +1 ericP 16:38:53 mhausenblas: once we have a concrete spec, we can see how hard is the work implied by these trade-offs 16:38:55 q? 16:38:59 ack MacTed 16:38:59 MacTed, you wanted to suggest both plans are fine as options, but need clear declaration of what the trade-offs are 16:39:00 but, eric, in my query I may not be interested in the distinguishing characterstics 16:39:13 ... so we shoudl work on queries, tables, expected results 16:39:34 MacTed: the trade-off is a cost-benifit trade-off 16:39:39 Michael: we should start to collect TC (input RDB/output RDF) ASAP 16:39:59 ... do we know all the characteristics when we do the mapping? 16:40:11 q? 16:40:16 ack Souri 16:40:42 ... either demanding C1 and C2, or only C imposes on the user 16:41:39 Souri: it seems conceptually simpler to define unions on class maps 16:41:47 cygri: i think this compounds viewmaps 16:42:10 RRSAgent, draft minutes 16:42:10 I have made the request to generate http://www.w3.org/2010/08/24-rdb2rdf-minutes.html mhausenblas 16:42:23 ... saying this class can be populated from V1 and v2 is no simpler than saying that T1 and T2 are both Cs 16:42:38 ... it's a question of how to expose on the surface 16:43:38 ... { T1 a C . T2 a C . } is simpler and i don't think that demanding C1 and C2 is justified 16:44:33 Souri: if V1 is an unexposed classmap, i can update that later 16:45:10 cygri: but in { T1 a C . T2 a C . }, i can just s/T1 a C/T1 a C1/ when i discover i want to distinguish them 16:45:37 ... unexposed classmaps would imply a extra feature in the language 16:46:03 ... there are situations where a T doesn't map to any C 16:46:39 ... we discovered this during d2r use, so we removed the requirement that a "classmap" imply a class 16:46:46 ... so it really shouldn't be called a classmap 16:46:54 +1 to cygri 16:47:31 cygri: you have a view, and each row maps to triples makes more sense than structuring things around classes 16:48:05 cygri: can you remind me while people do not want to create a class? 16:48:16 ACTION: Souri to summarize the unionable classmap discussion in email 16:48:16 Sorry, couldn't find user - Souri 16:48:23 juansequeda: creating owl:sameAs triples from a DB 16:48:50 Zakim, mute me 16:48:50 MacTed should now be muted 16:49:06 Souri: per comment 3.3, agreed 16:49:32 cygri: if you can use URItemplates, then this [the feature in comment 3.3] becomes possible 16:49:56 Souri: per comment 3.4 (constant value for a property)... 16:50:09 cygri: so if I have in one source that #juan rdf:type foaf:person and if my info is in a database, all you would want is to say #student123 owl:sameas #juan and not have that #student123 rdf:type ex:Person or even #student123 rdf:type foaf:person ? 16:50:35 ... it makes sense, but how do we expose it in RDFS? owl:onProperty , owl:hasValue? 16:52:01 cygri: example: E t -> { x :worksFor :Acme } 16:52:35 topic: SQL injection 16:52:47 q? 16:52:52 q? 16:52:59 cygri: confused by this in the previous minutes 16:53:29 Souri: came up because, a referential constraint, it's always equality 16:53:49 ... i simplified and said *all* we need is the equijoin condition 16:55:03 ... if the mapping contains ("a.b=c.d"), you could be injecting some malicious code 16:55:18 ... but we can address that by parsing the constraints 16:55:48 ericP thinks this is a non-issue; that we face homogenous injection vulnerability throughout r2ml 16:56:35 Topic: Revised proposal from Souri 16:56:44 http://www.w3.org/2001/sw/rdb2rdf/wiki/Example_of_SQL-based_RDB2RDF_Mapping:_Revision_1 16:56:57 XML Schema Revision 1: http://www.w3.org/2001/sw/rdb2rdf/wiki/An_XML_Schema_for_SQL-based_RDB2RDF_Mapping_%28Revision_1%29 16:57:16 cygri: in d2rq, you right down the join condition, but we need to know the direction of the foreign key constraint 16:57:21 Souri: that has to be there 16:57:32 example revision 1: http://www.w3.org/2001/sw/rdb2rdf/wiki/Example_of_SQL-based_RDB2RDF_Mapping:_Revision_1 16:58:07 ... in the example, we have child and parent, so we can derive the alias for substitution 16:59:19 16:59:36 mhausenblas: postponing remaining topics for next meeting 16:59:44 topic: test cases 16:59:54 mhausenblas: harry sent mail about test cases 17:00:16 ... we need someone to collect, document and package test cases 17:00:48 RRSAgent, draft minutes 17:00:48 I have made the request to generate http://www.w3.org/2010/08/24-rdb2rdf-minutes.html mhausenblas 17:00:50 ... (i've done it in two previous WGs; essential work) 17:00:56 ADJOURNED 17:01:01 RRSAgent, draft minutes 17:01:01 I have made the request to generate http://www.w3.org/2010/08/24-rdb2rdf-minutes.html ericP 17:01:11 RRSAgent, list attendees 17:01:11 I'm logging. I don't understand 'list attendees', mhausenblas. Try /msg RRSAgent help 17:01:28 Zakim, list attendees 17:01:28 As of this point the attendees have been +3539149aaaa, mhausenblas, nunolopes, boris, cygri, Souri, ericP, juansequeda, dan, MacTed 17:01:41 Zakim, who's here? 17:01:41 On the phone I see mhausenblas, Souri, EricP, MacTed (muted) 17:01:42 EricP has ericP, juansequeda, dan 17:01:44 mhausenblas has mhausenblas, nunolopes, boris, cygri 17:01:45 On IRC I see Angela, cygri, boris, Zakim, RRSAgent, juansequeda, mhausenblas, MacTed, LeeF, iv_an_ru, ericP, trackbot 17:01:52 -Souri 17:02:21 RRSAgent, list attendees 17:02:21 I'm logging. I don't understand 'list attendees', mhausenblas. Try /msg RRSAgent help 17:02:25 RRSAgent, draft minutes 17:02:25 I have made the request to generate http://www.w3.org/2010/08/24-rdb2rdf-minutes.html mhausenblas 17:03:51 Zakim, who's here? 17:03:51 On the phone I see mhausenblas, EricP, MacTed (muted) 17:03:52 EricP has ericP, juansequeda, dan 17:03:53 mhausenblas has mhausenblas, nunolopes, boris, cygri 17:03:55 On IRC I see cygri, Zakim, RRSAgent, juansequeda, mhausenblas, MacTed, LeeF, iv_an_ru, ericP, trackbot 17:04:02 ScribeOptions: -final -noEmbedDiagnostics 17:04:08 RRSAgent, draft minutes 17:04:08 I have made the request to generate http://www.w3.org/2010/08/24-rdb2rdf-minutes.html mhausenblas 17:04:40 http://www.w3.org/2001/sw/rdb2rdf/directGraph/#alg 17:06:21 -MacTed 17:06:32 ericP: once you got this down, we need to start emailing about putting both our stuff together 17:06:40 agreed 17:08:09 I have some stuff here: http://www.w3.org/2001/sw/rdb2rdf/wiki/Default_Mapping 17:08:28 http://www.w3.org/2001/sw/rdb2rdf/directGraph/#emp-addr 17:22:35 cygri has joined #rdb2rdf 17:46:13 cygri has joined #rdb2rdf 18:08:43 http://swobjects.svn.sourceforge.net/viewvc/swobjects/branches/sparql11/tests/healthCare/lists-notBound/db-hl7.rq?revision=1184&view=markup 18:11:46 http://swobjects.svn.sourceforge.net/viewvc/swobjects/branches/sparql11/tests/test_QueryMap.cpp?revision=1211&view=markup#l479 18:12:35 http://swobjects.svn.sourceforge.net/viewvc/swobjects/branches/sparql11/tests/healthCare/lists-notBound/db.rq 18:12:48 http://swobjects.svn.sourceforge.net/viewvc/swobjects/branches/sparql11/tests/healthCare/lists-notBound/hl7.rq 18:13:11 http://swobjects.svn.sourceforge.net/viewvc/swobjects/branches/sparql11/tests/healthCare/lists-notBound/db.sql 18:33:25 -EricP 18:33:26 -mhausenblas 18:33:26 SW_RDB2RDF()12:00PM has ended 18:33:28 Attendees were +3539149aaaa, mhausenblas, nunolopes, boris, cygri, Souri, ericP, juansequeda, dan, MacTed 18:36:51 cygri has joined #rdb2rdf 19:27:16 Zakim has left #rdb2rdf 20:00:58 cygri has joined #rdb2rdf 22:37:49 cygri has joined #rdb2rdf