Schema design advisor model for RDBMS to NoSQL database migration

摘要

Database schema design has a significant importance in software design. There are lots of tools and methods available for schema design in RDBMS but limited attention is given in NoSQL for schema design as it is emerging in database technology. NoSQL requires a different approach in designing efficient schema, such as in the document database which information should be stored as embedded document, or which information should be stored as referenced document. There are certain thumb rules for schema design in NoSQL databases. In reengineering projects, especially in Old RDBMS to new NoSQL system, developing good and efficient database schema is a very difficult task. In this paper, we have proposed a schema design advisor model which uses the existing software’s SQL queries load as an input along with an algorithm for schema design recommendation. Also, we have proposed a cost model for various schemas created by recommendation model. The proposed model is implemented through a prototype for the MongoDB document database in Java. The prototype produces all possible combinations of schemas and calculates cost of each schema. Automated schema design process produces all possible combinations of NoSQL schemas, which is difficult with manual schema design approach.