Have a personal or library account? Click to login
Enhancement of a Transformation Algorithm to Migrate SQL Database into NoSQL Graph Database Cover

Enhancement of a Transformation Algorithm to Migrate SQL Database into NoSQL Graph Database

Open Access
|Jun 2024

References

  1. 1Aftab, Z et al. 2020 Automatic NoSQL to relational database transformation with dynamic schema mapping. Scientific Programming, 2020. DOI: 10.1155/2020/8813350
  2. 2Akehurst, D H et al. 2006 SiTra: Simple transformations in Java. In Lecture Notes in Computer Science (including subseries Lecture Notes in Artificial Intelligence and Lecture Notes in Bioinformatics), 4199 LNCS, pp. 351364. DOI: 10.1007/11880240_25
  3. 3Ba, V A C, Di, M P and Ba, V A C 2013 DATA MIGRATION FROM STANDARD SQL TO NoSQL, pp. 122. Thesis.
  4. 4Christina, A J and Saranya, S 2018 Extending the Existing Data Migration Algorithm for MySQL To MongoDB and Analyzing Its Performance, 6(8), 440446.
  5. 5Database Schema Drawing tools – Database Processing n.d. Available at http://www.consuminglinkeddata.org/database-schema-drawing-tools [Last accessed 3 August 2022].
  6. 6De Virgilio, R, Maccioni, A and Torlone, R 2014 R2G: A tool for migrating relations to graphs. Advances in Database Technology – EDBT 2014: 17th International Conference on Extending Database Technology, Proceedings, pp. 640643. DOI: 10.5441/002/edbt.2014.63.
  7. 7Explore Your Database Schema with SchemaCrawler – DEV Community n.d. Available at https://dev.to/sualeh/explore-your-database-schema-with-schemacrawler-5341 [Last accessed 13 August 2022].
  8. 8Fahrner, C and Vossen, G 1995 A survey of database design transformations based on the Entity-Relationship model. Data and Knowledge Engineering, 15(3): 213250. DOI: 10.1016/0169-023X(95)00006-E
  9. 9Feng, H and Huang, M 2022 An approach to converting relational database to graph database: From MySQL to Neo4j. 2022 IEEE 2nd International Conference on Power, Electronics and Computer Applications, ICPECA 2022, pp. 674680. DOI: 10.1109/ICPECA53709.2022.9719151
  10. 10Gowrisangar, K n.d. What is SchemaCrawler and Why would you need it? Geek Culture. Available at: https://medium.com/geekculture/what-is-schemacrawler-and-why-would-you-need-it-b9c496054533 [Last accessed 13 August 2022].
  11. 11Gupta, M 2014 A novel approach to transform relational database into graph database using Neo4j. (June): 56. http://dspace.thapar.edu:8080/dspace/handle/10266/2800, Thesis.
  12. 12Journal, A S, Bhandari, H L and Chitrakar, R 2020 Comparison of data migration techniques from SQL database to NoSQL database. Journal of Computer Engineering & Information Technology, 9(6): 110.
  13. 13Khare, A 2016 A review of NoSQL databases, types and comparison with relational database. International Journal of Engineering Science and Computing, 3(7): 49634966.
  14. 14Legler, F and Naumann, F 2007 A classification of schema mappings and analysis of mapping tools. Lecture Notes in Informatics (LNI), Proceedings – Series of the Gesellschaft fur Informatik (GI), P-103, pp. 449463.
  15. 15Liao, Y T et al. 2016 Data adapter for querying and transformation between SQL and NoSQL database. Future Generation Computer Systems, 65: 111121. DOI: 10.1016/j.future.2016.02.002
  16. 16Management, I M and Url, E 2018 Northumbria Research Link, pp. 2535.
  17. 17Mohamed, W, Abdel-Fattah, M A and Abdelgaber, S 2021 A comprehensive approach for converting relational to graph database using spark. Journal of Theoretical and Applied Information Technology, 99(12): 29722990.
  18. 18Moniruzzaman, A B M and Hossain, S A 2013 NoSQL database: New era of databases for big data analytics – Classification, characteristics and comparison. (June). http://arxiv.org/abs/1307.0191.
  19. 19MySQL Sample Database n.d. Available at https://www.mysqltutorial.org/mysql-sample-database.aspx [Last accessed 17 August 2021].
  20. 20Pasteur, L and Koch, R 1941 Correct Schema Transformations*, 74(1934): 535546.
  21. 21Pokorný, J et al. 2017 Graph databases: Their power and limitations, pp. 5869. DOI: 10.1007/978-3-319-24369-6_5
  22. 22Putrama, I M and Martinek, P 2022 An automated graph construction approach from relational databases to Neo4j. IEEE Joint 22nd International Symposium on Computational Intelligence and Informatics and 8th International Conference on Recent Achievements in Mechatronics, Automation, Computer Science and Robotics, CINTI-MACRo 2022 – Proceedings, pp. 131136. DOI: 10.1109/CINTI-MACRo57952.2022.10029438
  23. 23Queiroz, J S et al. 2022 AMANDA: A middleware for automatic migration between different database paradigms. Applied Sciences (Switzerland), 12(12). DOI: 10.3390/app12126106
  24. 24Rahma S. Al Mahruqi et al. 2020 Migrating webs applications from SQL TO NoSQL databases, (January). Thesis.
  25. 25Ramzan, S et al. 2019 Intelligent data engineering for migration to NoSQL based secure environments. IEEE Access, 7, pp. 6904269057. DOI: 10.1109/ACCESS.2019.2916912
  26. 26SchemaCrawler – Free database schema discovery and comprehension tool n.d. Available at https://www.schemacrawler.com/ [Last accessed 15 March 2022].
  27. 27SchemaCrawler Alternatives and Similar Software|AlternativeTo n.d. Available at https://alternativeto.net/software/schemacrawler/?fbclid=iwar2axgn-v7momm76l1qee9s5t4hroxtpap6dd0vmc3zdphngfa7sgqukrne [Last accessed 10 February 2024].
  28. 28Yassine, F and Awad, M A 2019 Migrating from SQL to NOSQL database: Practices and analysis. Proceedings of the 2018 13th International Conference on Innovations in Information Technology, IIT 2018, pp. 5862. DOI: 10.1109/INNOVATIONS.2018.8606019
  29. 29Yoo, J, Lee, K H and Jeon, Y H 2018 Migration from RDBMS to NoSQL using column-level denormalization and atomic aggregates. Journal of Information Science and Engineering, 34(1): 243259. DOI: 10.6688/JISE.2018.34.1.15.
Language: English
Submitted on: Nov 21, 2023
Accepted on: May 18, 2024
Published on: Jun 10, 2024
Published by: Ubiquity Press
In partnership with: Paradigm Publishing Services
Publication frequency: 1 issue per year

© 2024 Hira Lal Bhandari, Roshan Chitrakar, published by Ubiquity Press
This work is licensed under the Creative Commons Attribution 4.0 License.