Migration From Relational Database to Column-Oriented NoSQL Database

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 cr...

Ausführliche Beschreibung

Gespeichert in:
Bibliographische Detailangaben
Veröffentlicht in:Proceedings of ... International Conference on Data and Software Engineering (ICoDSE) (Online) S. 174 - 179
Hauptverfasser: Syarbaini Siregar, Rizky Anggita, Azizah, Fazat Nur
Format: Tagungsbericht
Sprache:Englisch
Veröffentlicht: IEEE 07.09.2023
Schlagworte:
column-oriented NoSQL
Data integrity
ERD
migration
NoSQL databases
relational
Relational databases
Scalability
Software engineering
ISSN:2640-0227
Online-Zugang:Volltext
Tags: Tag hinzufügen
Keine Tags, Fügen Sie den ersten Tag hinzu!
Beschreibung
Zusammenfassung: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.
ISSN:2640-0227
DOI:10.1109/ICoDSE59534.2023.10291800