A case study: Database migration from RDBMS to NoSQL

Abstract

As database technologies progress, a common issue is database migration from one technology to another. RDBMS database has been used for 3-4 decades successfully by companies and various organizations. Since the last decade, the database size of an organization is growing rapidly and the format or the nature of the database is also changing. Therefore, companies are moving from RDBMS to a new type of database. These new types of databases come under the umbrella term, NoSQL. In this paper, we have proposed the overall architecture of database migration from RDBMS to NoSQL database. This includes issues related to database schema design, database reengineering cost calculation, database migration techniques, and middleware which translate the SQL to NoSQL query.