RETOO: Translating relational to object-oriented database conceptual schema

The existence of multiple, hete rogeneous and autonomous databases within an organization means the globally important information exists in separate local database management systems (DBMSs), thus making the existing data inaccessible to remote users.One solution is to integrate these databases in order to form a single cohesive definition of a multi-database.Most of the integration is done by translating one database conceptual schema into another.In this paper, we will discuss a set of translation rules proposed to translate relational database conceptual schema into object-oriented database conceptual schema.A prototype called RElational-To-Object-Oriented (RETOO) has been developed based on our translation rules

Uma proposta de sistema de software para auxílio na geraçao de tranformaçoes de formalismo BAV para integraçao de bancos de dados

Orientador: André Luiz Pires GuedesDissertaçao (mestrado) - Universidade Federal do Paraná, Setor de Ciencias Exatas, Programa de Pós-Graduaçao em Informática. Defesa: Curitiba, 2004Inclui bibliografia e anexosRESUMO O objetivo da integra¸c˜ao de bancos de dados 'e fornecer uma interface integrada e uniforme para consultas em diversos bancos de dados que descrevam os mesmos objetos do mundo real. O formalismo "both as view"(BAV) foi desenvolvido de modo a ser aplicado em esquemas de bancos de dados para realizar a sua integraçao. Seu funcionamento se caracteriza por ver o processo de integra¸c˜ao como uma sequência de transforma¸c˜oes revers'?veis que modificam tanto o esquema como as instˆancia do banco de dados. Este trabalho apresenta uma proposta de sistema de software que automatiza parcialmente o processo de integra¸c˜ao, auxiliando o administrador de banco de dados na tarefa de integra¸c˜ao, guiando-o pelo processo de gerar transforma¸c˜oes e consultando-o em momentos em que seja imposs'?vel para o sistema tomar uma decis˜ao. Al'em disso s˜ao apresentados estudos realizados sobre o formalismo BAV e sua aplica¸c˜ao nos casos de conflito entre esquemas de bancos de dados.ABSTRACT The objective of the database integration is to supply an integrated uniform interface to consultations in diverse databases that describe same objects of the real world. The formalism "both view"(BAV) was developed in order to be applied in schemas during the process of databases integration. Its functionality characterizes for seeing the integration process as a sequence of reversible transformations that modify the schema and the instances of the data base. This work presents a proposal of system software that automatizes the integration process partially, assisting the user in the integration process, guiding him to generate transformations and consulting it at moments where the system can not take a decision. Moreover are presented studies about the BAV formalism and its applications in the cases of conflict between database schemas

Automatic Migration and Wrapping of Database Applications - a Schema Transformation Approach

Both the federated approach and the mediator approach to database integration require that semantic differences between schemas be resolved by a process of schema transformation. Data, queries and updates subsequently passed between schemas need to be transformed accordingly. We have developed a general framework to support the schema transformation process. This framework consists of a graph-based common data model and a set of primitive schema transformations defined for this model. Higher-level common data models and primitive schema transformations for them can be defined in terms of this lower-level model. Primitive transformations can be composed into composite ones. This paper gives an overview of our framework and then shows how to define an EntityRelationship common data model and schema transformations on it. The key feature of our framework is that both primitive and composite schema transformations are automatically reversible. We show how these transformations can be used..