RL2NoSQL: A Novel Method to Automate Migration from Relational Databases to NoSQL Data Stores

Properly storing data is crucial in this big data era. The inflexible and strict structure of relational database management systems (RDBMS) paved the way for the emergence of NoSQL storage systems. Converting from the rigid schema structure of RDBMS to NoSQL systems is a complex process that requires careful consideration to ensure data integrity and consistency, carefully selecting an appropriate NoSQL system, and proper execution of the migration process. This study introduces the RL2NoSQL method to facilitate the migration process from RDBMS to NoSQL systems, including key-value, document, wide-column, and graph. The RL2NoSQL method intelligently handles the structural differences between data models in great detail and offers automatic conversion and transferring data tools that keep data integrity and consistency. Moreover, the RL2NoSQL provides significant advantages in managing complexity and increasing data storage flexibility so that database conversion can be performed without data loss or corruption. The RL2NOSQL approach is evaluated by employing the DVD rental database. The converted schema and transferred data are evaluated by using carefully prepared queries to show the effectiveness of our approach. The RL2NoSQL offers a significant contribution to organizations of different sectors seeking to transition to NoSQL for applications by enabling migration to the presented NoSQL categories.