{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2026,1,5]],"date-time":"2026-01-05T07:15:44Z","timestamp":1767597344015,"version":"3.41.2"},"reference-count":29,"publisher":"Ubiquity Press, Ltd.","license":[{"start":{"date-parts":[[2024,1,1]],"date-time":"2024-01-01T00:00:00Z","timestamp":1704067200000},"content-version":"unspecified","delay-in-days":0,"URL":"https:\/\/creativecommons.org\/licenses\/by\/4.0"}],"content-domain":{"domain":[],"crossmark-restriction":false},"short-container-title":[],"published-print":{"date-parts":[[2024,6,10]]},"DOI":"10.5334\/dsj-2024-035","type":"journal-article","created":{"date-parts":[[2024,6,10]],"date-time":"2024-06-10T09:57:44Z","timestamp":1718013464000},"source":"Crossref","is-referenced-by-count":7,"title":["Enhancement of a Transformation Algorithm to Migrate SQL Database into NoSQL Graph Database"],"prefix":"10.5334","volume":"23","author":[{"ORCID":"https:\/\/orcid.org\/0000-0002-2437-3157","authenticated-orcid":false,"given":"Hira Lal","family":"Bhandari","sequence":"first","affiliation":[]},{"ORCID":"https:\/\/orcid.org\/0000-0002-8967-1454","authenticated-orcid":false,"given":"Roshan","family":"Chitrakar","sequence":"additional","affiliation":[]}],"member":"3285","reference":[{"key":"key20240610063136_B1","article-title":"Automatic NoSQL to relational database transformation with dynamic schema mapping","volume":"2020","year":"2020","journal-title":"Scientific Programming"},{"first-page":"351","volume-title":"Lecture Notes in Computer Science (including subseries Lecture Notes in Artificial Intelligence and Lecture Notes in Bioinformatics)","year":"2006","key":"key20240610063136_B2"},{"key":"key20240610063136_B3","unstructured":"Ba, V A C, Di, M P and Ba, V A C 2013 DATA MIGRATION FROM STANDARD SQL TO NoSQL, pp. 1\u201322. Thesis."},{"issue":"8","key":"key20240610063136_B4","first-page":"440","article-title":"Extending the Existing Data Migration Algorithm for MySQL To MongoDB and Analyzing Its Performance","volume":"6","year":"2018"},{"key":"key20240610063136_B5","unstructured":"Database Schema Drawing tools \u2013 Database Processing n.d. Available at http:\/\/www.consuminglinkeddata.org\/database-schema-drawing-tools [Last accessed 3 August 2022]."},{"first-page":"640","article-title":"R2G: A tool for migrating relations to graphs","year":"2014","key":"key20240610063136_B6"},{"key":"key20240610063136_B7","unstructured":"Explore Your Database Schema with SchemaCrawler \u2013 DEV Community n.d. Available at https:\/\/dev.to\/sualeh\/explore-your-database-schema-with-schemacrawler-5341 [Last accessed 13 August 2022]."},{"issue":"3","key":"key20240610063136_B8","doi-asserted-by":"crossref","first-page":"213","DOI":"10.1016\/0169-023X(95)00006-E","article-title":"A survey of database design transformations based on the Entity-Relationship model","volume":"15","year":"1995","journal-title":"Data and Knowledge Engineering"},{"first-page":"674","article-title":"An approach to converting relational database to graph database: From MySQL to Neo4j","year":"2022","key":"key20240610063136_B9"},{"key":"key20240610063136_B10","unstructured":"Gowrisangar, 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]."},{"key":"key20240610063136_B11","unstructured":"Gupta, 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."},{"issue":"6","key":"key20240610063136_B12","first-page":"1","article-title":"Comparison of data migration techniques from SQL database to NoSQL database","volume":"9","year":"2020","journal-title":"Journal of Computer Engineering & Information Technology"},{"issue":"7","key":"key20240610063136_B13","first-page":"4963","article-title":"A review of NoSQL databases, types and comparison with relational database","volume":"3","year":"2016","journal-title":"International Journal of Engineering Science and Computing"},{"key":"key20240610063136_B14","first-page":"449","article-title":"A classification of schema mappings and analysis of mapping tools","year":"2007","journal-title":"Lecture Notes in Informatics (LNI), Proceedings \u2013 Series of the Gesellschaft fur Informatik (GI)"},{"key":"key20240610063136_B15","doi-asserted-by":"crossref","first-page":"111","DOI":"10.1016\/j.future.2016.02.002","article-title":"Data adapter for querying and transformation between SQL and NoSQL database","volume":"65","year":"2016","journal-title":"Future Generation Computer Systems"},{"first-page":"25","article-title":"Northumbria Research Link","year":"2018","key":"key20240610063136_B16"},{"issue":"12","key":"key20240610063136_B17","first-page":"2972","article-title":"A comprehensive approach for converting relational to graph database using spark","volume":"99","year":"2021","journal-title":"Journal of Theoretical and Applied Information Technology"},{"key":"key20240610063136_B18","unstructured":"Moniruzzaman, A B M and Hossain, S A 2013 NoSQL database: New era of databases for big data analytics \u2013 Classification, characteristics and comparison. (June). http:\/\/arxiv.org\/abs\/1307.0191."},{"key":"key20240610063136_B19","unstructured":"MySQL Sample Database n.d. Available at https:\/\/www.mysqltutorial.org\/mysql-sample-database.aspx [Last accessed 17 August 2021]."},{"issue":"1934","key":"key20240610063136_B20","first-page":"535","article-title":"Correct Schema Transformations*","volume":"74","year":"1941"},{"first-page":"58","article-title":"Graph databases: Their power and limitations","year":"2017","key":"key20240610063136_B21"},{"first-page":"131","article-title":"An automated graph construction approach from relational databases to Neo4j","year":"2022","key":"key20240610063136_B22"},{"issue":"12","key":"key20240610063136_B23","article-title":"AMANDA: A middleware for automatic migration between different database paradigms","volume":"12","year":"2022","journal-title":"Applied Sciences (Switzerland)"},{"key":"key20240610063136_B24","unstructured":"Rahma S. Al Mahruqi et al. 2020 Migrating webs applications from SQL TO NoSQL databases, (January). Thesis."},{"key":"key20240610063136_B25","doi-asserted-by":"crossref","first-page":"69042","DOI":"10.1109\/ACCESS.2019.2916912","article-title":"Intelligent data engineering for migration to NoSQL based secure environments","volume":"7","year":"2019","journal-title":"IEEE Access"},{"key":"key20240610063136_B26","unstructured":"SchemaCrawler \u2013 Free database schema discovery and comprehension tool n.d. Available at https:\/\/www.schemacrawler.com\/ [Last accessed 15 March 2022]."},{"key":"key20240610063136_B27","unstructured":"SchemaCrawler Alternatives and Similar Software|AlternativeTo n.d. Available at https:\/\/alternativeto.net\/software\/schemacrawler\/?fbclid=iwar2axgn-v7momm76l1qee9s5t4hroxtpap6dd0vmc3zdphngfa7sgqukrne [Last accessed 10 February 2024]."},{"first-page":"58","article-title":"Migrating from SQL to NOSQL database: Practices and analysis","year":"2019","key":"key20240610063136_B28"},{"issue":"1","key":"key20240610063136_B29","first-page":"243","article-title":"Migration from RDBMS to NoSQL using column-level denormalization and atomic aggregates","volume":"34","year":"2018","journal-title":"Journal of Information Science and Engineering"}],"container-title":["Data Science Journal"],"original-title":[],"language":"en","link":[{"URL":"https:\/\/account.datascience.codata.org\/index.php\/up-j-dsj\/article\/download\/1655\/1342","content-type":"application\/pdf","content-version":"vor","intended-application":"text-mining"},{"URL":"https:\/\/account.datascience.codata.org\/index.php\/up-j-dsj\/article\/download\/1655\/1343","content-type":"text\/xml","content-version":"vor","intended-application":"text-mining"},{"URL":"https:\/\/account.datascience.codata.org\/index.php\/up-j-dsj\/article\/download\/1655\/1344","content-type":"application\/pdf","content-version":"vor","intended-application":"text-mining"},{"URL":"https:\/\/account.datascience.codata.org\/index.php\/up-j-dsj\/article\/download\/1655\/1345","content-type":"application\/pdf","content-version":"vor","intended-application":"text-mining"},{"URL":"https:\/\/account.datascience.codata.org\/index.php\/up-j-dsj\/article\/download\/1655\/1342","content-type":"unspecified","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2024,6,10]],"date-time":"2024-06-10T10:31:53Z","timestamp":1718015513000},"score":1,"resource":{"primary":{"URL":"https:\/\/datascience.codata.org\/articles\/10.5334\/dsj-2024-035\/"}},"subtitle":[],"short-title":[],"issued":{"date-parts":[[2024]]},"references-count":29,"alternative-id":["10.5334\/dsj-2024-035"],"URL":"https:\/\/doi.org\/10.5334\/dsj-2024-035","relation":{},"ISSN":["1683-1470"],"issn-type":[{"type":"print","value":"1683-1470"}],"subject":[],"published":{"date-parts":[[2024]]},"article-number":"35"}}