A review on data transformation approaches for data migration processes from relational database to NoSQL database
In recent years, data migration has become an important exercise in data management due to the demand of scalable database management systems. Data transformation is an important part of data migration and researchers have put a lot of effort to produce better data transformation approaches. Based on the literatures, there are multiple ways of conducting data transformation between relation databases to NoSQL databases. However, among the issues in data transformation between the two databases are slow processing time and no definitive guideline for database administrator to guide them to conduct the transformation. This paper highlights the data transformation approaches that have been proposed by researchers in recent years as well as its strengths and limitations.
 J. R. LourenÃ§o, B. Cabral, P. Carreiro, M. Vieira, and J. Bernardino, â€œChoosing the right NoSQL database for the job: a quality attribute evaluation,â€ J. Big Data, vol. 2, no. 1, p. 18, 2015. https://doi.org/10.1186/s40537-015-0025-0.
 L. Rocha, F. Vale, E. Cirilo, D. Barbosa, and F. MourÃ£o, â€œAFramework for Migrating Relational Datasets to NoSQL1,â€ Procedia Comput. Sci., vol. 51, pp. 2593â€“2602, 2015. https://doi.org/10.1016/j.procs.2015.05.367.
 N. Ntarmos, I. Patlakas, and P. Triantafillou, â€œRank join queries in NoSQL databases,â€ Proc. VLDB Endow., vol. 7, no. March, pp. 493â€“504, 2014.
 G. Zhao, Q. Lin, L. Li, and Z. Li, â€œSchema conversion model of SQL database to NoSQL,â€ in Proceedings - 2014 9th International Conference on P2P, Parallel, Grid, Cloud and Internet Computing, 3PGCIC 2014, 2014, pp. 355â€“362.
 S. Ataky, T. Mpinda, L. G. Maschietto, and P. A. Bungama, â€œFrom Relational Database to Column-Oriented NoSQL Database : Migration Process,â€ Int. J. Eng. Res. Technol., vol. 4, no. 5, pp. 399â€“403, 2015.
 A. K. Zaki, â€œNoSQL Databases: New Millennium Database for Big Data, Big Users, Cloud Computing and its Security Challenges,â€ IJRET Int. J. Res. Eng. Technol., pp. 403â€“409, 2014.
 T. Jia, X. Zhao, Z. Wang, D. Gong, and G. Ding, â€œModel transformation and data migration from relational database to MongoDB,â€ Proc. - 2016 IEEE Int. Congr. Big Data, BigData Congr.2016, pp. 60â€“67, 2016.
 A. Abdullah and Q. Zhuge, â€œFrom Relational Databases to NoSQL Databases : Performance Evaluation,â€ Res. J. Appl. Sci. Eng. Technol., vol. 11, no. 4, pp. 434â€“439, 2015. https://doi.org/10.19026/rjaset.11.1799.
 S. Sharma, U. S. Tim, J. Wong, S. Gadia, and S. Sharma, â€œA brief review on leading big data models,â€ Data Sci. J., vol. 13, no. December, pp. 138â€“157, 2014. https://doi.org/10.2481/dsj.14-041.
 R. Arora and R. R. Aggarwal, â€œAn Algorithm for Transformation of Data from MySQL to NoSQL (MongoDB),â€ Int. J. Adv. Stud. Comput. Sci. Eng., vol. 2, no. 1, pp. 6â€“12, 2013.
 J. Ahmed and R. Gulmeher, â€œNOSQL Databases: New Trend of Databases, Emerging Reasons, Classification and Security Issues,â€ Int. J. Eng. Sci. Res. Technol., vol. 9655, no. 6, p. 1, 2015.
 O. Hajoui, R. Dehbi, M. Talea, and Z. I. Batouta, â€œAn advanced comparative study of the most promising NoSQL and NewSQL databases with a multi-criteria analysis method,â€ J. Theor. Appl. Inf. Technol., vol. 81, no. 3, pp. 579â€“588, 2015.
 V. Abramova, J. Bernardino, and P. Furtado, â€œExperimental Evaluation of Nosql Databases,â€ Int. J. Database Manag. Syst. Vol.6, No.3, June 2014, vol. 6, no. 3, pp. 1â€“16, 2014.
 A. P. R. Sharma and A. P. Y. Kashyap, â€œA study of nosql databases and working overviews,â€ Int. J. Recent Trens Eng. Res., pp. 43â€“50, 2016.
 S. S. Pore and S. B. Pawar, â€œComparative Study of SQL & NoSQL Databases,â€ Int. J. Adv. Res. Comput. Eng. Technol., vol. 4, no. 5, pp. 1747â€“1753, 2015.
 M. V, â€œComparative Study of Nosql Document, Column Store Databases and Evaluation of Cassandra,â€ Int. J. Database Manag. Syst. (IJDMS) Vol.6, No.4, August 2014, vol. 3, no. 5, pp. 29â€“39, 2013.
 O. B. Mohamad Hanine, Andesadik Bendarag, â€œData Migration Methodology from Relational to NoSQL Databases,â€ Int. J. Comput. Electr. Autom. Control Inf. Eng., vol. 9, no. 12, pp. 2511â€“2515, 2015.
 T. Odia, S. Misra, and A. Adewumi, â€œEvaluation of hadoop/mapreduce framework migration tools,â€ Asia-Pacific World Congr. Comput. Sci. Eng. APWC CSE 2014, pp. 1â€“8, 2014.
 P. Badlani, â€œNoSQL in Action-A New Pathway to Database,â€ Int. J. Sci. Res., vol. 5, no. 6, pp. 872â€“877, 2016.
 S. H. A. El-Sappagh, A. M. A. Hendawi, and A. H. ElBastawissy, â€œA proposed model for data warehouse ETL processes,â€ J. King Saud Univ. - Comput. Inf. Sci., vol. 23, no. 2, pp. 91â€“104, 2011.
 A. B. M. Moniruzzaman and S. A. Hossain, â€œNosql database: New era of databases for big data analytics-classification, characteristics and comparison,â€ arXiv Prepr. arXiv1307.0191, vol. 6, no. 4, pp. 1â€“14, 2013.
 G. Karnitis and G. Arnicans, â€œMigration of Relational Database to Document-Oriented Database: Structure Denormalization and Data Transformation,â€ Proc. - 7th Int. Conf. Comput. IntellCommun. Syst. Networks, CICSyN 2015, pp. 113â€“118, 2015.
 C. H. Lee and Y. L. Zheng, â€œSQL-To-NoSQL Schema Denormalization and Migration: A Study on Content Management Systems,â€ Proc. - 2015 IEEE Int. Conf. Syst. Man, Cybern. SMC 2015, pp. 2022â€“2026, 2015.
 N. Kuderu and V. Kumari, â€œRelational Database to NoSQL Conversion by Schema Migration and Mapping,â€ Int. J. Comput. Eng. Res. Trends, vol. 3, no. 9, pp. 506â€“513, 2016.
 G. A. Schreiner, D. Duarte, and R. dos Santos Mello, â€œSQLtoKeyNoSQL: A Layer for Relational to Key-based NoSQL Database Mapping,â€ Proc. 17th Int. Conf. Inf. Integr. Web-based Appl. Serv., p. 74:1--74:9, 2015.
 P. Nikam, T. Patil, G. Hungund, A. Pagar, A. Talegaonkar, and M. S. Pawar, â€œMigrate and Map : A Framework to Access Data from Mysql Mongodb or Hbase Using Mysql Queries,â€ IOSR J. Comput. Eng., vol. 18, no. 3, pp. 13â€“17, 2016.
 C. H. Lee and Y. L. Zheng, â€œAutomatic SQL-to-NoSQL schema transformation over the MySQL and HBase databases,â€ 2015 IEEE Int. Conf. Consum. Electron. - Taiwan, ICCE-TW 2015, pp. 426â€“427, 2015.
 C. Li, â€œTransforming Relational Database into HBase : A Case Study,â€ IEEE Int. Conf. Softw. Eng. Serv. Sci. ICSESS 2010, pp. 683â€“687, 2010.
 K. Ma and F. Dong, â€œLive data migration approach from relational tables to schema-free collections with MapReduce,â€ Int. J. Serv. Technol. Manag., vol. 21, no. 4â€“6, pp. 318â€“335, 2015 https://doi.org/10.1504/IJSTM.2015.073942.
 K. Ma and B. Yang, â€œLive Data Replication Approach from Relational Tables to Schema-Free Collections Using Stream Processing Framework,â€ Proc. - 2015 10th Int. Conf. P2P, Parallel, Grid, Cloud Internet Comput. 3PGCIC 2015, pp. 26â€“31, 2015.
LicenseAuthors who publish with this journal agree to the following terms:
- Authors retain copyright and grant the journal right of first publication with the work simultaneously licensed under aÂ Creative Commons Attribution Licensethat allows others to share the work with an acknowledgement of the work''s authorship and initial publication in this journal.
- Authors are able to enter into separate, additional contractual arrangements for the non-exclusive distribution of the journal''s published version of the work (e.g., post it to an institutional repository or publish it in a book), with an acknowledgement of its initial publication in this journal.
- Authors are permitted and encouraged to post their work online (e.g., in institutional repositories or on their website) prior to and during the submission process, as it can lead to productive exchanges, as well as earlier and greater citation of published work (SeeÂ The Effect of Open Access).