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

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
Controls
|||
ALL TIME
JAN
FEB
MAR
APR
MAY
JUN
JUL
AUG
SEP
OCT
article

Rel2Doc: Migrating Data from Relational to Document-Oriented Databases

Denio Duarte, Geomar A. Schreiner, Tainam Spagnollo Garbin
Advanced Database Systems and Queries
article

Rel2Doc: Migrating Data from Relational to Document-Oriented Databases

Denio Duarte, Geomar A. Schreiner, Tainam Spagnollo Garbin
article en

Abstract

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.

Reduced inequalities
Openalex Percentile: Top 80%
Advanced Database Systems and Queries
AI Navigator

Ask Laika to Summarize, Analyze, and Connect papers live on the map.

Summarize Papers & Methodologies

Extract key findings, datasets, and comparative methods across publications.

Benchmark Rankings & Visual Analytics

Rank top research institutions, authors, funders, topics, and journals by Field-Weighted Citation Impact (FWCI) and paper volume with instant charts.

Connect Distant Disciplines

Bridge topological clusters on the map to find hidden collaborative intersections.

Rel2Doc: Migrating Data from Relational to Document-Oriented Databases — Denio Duarte, Geomar A. Schreiner, et al. · (2024) | TGRS Research Map | TGRS