Legacy-DB: A tool for validating data migration in heterogeneous databases

• Marlon Duarte Federal University of Ceará (UFC)
• Gustavo Moraes Federal University of Ceará (UFC)
• Amanda D. P. Venceslau Federal University of Ceará (UFC) https://orcid.org/0000-0003-4118-4224
• Wellington Franco Federal University of Ceará (UFC)
• Paulo A. L. Rego Federal University of Ceará (UFC)
• Paulo Honório Federal University of Ceará (UFC)

DOI: https://doi.org/10.5753/sbbd_estendido.2022.21843

Abstract

This article presents the Legacy-DB tool to support data migration validation in heterogeneous databases. Legacy-DB provides post-migration validation strategies through a graphical and interactive interface, which projects attributes from the legacy and migrated database, providing a mapping mechanism that enables the adoption of strategies to mitigate inconsistencies between the data. Legacy-DB allows the user to verify and validate the migration using its attributes and the mapping between them, allowing conclusions about visual perception of the nonconformities that occurred during the migration process. In this way, the tool facilitates the recognition of inconsistencies and changes necessary for a successful migration.

Keywords: Data Migration, Data Migration Validation, Heterogeneous Databases

References

Haller, K. (2009). Towards the industrialization of data migration: concepts and patterns for standard software implementation projects. In International Conference on Advanced Information Systems Engineering, pages 63-78. Springer.

Heleno Ramos de Mendonça, M. (2009). Metodologia de migração de dados em um contexto de migração de sistemas legados. Masters thesis, Universidade Federal de Pernambuco.

Malacrida, T. F., Zaupa, A. P., and Pazoti, M. A. (2014). Desenvolvimento de uma ferramenta para migração de dados entre bancos de dados relacionais. In Colloquium Exactarum. ISSN: 2178-8332, volume 6, pages 20-36.

Patel, S., Wakchaure, S., Pingale, M., and Siraj, S. (2014). Data migration system in heterogeneous database. International journal of Research in Engineering and Technology, 3(02):2319-1163.

Rodrigues, T. P. and Vieira, R. B. (2019). Estudo de caso de migração entre banco de dados heterogêneos utilizando pentaho. DIVERSITÀ: Revista Multidisciplinar do Centro Universitário Cidade Verde, 5(2):14-28.