Vol. 21 No. 1 (2018) Cover Image
Vol. 21 No. 1 (2018)

Published: February 28, 2018

Pages: 60-65

Articles

Automated Algorithm for Data Migration from Relational to NoSQL Databases

Alza A. Mahmood 1
1 Computer Engineering Dept., University of Technology, Baghdad, IRAQ
History
  • Received: September 19, 2017
  • Revised: January 16, 2018
  • Accepted: January 18, 2018
  • Available Online: February 10, 2018
DOI

https://doi.org/10.29194/NJES21010060

Abstract

One of the barriers that the developer community face once turning to the newly, highly distributable, schema agnostic and non-relational database, called NoSQL, which is how to migrate their legacy relational database (which is already filled with a large amount of data) into this new class of database management systems. This paper presents a new approach for converting the already filled relational database of any database management system to any type of NoSQL databases in the most optimized data structure form without bothering of specifying the schema of tables and relations between them. In addition, a simplified software as a prototype based on this algorithm is built to show the results of the output for testing the validity of the algorithm.

Keywords

References

  1. Mohamed H., Abdesadik B., Omar B., Data Migration Methodology from Relational to NoSQL Databases, International Journal of Computer, Electrical, Automation, Control and Information Engineering, Vol. 9, No.12, pp. 2556- 2560, 2015.
  2. Hesham E., Mostafa A. , Advanced Computer Architecture and Parallel Processing, John Wiley & Sons, 2005.
  3. Aparna B., Subu S., Relational to NoSQL Database Migration, National Conference on Advanced Computing, Communication and Electrical Systems, Vol. 6, No.5, pp. 58-62, 2017.
  4. Ganesh D., Penthuru R., Cloud Infrastructures for Big Data Analytics, IGI Global, 2014.
  5. Rick C., Scalable SQL and NoSQL data stores, Newsletter-ACM SIGMOD Record, Vol. 39, No. 4, pp. 12-27, 2010.
  6. Gaurav V., Getting started with NoSQL, Packt, 2013.
  7. Vatika S., Meenu D., SQL and NoSQL Databases, International Journal of Advanced Research in Computer Science and Software Engineering, Vol. 2, No.8, pp. 20-27, 2012.
  8. Neelima K., Vijaya K., Relational Database to NoSQL Conversion by Schema Migration and Mapping, International Journal of Computer Engineering In Research Trends, Vol. 3, No.9, pp. 506-513, 2016.
  9. Steve A. T., Luís G. M., Patrick A. B., From Relational Database to Column-Oriented NoSQL Database: Migration P nNrocess, International Journal of Engineering Research & Technology, Vol. 4, No.5, pp. 399- 403, 2015.
  10. Liana S., Marius B., Dumitru D. B., Automatic Mapping of MySQL Databases to NoSQL MongoDB, Proceedings of the Federated Conference on Computer Science and Information Systems, Vol. 8, pp. 837–840, 2016.