Gerenciamento de Migração de Dados: Um Workflow Eficiente para Empresas
Resumo
A migração de dados entre diferentes sistemas de bancos de dados (SBDs) é crucial para empresas acompanharem a evolução tecnológica e otimizarem seus processos. Este artigo propõe um workflow para auxiliar a condução de migrações, desde o planejamento até a pós-migração. O objetivo é fornecer um roteiro para migrações, reduzindo o tempo de execução, mitigando riscos e garantindo a integridade e segurança dos dados. A abordagem proposta foi validada em um cenário real de migração complexa, confirmando sua viabilidade e efetividade.
Palavras-chave:
Migração de banco de dados, Estratégias de migração, Fluxo de Trabalho
Referências
Azeroual, O. and Jha, M. (2021). Without data quality, there is no data migration. Big Data and Cognitive Computing, 5(2):24.
Elamparithi, M. and Anuratha, V. (2015). A review on database migration strategies, techniques and tools. World Journal of Computer Application and Technology, 3(3):41–48.
Ellison, M., Calinescu, R., and Paige, R. F. (2018). Evaluating cloud database migration options using workload models. Journal of Cloud Computing, 7:1–18.
Fuaad, H., Ibrahim, A., Majed, A., and Asem, A. (2018). A survey on distributed database fragmentation allocation and replication algorithms. Current Journal of Applied Science and Technology, 27(2):1–12.
Google Cloud (2024). Migração de banco de dados: conceitos e princípios (parte 1). [link]. Acessado em: 2024-05-29.
Haller, K. (2009). Towards the industrialization of data migration: concepts and patterns for standard software implementation projects. In Advanced Information Systems Engineering: 21st International Conference, CAiSE 2009, Amsterdam, The Netherlands, June 8-12, 2009. Proceedings 21, pages 63–78. Springer.
Hussein, A. A. et al. (2021). Data migration need, strategy, challenges, methodology, categories, risks, uses with cloud computing, and improvements in its using with cloud using suggested proposed model (dmig 1). Journal of Information Security, 12(01):79.
Karnitis, G. and Arnicans, G. (2015). Migration of relational database to document-oriented database: Structure denormalization and data transformation. In 2015 7th international conference on computational intelligence, communication systems and networks, pages 113–118. IEEE.
Mayr, H. C. and Thalheim, B. (2021). The triptych of conceptual modeling: A framework for a better understanding of conceptual modeling. Software and Systems Modeling, 20(1):7–24.
Nan, Z. and Bai, X. (2019). The study on data migration from relational database to graph database. In Journal of Physics: Conference Series, volume 1345, page 022061. IOP Publishing.
Neto, P. S., Neto, J. R., Júnior, F. R., and Oliveira, P. (2013). Requisitos para ferramentas de migração de dados. In Anais do IX Simpósio Brasileiro de Sistemas de Informação, pages 887–898, Porto Alegre, RS, Brasil. SBC.
Ozsu, M. T. and Valduriez, P. (2001). Principios de sistemas da bancos de dados distribuidos. Campus.
Singhal, B. and Aggarwal, A. (2022). Etl, elt and reverse etl: a business case study. In 2022 Second International Conference on Advanced Technologies in Intelligent Control, Environment, Computing & Communication Engineering (ICATIECE), pages 1–4. IEEE.
Thalheim, B. and Wang, Q. (2013). Data migration: A theoretical perspective. Data & Knowledge Engineering, 87:260–278.
Wang, G., Jia, Z., and Xue, M. (2014). Data migration model and algorithm between heterogeneous databases based on web service. Journal of Networks, 9(11):3127.
Elamparithi, M. and Anuratha, V. (2015). A review on database migration strategies, techniques and tools. World Journal of Computer Application and Technology, 3(3):41–48.
Ellison, M., Calinescu, R., and Paige, R. F. (2018). Evaluating cloud database migration options using workload models. Journal of Cloud Computing, 7:1–18.
Fuaad, H., Ibrahim, A., Majed, A., and Asem, A. (2018). A survey on distributed database fragmentation allocation and replication algorithms. Current Journal of Applied Science and Technology, 27(2):1–12.
Google Cloud (2024). Migração de banco de dados: conceitos e princípios (parte 1). [link]. Acessado em: 2024-05-29.
Haller, K. (2009). Towards the industrialization of data migration: concepts and patterns for standard software implementation projects. In Advanced Information Systems Engineering: 21st International Conference, CAiSE 2009, Amsterdam, The Netherlands, June 8-12, 2009. Proceedings 21, pages 63–78. Springer.
Hussein, A. A. et al. (2021). Data migration need, strategy, challenges, methodology, categories, risks, uses with cloud computing, and improvements in its using with cloud using suggested proposed model (dmig 1). Journal of Information Security, 12(01):79.
Karnitis, G. and Arnicans, G. (2015). Migration of relational database to document-oriented database: Structure denormalization and data transformation. In 2015 7th international conference on computational intelligence, communication systems and networks, pages 113–118. IEEE.
Mayr, H. C. and Thalheim, B. (2021). The triptych of conceptual modeling: A framework for a better understanding of conceptual modeling. Software and Systems Modeling, 20(1):7–24.
Nan, Z. and Bai, X. (2019). The study on data migration from relational database to graph database. In Journal of Physics: Conference Series, volume 1345, page 022061. IOP Publishing.
Neto, P. S., Neto, J. R., Júnior, F. R., and Oliveira, P. (2013). Requisitos para ferramentas de migração de dados. In Anais do IX Simpósio Brasileiro de Sistemas de Informação, pages 887–898, Porto Alegre, RS, Brasil. SBC.
Ozsu, M. T. and Valduriez, P. (2001). Principios de sistemas da bancos de dados distribuidos. Campus.
Singhal, B. and Aggarwal, A. (2022). Etl, elt and reverse etl: a business case study. In 2022 Second International Conference on Advanced Technologies in Intelligent Control, Environment, Computing & Communication Engineering (ICATIECE), pages 1–4. IEEE.
Thalheim, B. and Wang, Q. (2013). Data migration: A theoretical perspective. Data & Knowledge Engineering, 87:260–278.
Wang, G., Jia, Z., and Xue, M. (2014). Data migration model and algorithm between heterogeneous databases based on web service. Journal of Networks, 9(11):3127.
Publicado
14/10/2024
Como Citar
MORAES, Gustavo; MISAEL, Victor; BRAYNER, Angelo.
Gerenciamento de Migração de Dados: Um Workflow Eficiente para Empresas. In: SIMPÓSIO BRASILEIRO DE BANCO DE DADOS (SBBD), 39. , 2024, Florianópolis/SC.
Anais [...].
Porto Alegre: Sociedade Brasileira de Computação,
2024
.
p. 841-847.
ISSN 2763-8979.
DOI: https://doi.org/10.5753/sbbd.2024.240760.