Approaches used in efficient migration from Relational Database to NoSQL Database

• Autorzy: Koli Arati , Shinde Swati

Identyfikatory

DOI

10.15439/2017R76

• Konferencja: The Second International Conference on Research in Intelligent and Computing in Engineering
• Języki publikacji: EN

Abstrakty

EN

Nowadays, the emerging software applications producing the large volume of data rapidly. Hence, sufficient management of such a large data is major challenge. The traditional relational databases are inefficient to handle such a dynamic data which would be in any form (i.e. structural, semi-structured or hybrid). The ever increasing data have pushed the centralized databases like oracle, MySQL, SQL server to their limits. So, the NoSQL databases are the new generation databases for tackling such a problem with terabyte to petabyte of datasets. Hence, many leading companies such as facebook, Amazon, eBay, foursquare and many more using NoSQL databases. Some companies' still using relational databases and they wish to move towards new technologies, this motivated us to study the approaches used for migration of databases from relational database to NoSQL database. There are different techniques in the literature introduced by people for such migration. This paper surveys different approaches used for Migration of structured database to un-structured database.

Słowa kluczowe

EN

Relational database; mySQL; SQL server; Oracle; NoSQL; migration

• Wydawca: Polskie Towarzystwo Informatyczne
• Czasopismo: Annals of Computer Science and Information Systems
• Rocznik: 2017
• Tom: Vol. 10
• Strony: 223--227
• Opis fizyczny: Bibliogr. 8 poz., rys., tab.

Twórcy

autor

Koli Arati

• Dept. of IT, Pimpari Cinchwad College of Engineering, Pune, India

autor

Shinde Swati

• Dept. of IT, Pimpari Cinchwad College of Engineering, Pune, India

Bibliografia

• 1. Leonardo Rocha, Fernando Vale, “A Framework for Migrating Relational Datasets to NoSQL”, 2015 ICCS International Conference on Computational Science.
• 2. Gansen Zhao 1 , Libo Li 1, 2, “Multiple Nested Schema of HBase for Migration from SQL”, 2014 Ninth International Conference on P2P, Parallel, Grid, Cloud and Internet Computing .
• 3. Ramon Lawrence, “Integration and Virtualization of Relational SQL and NoSQL Systems including MySQL and MongoDB “, 2014 International Conference on Computational Science and Computational Intelligence.
• 4. Girts Karnitis and Guntis Arnicans, “Migration of Relational Database to Document-Oriented Database: Structure Denormalization and Data Transformation”, 2015 7th International Conference on Computational Intelligence, Communication Systems and Networks (CICSyN).
• 5. Gansen Zhao 1 , Qiaoying Lin 1,2 , “Schema Conversion Model of SQL Database to NoSQL”, 2014 Ninth International Conference on P2P, Parallel, Grid, Cloud and Internet Computing.
• 6. Mohamed Hanine,abdesadik bendarag, “data migration methodology from relational database to NoSQL databases”, 2015 International Journal of Computer, Electrical, Automation, Control and Information Engineering Vol:9, No:12.
• 7. Nawal N. Moatassem,”A Study of Migrating Biological Data from relational database to NoSQL databases”, 2015.
• 8. R. Ouanouki, D. Sygusch, “Demystifying NoSQL schema design using basic SQL Analogy”,2015

Uwagi

Opracowanie rekordu ze środków MNiSW, umowa nr SONP/SP/546092/2022 w ramach programu "Społeczna odpowiedzialność nauki" - moduł: Popularyzacja nauki i promocja sportu (2024)