RE: ISSUE-3

Hi Angelo,

Data integration involves more than just mapping data types.  At high-level this involves:

1. Mapping SQL data and object types to RDF/OWL
2. Mapping SPARQL to SQL
3. Federation capability including reconciling the graph fragments coming back from the different data sources, i.e., what is called "Home Address" in one data source is equivalent to "Resident Address" in another, etc.  which will require some form of rule engine; this is similar to the traditional MDM function in current environment.

The SPARQL team is putting the foundation for federation by enriching the SPARQL endpoint capability.

Our WG is focused mainly on item (1).
Regards,

Ahmed


-----Original Message-----
From: public-rdb2rdf-wg-request@w3.org [mailto:public-rdb2rdf-wg-request@w3.org] On Behalf Of Fogarolli Angela
Sent: Thursday, November 12, 2009 08:30
To: ashok.malhotra@oracle.com
Cc: RDB2RDF WG
Subject: Re: ISSUE-3

Thanks Ashok , Yes, I am talking about relational databases.
It would be nice to understand if the issue is already covered and to
which extend.

Thanks again.
Angela.



On Thu, Nov 12, 2009 at 4:51 PM, ashok malhotra
<ashok.malhotra@oracle.com> wrote:
> Hello Angela:
> Just to be clear, you are speaking about multiple relational databases,
> right?
> If so, several existing tools solve that problem.  I will let the owners of
> the tools
> speak for themselves.
>
> If you are talking about a mixture of relational and non-relational
> databases, then that
> is a more difficult problem.  I don't think our work on the WG will address
> that.
> All the best, Ashok
>
>
> Fogarolli Angela wrote:
>>
>> Hi all,
>> I am new to the group so I don't know if I understood correctly the
>> previous work done by the group and the objectives. I would like to
>> ask some questions for clarifying a couple of points related to the
>> issue came up during the last conference call which is about the
>> Mapping Language we should deliver.
>> I apologize if I am misunderstood or if this is not focused on the
>> objectives of the group.
>> I am currently leading a data integration project at the instance
>> level using the OKKAM infrastructure. We were thinking to use D2R for
>> avoiding the implementation of a big KB.
>> A big issue I see also in this experience is the necessity to run
>> queries on multiple data sources.
>> From the project presentations we listened to till now it emerged that
>> we are able to map databases to RDF but we are not able to connect
>> them so we are not able to run queries which span multiple databases
>> (please, tell me if I am wrong...I am not an expert, just trying to
>> clarify to myself some ideas in order to be helpful in the future).
>> I was thinking that since it's possible to decompose queries using
>> relational algebra and this mapping should be an objective of this
>> group (?) then the same mapping could be used to understand to which
>> database (or sparql endpoint) to send a piece of query.
>> I am not sure that this problem is part of the objectives of this
>> group, even though I think that the data integration issue should be
>> addressed, as written in the W3C RDB2RDF Incubator Group Report
>> http://www.w3.org/2005/Incubator/rdb2rdf/XGR-rdb2rdf/  (point 1.1.3
>> Integration of Enterprise Information Systems)
>> My question is:
>> Could the mapping delivered by this group also solve (or provide a way
>> to solve) the problem of the sparql federated queries ? I think this
>> will be extremely important for implemented the linked data idea.
>> In my point of view once we have created a mapping from sparql to sql
>> then this can also be re-used for implemented federated queries.
>>
>> Thanks in advance.
>> Angela
>>
>> On Thu, Nov 12, 2009 at 2:33 PM, ashok malhotra
>> <ashok.malhotra@oracle.com> wrote:
>>
>>>
>>> Hello Ahmed:
>>> I envision that the work of the WG is one-way: from RDB to RDF/OWL.
>>> So, to answer your question, I do not envision creating SQL tables in the
>>> RDBMS from SPARQL application using R2RML.
>>> All the best, Ashok
>>>
>>>
>>> Ezzat, Ahmed wrote:
>>>
>>>>
>>>> Hi Ashok,
>>>>
>>>> Thanks for the follow up. I agree with your clarification regarding the
>>>> mapping SPARQL to SQL is out of scope; having discussion about it if the
>>>> team want to pursue is fine - I am trying to separate what we discuss,
>>>> with
>>>> time constraints, from what we will commit to deliver which we need to
>>>> pin
>>>> down early 2010.
>>>>
>>>> I liked the D2R presentation scope in the mapping area; is reasonable.
>>>>
>>>> Regarding DDL statements mapping support: do you envision creating SQL
>>>> tables in the RDBMS from SPARQL application using R2RML or do you
>>>> envision
>>>> the ability through the R2RML to read the different schema objects
>>>> definitions in the RDBMS from a SPARQL application?  I agree that the
>>>> latter
>>>> is a must and would be interested in getting your input as well as
>>>> others on
>>>> the first.
>>>> Regards,
>>>>
>>>> Ahmed
>>>>
>>>>
>>>> -----Original Message-----
>>>> From: public-rdb2rdf-wg-request@w3.org
>>>> [mailto:public-rdb2rdf-wg-request@w3.org] On Behalf Of ashok malhotra
>>>> Sent: Wednesday, November 11, 2009 13:58
>>>> To: RDB2RDF WG
>>>> Subject: ISSUE-3
>>>>
>>>> Since the goal of the WG is to create a mapping from RDB Schemas to
>>>> RDF/OWL classes, perhaps
>>>> we should rephrase the bullet point in the requirements as
>>>>
>>>>   * The mapping language MUST define the set of SQL DDL
>>>>     to be supported in the first release. The set to be supported
>>>>     SHOULD be as complete as possible and be defined as soon as
>>>>     possible after the WG official launch.
>>>>
>>>> This will let us exclude Table Types if we wish.
>>>>
>>>> I apologize that the original bullet was interpreted to mean that the
>>>> the
>>>> WG should define
>>>> a mapping from SPARQL to SQL.  That was not the intention.  In my view,
>>>> the mapping of
>>>> SPARQL to SQL should be left open as a technology on which various
>>>> implementations
>>>> can compete. .
>>>>
>>>>
>

Received on Thursday, 12 November 2009 16:34:40 UTC