Exportar Publicação
A publicação pode ser exportada nos seguintes formatos: referência da APA (American Psychological Association), referência do IEEE (Institute of Electrical and Electronics Engineers), BibTeX e RIS.
Oliveira, F., Oliveira, A. & Alturas, B. (2018). Migration of relational databases to NoSQL - methods of analysis. Mediterranean Journal of Social Sciences. 9 (2), 227-235
F. Oliveira et al., "Migration of relational databases to NoSQL - methods of analysis", in Mediterranean Journal of Social Sciences, vol. 9, no. 2, pp. 227-235, 2018
@article{oliveira2018_1775817521242,
author = "Oliveira, F. and Oliveira, A. and Alturas, B.",
title = "Migration of relational databases to NoSQL - methods of analysis",
journal = "Mediterranean Journal of Social Sciences",
year = "2018",
volume = "9",
number = "2",
doi = "10.2478/mjss-2018-0042",
pages = "227-235",
url = "https://www.degruyter.com/view/j/mjss.2018.9.issue-2/mjss-2018-0042/mjss-2018-0042.xml"
}
TY - JOUR TI - Migration of relational databases to NoSQL - methods of analysis T2 - Mediterranean Journal of Social Sciences VL - 9 IS - 2 AU - Oliveira, F. AU - Oliveira, A. AU - Alturas, B. PY - 2018 SP - 227-235 SN - 2039-9340 DO - 10.2478/mjss-2018-0042 UR - https://www.degruyter.com/view/j/mjss.2018.9.issue-2/mjss-2018-0042/mjss-2018-0042.xml AB - The amount of data to store, organize and manage in any organization, is very high and increases every day, fact well-known by companies as Facebook, Google or SAS. With this current growth rate, technologies must adapt to the amount of disposable data, and a new approach to information processing is required. Big Data technologies are more focused, and this is a reason for a greater spread of NoSQL database models. The purpose of this article is to validate the existing (and already used) migration methods and to adapt them, to understand the most efficient method to migrate a relational database to a NoSQL database. We will show the methodology used and what were the steps followed for the implementation, as well as the configuration of the environment used during the tests. Results show that in this migration process, the most efficient method is what is referred to as automatic offline migration. However, it requires a window of unavailability greater than the method of online migration, which in turn requires more resources from the operating system to migrate. Therefore, the most efficient method to migrate a database will depend on the application availability, and the computational resources available for it. We hope to make an important contribution in helping to choose a migration method to use, and the metrics that can be collected to better evaluate the performance of a migration. ER -
English