Migration From Relational Database to Column-Oriented NoSQL Database
Rizky Anggita Syarbaini Siregar, Fazat Nur Azizah · 2023
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.