Examining the methods used for the transition from relational databases to nosql storage systems and developing the schematransformation application

The rigid and inflexible schema structure of relational databases has paved the way for the emergence of NoSQL (Not Only SQL) data storage systems. The transition from Relational Database Management Systems (RDBMS) to NoSQL data storage systems is a complex process that requires careful evaluation to maintain data integrity and consistency, select the appropriate NoSQL system, and correctly manage the transition. In this thesis, given the importance of transitioning from relational databases to NoSQL, the RL2NoSQL method has been developed, which enables the transition to the desired category of NoSQL and also transfers the data to the newly created schema. The RL2NoSQL method meticulously addresses the structural differences between data models while providing automatic transformation mechanisms, offering significant advantages in managing complexity and enhancing storage flexibility. This ensures that the database transformation process can be conducted without data loss or corruption. Additionally, several queries have been created to evaluate the schema suggestions generated by the RL2NoSQL approach. These queries have been executed across various NoSQL storage systems. The results and findings indicate potential improvements for data querying operations. The RL2NoSQL method aims to provide a critical contribution to companies and organizations in the industry looking to transition to NoSQL, and it opens new doors for applications across various sectors. Keywords: Data Modeling, RDBMS, NoSQL, Schema Transformation