An Approach for Relational Database Migration to Document-Oriented NoSQL
Abstract
Migrating data from a relational model to a document-oriented model is a complicated process that involves multiple stages. This paper proposes a data denormalization methodology to migrate data from PostgreSQL to MongoDB. Our experiments have shown that our approach effectively migrates data between those different models, and the number of foreign keys significantly affects migration time.
References
Bock, D. B. and Schrage, J. F. (2002). Denormalization guidelines for base and transaction tables. ACM SIGCSE Bulletin, 34(4):129–133.
Chen, L., Davoudian, A., and Liu, M. (2022). A workload-driven method for designing aggregate-oriented nosql databases. Data & Knowledge Engineering, 142:102089.
de Lima, C. and dos Santos Mello, R. (2015). A workload-driven logical design approach for nosql document databases. In Proceedings of the 17th iiWAS, pages 1–10.
Frozza, A. A., Schreiner, G., Brüggemann, R., and dos Santos Mello, R. (2018). Dino: uma ferramenta para importação de dados em bancos de dados nosql. In Anais da XIV ERBD. SBC.
Karnitis, G. and Arnicans, G. (2015). Migration of relational database to document-oriented database: Structure denormalization and data transformation. In 2015 7th CICN, pages 113–118. IEEE.
Sadalage, P. J. and Fowler, M. (2013). NoSQL distilled: a brief guide to the emerging world of polyglot persistence. Pearson Education.
Sanders, G. L. and Shin, S. (2001). Denormalization effects on performance of rdbms. In Proceedings of the 34th HICSS, pages 9–pp. IEEE.
Sarmah, S. S. (2018). Data migration. Science and Technology, 8(1):1–10.
Schreiner, G. A., Duarte, D., and dos Santos Mello, R. (2020). Bringing sql databases to key-based nosql databases: a canonical approach. Computing, 102(1):221–246.
Zhao, G., Lin, Q., Li, L., and Li, Z. (2014). Schema conversion model of sql database to nosql. In 2014 Ninth 3PGCIC, pages 355–362. IEEE.
Chen, L., Davoudian, A., and Liu, M. (2022). A workload-driven method for designing aggregate-oriented nosql databases. Data & Knowledge Engineering, 142:102089.
de Lima, C. and dos Santos Mello, R. (2015). A workload-driven logical design approach for nosql document databases. In Proceedings of the 17th iiWAS, pages 1–10.
Frozza, A. A., Schreiner, G., Brüggemann, R., and dos Santos Mello, R. (2018). Dino: uma ferramenta para importação de dados em bancos de dados nosql. In Anais da XIV ERBD. SBC.
Karnitis, G. and Arnicans, G. (2015). Migration of relational database to document-oriented database: Structure denormalization and data transformation. In 2015 7th CICN, pages 113–118. IEEE.
Sadalage, P. J. and Fowler, M. (2013). NoSQL distilled: a brief guide to the emerging world of polyglot persistence. Pearson Education.
Sanders, G. L. and Shin, S. (2001). Denormalization effects on performance of rdbms. In Proceedings of the 34th HICSS, pages 9–pp. IEEE.
Sarmah, S. S. (2018). Data migration. Science and Technology, 8(1):1–10.
Schreiner, G. A., Duarte, D., and dos Santos Mello, R. (2020). Bringing sql databases to key-based nosql databases: a canonical approach. Computing, 102(1):221–246.
Zhao, G., Lin, Q., Li, L., and Li, Z. (2014). Schema conversion model of sql database to nosql. In 2014 Ninth 3PGCIC, pages 355–362. IEEE.
Published
2024-04-10
How to Cite
GARBIN, Tainam Spagnollo; DUARTE, Denio; SCHREINER, Geomar A.; FEITOSA, Samuel da Silva.
An Approach for Relational Database Migration to Document-Oriented NoSQL. In: REGIONAL DATABASE SCHOOL (ERBD), 19. , 2024, Farroupilha/RS.
Anais [...].
Porto Alegre: Sociedade Brasileira de Computação,
2024
.
p. 21-30.
ISSN 2595-413X.
DOI: https://doi.org/10.5753/erbd.2024.238878.
