Rel2Doc: Migrating Data from Relational to Document-Oriented Databases
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.
Authors
- Denio Duarte (ORCID: https://orcid.org/0000-0003-4936-4748)
- Geomar A. Schreiner (ORCID: https://orcid.org/0000-0002-6457-8982)
- Tainam Spagnollo Garbin
Publication Details
- Published
- 2024-10-14
- DOI
- https://doi.org/10.5753/sbbd_estendido.2024.243163
- Primary Topic
- Advanced Database Systems and Queries
- Type
- article
- Field-Weighted Citation Impact
- 0.00