W3C

- DRAFT -

RDB2RDF Working Group Teleconference

02 Mar 2010

Agenda

See also: IRC log

Attendees

Present
[IPcaller], whalb, +1.562.249.aaaa, juansequeda, mhausenblas, +49.322.222.0.aabb, cygri, nunolopes, +1.603.897.aacc, MacTed, +39.046.128.aadd, Ashok_Malhotra, Souri, EricP, hhalpin
Regrets
Seema
Chair
Ahmed
Scribe
hhalpin

Contents


<trackbot> Date: 02 March 2010

<mhausenblas> iv_an_ru: are you ready to scribe?

<mhausenblas> hhalpin seems iv_an_ru can't make it - can you scribe, please?

<MacTed> something didn't start right ...

<mhausenblas> scribenick: hhalpin

Admin

<mhausenblas> PROPOSAL: accept minutes http://www.w3.org/2010/02/23-rdb2rdf-minutes.html

thanks!

<ericP> +1

ACCEPTED: as minutes Feb 23rd: http://www.w3.org/2010/02/23-rdb2rdf-minutes.html

<mhausenblas> Open actions http://www.w3.org/2001/sw/rdb2rdf/track/actions/open

<mhausenblas> ACTION-19?

<trackbot> ACTION-19 -- Harry Halpin to put Souri's draft into a WBS poll and notify the WG -- due 2010-01-19 -- OPEN

<trackbot> http://www.w3.org/2001/sw/rdb2rdf/track/actions/19

Souri, what that's a draft of?

Souri: describe the SQL approach
... what is the SQL-based approach?
... relevance of the action has been taken of

<ericP> juansequeda, any interest in working with the FeDeRate code?

Souri: working as a sub-groups already
... to note differences

<mhausenblas> close ACTION-19

<trackbot> ACTION-19 Put Souri's draft into a WBS poll and notify the WG closed

<juansequeda> ericP, lets talk afterwards

<mhausenblas> ACTION-28?

<trackbot> ACTION-28 -- Harry Halpin to check on dependencies with non-free ISO -- due 2010-03-02 -- OPEN

<trackbot> http://www.w3.org/2001/sw/rdb2rdf/track/actions/28

<mhausenblas> done by Harry, see http://lists.w3.org/Archives/Public/public-rdb2rdf-wg/2010Feb/0028.html

<mhausenblas> ACTION-28?

<trackbot> ACTION-28 -- Harry Halpin to check on dependencies with non-free ISO -- due 2010-03-02 -- CLOSED

<trackbot> http://www.w3.org/2001/sw/rdb2rdf/track/actions/28

<mhausenblas> ACTION-29?

<trackbot> ACTION-29 -- Eric Prud'hommeaux to create Wiki page for RDF team and link from homepage -- due 2010-03-02 -- OPEN

<trackbot> http://www.w3.org/2001/sw/rdb2rdf/track/actions/29

<mhausenblas> ACTION-29?

<trackbot> ACTION-29 -- Eric Prud'hommeaux to create Wiki page for RDF team and link from homepage -- due 2010-03-09 -- OPEN

<trackbot> http://www.w3.org/2001/sw/rdb2rdf/track/actions/29

<ericP> Feb 09 minutes

ericP: old minutes from last week, approved last meeting

<mhausenblas> thanks a lot for this, ericP
...: Do we have a wiki-page for the SQL team?

soeren: so far we have a wiki page, its a bit unorganized
... but basically its the same ideas, trying to align our syntax

<Souri> http://www.w3.org/2001/sw/rdb2rdf/wiki/RDB-to-RDF_mapping:_A_SQL-based_Approach

soeren: so then our goals can be merged and aligned.

<Souri> http://www.w3.org/2001/sw/rdb2rdf/wiki/R2RML_SQL_View_Annotation

ericP: trying to figure out what to put in this page

<ericP> http://dvcs.w3.org/hg/FeDeRate/file/636ceb7f6d4d/src/test/scala/SparqlToSparqlToSqlTest.scala#l83

<ericP> http://dvcs.w3.org/hg/FeDeRate/file/636ceb7f6d4d/src/test/scala/SparqlToSparqlToSqlTest.scala#l83

hhalpin: we'd just need an English-language spec-like text for the code that is under development

ericP: I'm happy to document
... test-cases are the most important

+1 test cases

<ericP> test case

<ericP> resulting view

Souri: We want a mapping portion description without looking at query, so for example, D2RQ used some mappings.
... I don't see it or it's not very prominent

ericP: line 72, line 80

val view = toView(List(hr2foaf), HR, StemURI("http://hr.example/DB/"))

ericP: we just take stem URI and map the SPARQL query to SQL

juansequada: yes, that's very close to Ultrawrap

