DESENVOLVIMENTO DE UMA FERRAMENTA PARA MIGRAÇÃO DE DADOS ENTRE BANCOS DE DADOS RELACIONAIS

• Main Authors: Tamiris Fernanda Malacrida, Aglaê Pereira Zaupa, Mário Augusto Pazoti
• Format: Article
• Language: Portuguese
• Published: Universidade do Oeste Paulista 2014-06-01
• Series: Colloquium Exactarum
• Subjects: database; data migration; relational data models
• Online Access: http://revistas.unoeste.br/revistas/ojs/index.php/ce/article/view/1015/1106

With the exponential rise on the use of computers recently, different technologies on data management have appeared as well. Apart from the existent data storage type, what used to be the best solution, nowadays, can not be viable anymore due to financial, strength questions or compatibility with the new technologies. In this case, arises the need, in a big scale, of data migration between databases. Therefore, this work aims to the development of a tool that will support the user during the exchange from a relational database to another, as well as the data reengineering, aiming in keep the data straightforward. The tool main purpose is to enable the tables, attributes and relationships that composes the old database be mapped according to the elements in the new modeling, taking in account that the data be transported to the new database management system in a semi automated way, always preserving the integrity of the data base.