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

Re: Schema Mapping Tools

From: Carl Reed <creed@opengeospatial.org>
Date: Mon, 27 Oct 2008 11:40:17 -0600
Message-ID: <78842B820E7B4403A29FBBBB0E338DD1@CarlandSusieOf>
To: "Chamindra de Silva" <chamindra@opensource.lk>, "public-xg-eiif" <public-xg-eiif@w3.org>

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
>>
>>
>>
>> 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
>
> 
Received on Monday, 27 October 2008 17:40:56 GMT

This archive was generated by hypermail 2.2.0+W3C-0.50 : Monday, 27 October 2008 17:40:56 GMT