ericP: is this consistent for the expressivity we need?, re ultrawrap and/or tripify?

thats pretty different from what we have in mind

soeren: we don't have a triple table, we have a sql table
... not just a view, just the base table
... this is the most common-case

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

soeren: we are working on that now

ericP: I am also looking at expressivity, want to see if we match the expressivitiy we want
... discuss expressivity and common gaps

<Souri> http://www.w3.org/2001/sw/rdb2rdf/wiki/RDB-to-RDF_mapping:_A_SQL-based_Approach

souri: the main difference between ericP and us in DDL
... go down to bottom of the page
... the main thing connected with SQL is the strings, instance URIs, and connecting to
... via the XML the class and its propertie sto the SQL database
... and then we describe the object propertie s etc.
... this is the maping what is the schema?
... what is the schema that people will see even if they do not kniw underlying data?

ericP: I'd like to see the DDL that this sis supposed to run over

Souri: I can put dictionary info on there for integrity constraints
... we have more or less agreement on this, DTD or XML Schema
... finally what we generate is RDF schema for us all to see

juansequada: I have a FOL paper that shows this off in Datalog

ericP: you got soundness and completeness for arbitrary SQL schema to RDF schema

<Marcelo> me

Marcelo: Yes, my paper shows the mapping

ericP: My question is whether or not predicates are labelled in table or derived from some function of column heading

<Marcelo> actually, it is not Caludio Gutierrez's paper, it is Claudio Gutierrez's paper

Can we post a link to the paper?

to IRC

<Marcelo> This is the paper: R. Angles, C. Gutierrez, The Expressive Power of SPARQL International Semantic Web Conference 2008.

Souri: the way we are translating this it is not doing it as a 2-way join, both are going back to same table
... common domains
... have a normalized schema

<Marcelo> link to the paper: http://www.dcc.uchile.cl/~cgutierr/papers/expPowSPARQL.pdf

Souri: properties from the same row, as if join had been pre-done and sitting there in shortage

ericP: I'd like to see use-cases
... stuck in some for BioPax

<angela> i will put mine tomorrow

ericP: would like to see all the use-cases

Souri: We will definitely augment it to show peopl, hat we are thinking

ericP: We need a use-case

T+7: Requirements and Use Cases for the RDB2RDF Mapping Language (R2RML)

<Souri> We'll add dictionary info for the tables and the RDF schema that gets generated from the specified mapping (for the SPARQL query writer)

ericP: should we push something for 3 months

mhausenblas: We could then get out use-cases as soon as possible

Note that the use-cases will be technically separate from the test-cases, which we will keep adding through the life of the project

So let's push out a use-case document

by end of the month, and then a month to finalize into requirements

ericP: Soeren, can you put this Web-pubishing schemas over the doc

juansequada: We are testing the berlin benchmark
... we have some r&a databases to the world
... we could use.

ericP: Not sure if we want Berlin SPARQL benchmark in use-case, so let's leave that out.

Ahmed: I like the use-case that had integration from multiple data-sources

Angela: I can put that use-case in tomorrow

should we make these actions??

