Rel2Doc: Migrating Data from Relational to Document-Oriented Databases

• Tainam Spagnollo Garbin Universidade Federal da Fronteira Sul (UFFS)
• Denio Duarte Universidade Federal da Fronteira Sul (UFFS)
• Geomar A. Schreiner Universidade Federal da Fronteira Sul (UFFS) https://orcid.org/0000-0002-6457-8982

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

Resumo

This paper presents Rel2Doc, a tool to migrate data from relational to document-oriented databases. From normalized concepts, Rel2Doc implements aggregation on the document side using foreign keys and join tables to avoid references in the document-oriented database. We build an interface where the user can choose the relational database source and some parameters to define how primary and foreign keys are implemented on the document-oriented side. Rel2Doc migrates all data regarding correctness and completeness, ensuring that queries have the same answers in both databases.

Palavras-chave: document-oriented, relational, migration, database

Referências

Abadi, D. J. (2009). Data management in the cloud: Limitations and opportunities. IEEE Data Eng. Bull., 32(1):3–12.

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.

Karnitis, G. and Arnicans, G. (2015). Migration of relational database to document-oriented database: Structure denormalization and data transformation. In 7th CICN.

Namdeo, B. and Suman, U. (2021). Schema design advisor model for RDBMS to NoSQL database migration. International Journal of Information Technology, 13(1):277–286.

Thalheim, B. and Wang, Q. (2013). Data migration: A theoretical perspective. Data & Knowledge Engineering, 87:260–278.