W3C home > Mailing lists > Public > public-xg-eiif@w3.org > October 2008

Re: Schema Mapping Tools

From: <paola.dimaio@gmail.com>
Date: Tue, 28 Oct 2008 17:54:39 +0700
Message-ID: <c09b00eb0810280354h536d7149r751f19e2e492cc3@mail.gmail.com>
To: "Carl Reed" <creed@opengeospatial.org>
Cc: "Chamindra de Silva" <chamindra@opensource.lk>, public-xg-eiif <public-xg-eiif@w3.org>
Thanks Carl, I am working on something related to that (arent we all?)

Chamindra, I think to answer your question, you may have to establish
what kind of schemas you want to map

If we are talking about database schemas, thats one thing - from the
documentation posted here it looks like that's the case. I think all
database managment systems such as oracle
have database mapping functionalities, and I am sure there must be some OS
ones

lots of other tools are available, best suited to the type of schema that is
being matched
such as xml, or rdf etc but I am not sure that's what you are looking for

please let us know when you find out

pdm



On Tue, Oct 28, 2008 at 12:40 AM, Carl Reed <creed@opengeospatial.org>wrote:

>
> Chamindra -
>
> An example of the OGC related discussions on this topic. I forgot to send
> my lst email to the entire group. Apologies.
>
> Regards
>
> Carl
>
> In response to a number or requests from Australians in the Geospatial
> sector, I've written a high level description about the benefits of
> Community Schemas for solving data integration issues. I suspect many on
> this list will also be interested.
>
>
>  Community Schemas: Making sense out of disparate data sets
>
> With so many organizations publishing geospatial datasets using
> standards based web services, a raft of new opportunities for large
> scale data analysis are presenting themselves. The challenge now is
> integrating the datasets which use different terms and attributes to
> describe the same data. For example, "water quality" (good, medium, bad)
> in one database might equate to "pollution level" (1,2,3,4,5) in another.
> ...
> The rest of the essay can be viewed at:
>
> http://cameronshorter.blogspot.com/2008/10/community-schemas-making-sense-out-of.html
>
> As always, comments and feedback will be welcomed.
>
> --
> Cameron Shorter
> Geospatial Systems Architect
>
> ----- Original Message ----- From: "Chamindra de Silva" <
> chamindra@opensource.lk>
> To: "public-xg-eiif" <public-xg-eiif@w3.org>
> Sent: Monday, October 27, 2008 12:25 AM
> Subject: Schema Mapping Tools
>
>
>
>
>> Hi All,
>>
>> Does anyone know any good schema mapping tools (and methodologies)? I
>> know we discussed something at the level of an ontology (e.g.
>> Protege), however I more interested in finding a mechanism of mapping
>> between two systems (Sahana and OCHA 3W) using existing interop
>> standards (e.g. PFIF, EDXL). I am sure there is a well defined
>> approach to solve this problem. Would ETL tools help in this instance?
>>
>> Mandana gave me some tips below, but let me know if you know of any
>> others.
>>
>> On Mon, Oct 27, 2008 at 3:11 AM, Mandana Sotoodeh <mandanas@ece.ubc.ca>
>> wrote:
>>
>>> Hi Chamindra,
>>>
>>>
>>>
>>> The keywords you can search for are schema matching, schema mapping,
>>> schema
>>> integration. They are under more general topics of semantic
>>> integration/interoperability and model management. Please note these
>>> techniques and tools are designed to deal with large schemas or models,
>>> however reading them can reveal the kind of problems and challenges they
>>> encounter in such operations.
>>>
>>>
>>>
>>> 1- A general overview on the concept
>>>
>>> AnHai Doan, Alon Y. Halevy: Semantic Integration Research in the Database
>>> Community: A Brief Survey. AI Magazine 26(1): 83-94 (2005)
>>> http://pages.cs.wisc.edu/~anhai/papers/si-survey-db-community.pdf<http://pages.cs.wisc.edu/%7Eanhai/papers/si-survey-db-community.pdf>
>>>
>>>
>>>
>>> 2- A general overview on the technologies
>>>
>>>
>>>
>>> By Philip A. Bernstein and Laura M. Haas, Information integration in the
>>> enterprise. Communications of the ACM.
>>>
>>>
>>>
>>>
>>> http://portal.acm.org/citation.cfm?id=1378727.1378745&coll=GUIDE&dl=GUIDE&CFID=8137977&CFTOKEN=55643128
>>>
>>>
>>>
>>>
>>>
>>> 3- A sample tool: Harmony. This one is from MITRE corporation. I haven't
>>> worked with this or other commercial tools personally.
>>>
>>>
>>>
>>> Peter Mork, Arnon Rosenthal, Len Seligman, Joel Korb, Ken Samuel:
>>> Integration Workbench: Integrating Schema Integration Tools. Proceedings
>>> of
>>> the 22nd International Conference on Data Engineering Workshops
>>> (ICDEW'06)
>>>
>>>
>>>
>>> http://www.cs.wisc.edu/dbworld/messages/2006-11/1162933857.html
>>>
>>>
>>>
>>> You can find more information by looking at their references.
>>>
>>>
>>>
>>> I'm not sure if it's useful to you, but on the ontology side, Protégé has
>>> a
>>> plug-in named PROMPT for ontology mapping.
>>>
>>>
>>>
>>> Renato, do you deal with semantic interoperability issues in the system
>>> you
>>> have developed in NICTA?
>>>
>>>
>>>
>>> Regards,
>>>
>>> Mandana
>>>
>>
>>
>>
>
>


-- 
Paola Di Maio
School of IT
www.mfu.ac.th
*********************************************
Received on Tuesday, 28 October 2008 10:55:20 GMT

This archive was generated by hypermail 2.2.0+W3C-0.50 : Tuesday, 28 October 2008 10:55:20 GMT