<scribe> ACTION: angela to put up data integration use-case [recorded in http://www.w3.org/2010/03/02-rdb2rdf-minutes.html#action01]

<trackbot> Created ACTION-30 - Put up data integration use-case [on Angela Fogarolli - due 2010-03-09].

tables, triples, and approach

<scribe> ACTION: Soeren web-publishing use-case [recorded in http://www.w3.org/2010/03/02-rdb2rdf-minutes.html#action02]

<trackbot> Sorry, couldn't find user - Soeren

<scribe> ACTION: juansequada RNA alignment sequence use-cases [recorded in http://www.w3.org/2010/03/02-rdb2rdf-minutes.html#action03]

<trackbot> Sorry, couldn't find user - juansequada

<scribe> ACTION: juansequada RNA alignment sequence use-cases [recorded in http://www.w3.org/2010/03/02-rdb2rdf-minutes.html#action04]

<trackbot> Sorry, couldn't find user - juansequada

<scribe> ACTION: jsequada RNA alignment sequence use-cases [recorded in http://www.w3.org/2010/03/02-rdb2rdf-minutes.html#action05]

<trackbot> Sorry, couldn't find user - jsequada

<scribe> ACTION: sequada RNA alignment sequence use-cases [recorded in http://www.w3.org/2010/03/02-rdb2rdf-minutes.html#action06]

<trackbot> Sorry, couldn't find user - sequada

<scribe> ACTION: jsequeda RNA alignment sequence use-cases [recorded in http://www.w3.org/2010/03/02-rdb2rdf-minutes.html#action07]

<trackbot> Created ACTION-31 - RNA alignment sequence use-cases [on Juan Sequeda - due 2010-03-09].

<scribe> ACTION: sauer use-case for web-publishing [recorded in http://www.w3.org/2010/03/02-rdb2rdf-minutes.html#action08]

<trackbot> Created ACTION-32 - Use-case for web-publishing [on Sören Auer - due 2010-03-09].

if we can push even a working draft out then we can push it

mhausenblas: ok to do it manually

just note that its use-case is a Working Group document

Working Group Note rather than Rec-track draft

ericP: publish early and often

Ahmed: I think it's useful to do any updates as early as possible

ericP: let's aim for Sunday night

Marcelo: I am having some trouble with the 12-1 time, could we switch to another time?

ericP: 1-2 time?

18-19: 00UTC

juansequada: I can't.

Ahmed: All week except Tuesday we're booked

Souri: If it doesn't work, I'll somehow manage, with new meetings coming in.

what is the concrete option?

options?

<Souri> Thursday anytime is good for me

hmmm

<scribe> ACTION: Harry to find old WBS in order to help determine what schedule works [recorded in http://www.w3.org/2010/03/02-rdb2rdf-minutes.html#action09]

<trackbot> Created ACTION-33 - Find old WBS in order to help determine what schedule works [on Harry Halpin - due 2010-03-09].

Ahmed: 8-9 AM Tuesdays

<Souri> Tues 11-12 is ok for me

Ahmed: is only time that works for me.

<Souri> 11-12 EST (sorry)

<mhausenblas> 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

Summary of Action Items

[NEW] ACTION: angela to put up data integration use-case [recorded in http://www.w3.org/2010/03/02-rdb2rdf-minutes.html#action01]
[NEW] ACTION: Harry to find old WBS in order to help determine what schedule works [recorded in http://www.w3.org/2010/03/02-rdb2rdf-minutes.html#action09]
[NEW] ACTION: jsequada RNA alignment sequence use-cases [recorded in http://www.w3.org/2010/03/02-rdb2rdf-minutes.html#action05]
[NEW] ACTION: jsequeda RNA alignment sequence use-cases [recorded in http://www.w3.org/2010/03/02-rdb2rdf-minutes.html#action07]
[NEW] ACTION: juansequada RNA alignment sequence use-cases [recorded in http://www.w3.org/2010/03/02-rdb2rdf-minutes.html#action03]
[NEW] ACTION: juansequada RNA alignment sequence use-cases [recorded in http://www.w3.org/2010/03/02-rdb2rdf-minutes.html#action04]
[NEW] ACTION: sauer use-case for web-publishing [recorded in http://www.w3.org/2010/03/02-rdb2rdf-minutes.html#action08]
[NEW] ACTION: sequada RNA alignment sequence use-cases [recorded in http://www.w3.org/2010/03/02-rdb2rdf-minutes.html#action06]
[NEW] ACTION: Soeren web-publishing use-case [recorded in http://www.w3.org/2010/03/02-rdb2rdf-minutes.html#action02]
 
[End of minutes]

Minutes formatted by David Booth's scribe.perl version 1.135 (CVS log)
$Date: 2010/03/02 18:12:53 $

Scribe.perl diagnostic output

[Delete this section before finalizing the minutes.]
This is scribe.perl Revision: 1.135  of Date: 2009/03/02 03:52:20  
Check for newer version at http://dev.w3.org/cvsweb/~checkout~/2002/scribe/

Guessing input format: RRSAgent_Text_Format (score 1.00)

Succeeded: s/soeren/ericP/
Succeeded: s/SourI/Souri/
Succeeded: s/my paper/Caludio Gutierrez's paper/
Succeeded: s/happy/ok/
Succeeded: s/Marcelo/Souri/
Found ScribeNick: hhalpin
Inferring Scribes: hhalpin
Default Present: [IPcaller], whalb, +1.562.249.aaaa, juansequeda, mhausenblas, +49.322.222.0.aabb, cygri, nunolopes, +1.603.897.aacc, MacTed, +39.046.128.aadd, Ashok_Malhotra, Souri, EricP, hhalpin
Present: [IPcaller] whalb +1.562.249.aaaa juansequeda mhausenblas +49.322.222.0.aabb cygri nunolopes +1.603.897.aacc MacTed +39.046.128.aadd Ashok_Malhotra Souri EricP hhalpin
Regrets: Seema
Agenda: http://lists.w3.org/Archives/Public/public-rdb2rdf-wg/2010Mar/0000.html
Found Date: 02 Mar 2010
Guessing minutes URL: http://www.w3.org/2010/03/02-rdb2rdf-minutes.html
People with action items: angela harry jsequada jsequeda juansequada sauer sequada soeren

[End of scribe.perl diagnostic output]