Re: Data conversion between various schemas
Date: Mon, 07 Oct 2002 13:37:20 +1000
Message-ID: <3DA10170.4000300_at_csse.monash.edu.au>
Clio is indeed a leading product/technology in this field.
I'm curious to know, however, if the data conversion is once and for all or if it must be via a dynamic system on top of the existing databases.
In the absence of sufficient budget (wasn't clear from the query if this was an issue at all), my hacking instincts would make me try using a static application that connects to the databases via JDBC and converts the data via SQL. I'm talking about abandoning the original database, though, and there would be wide assumptions about the conversions that the application is capable of. In fact the application may have to be rewritten for every pair of databases to convert between.
Full-blown prototypes that are a lot more dynamic do exist. Try searching the web for the following keywords:
multidatabases, federated databases, schema mapping, schema integration, intelligent integration of information
Some major projects I've heard of, aside from Clio, are:
AURORA (Uni of Alberta, Canada)
TSIMMIS (Stanford Uni, IBM)
Ariadne and SIMS (Uni. of South California)
CARNOT and Infosleuth (Microelectronics and Computer Technology Corp.)
OBSERVER (EHU, Spain)
You can find papers for them at:
Good luck!
cheers,
Jeff
Ariel Fuxman wrote:
> On Mon, 15 Jul 2002 14:31:19 -0400, Peter Skvarenina wrote:
>
>
>>I would like to ask, if there exist some papers with the topic of >>general DB conversion according to different source and target schemas.
>
>
> We have a research project called Clio, that deals with precisely this
> problem. It is a joint project between University of Toronto and IBM
> Almaden. We have a number of papers on this subject (called "schema
> mapping"). You can find them, and also more info on the project at
>
>
> http://www.cs.toronto.edu/db/clio/
>
> Also, is there any possibility that you share some examples of the
> source and target schemas you were trying to map? We would be very
> interested in applying our tool to examples from people who have already
> faced the problem of schema mapping.
>
> Let me know if you need any additional information,
>
> Ariel Fuxman.
>
>
>
>
>
>>I need to create system that converts data between two different >>schemas. I have fixed target schema and various source schemas, that >>represent some subset (not always) of information that can be expressed >>by the target schema.
>
-- Jeff Tan Ph :(61 3) 99031405 Computer Science & Software Engineering Fax:(61 3) 99031077 Monash University Mob:(61 409) 567113Received on Mon Oct 07 2002 - 05:37:20 CEST