MYSQL to cassandra conversion engine
M. Giridhara Gopalan, C. Prasanna, Y. V. Srihari Krishna, Shanthini B., A Arulkumar · 2017
As Technology advances, huge amount of data are generated every day from various sources like Social Media, Banking, Hospital Management etc. Modern businesses that use big data use cases are helping to build a different set of technologies to replace MySQL. Currently, the data migration is very important because of the ever-mounting volume of data, that are collected via many sources, has motivated the migration from Relational Database Management System (RDBMS) to NoSQL (Not Only SQL) database. The main aim this paper is to present a methodology for data migration from RDBMS to NoSQL database. To illustrate this methodology, we implement a software prototype using MySQL as a RDBMS and CassandraDB as a NoSQL database. In this, the MySQL database and the Cassandra database are connected to the Python Environment and the Conversion of Schema is processed, followed by Conversion of Data.