Migration From Relational Database to Column-Oriented NoSQL Database

Migration From Relational Database to Column-Oriented NoSQL Database

연구 분야: Databases

학회: 2023 IEEE International Conference on Data and Software Engineering (ICoDSE)

Relational databases that experience performance issues with processing large amounts of data can benefit from column-oriented NoSQL databases. It offers the advantages of scalability, performance and speed of analytical queries. The migration from relational to column-oriented NoSQL databases is critical because applications that use relational databases are already running, hence it is not possible to use a new NoSQL database without existing data in the relational database. This study introduces two solutions: direct and indirect methods involving schemas and data migration stages. The direct method maps tables to groups of columns, while the indirect method uses ERD extraction and conversion to a NoSQL logical schema. The indirect method outperforms the direct method in many aspects, and the implementation successfully migrated MYSQL databases to Cassandra while maintaining data integrity.