Back to Search
Start Over
Schema design advisor model for RDBMS to NoSQL database migration
- Source :
- International Journal of Information Technology. 13:277-286
- Publication Year :
- 2020
- Publisher :
- Springer Science and Business Media LLC, 2020.
-
Abstract
- 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.
- Subjects :
- SQL
Computer Networks and Communications
Computer science
02 engineering and technology
computer.software_genre
NoSQL
Software
Relational database management system
Artificial Intelligence
Schema (psychology)
0202 electrical engineering, electronic engineering, information engineering
Electrical and Electronic Engineering
computer.programming_language
Database
business.industry
Applied Mathematics
Database schema
InformationSystems_DATABASEMANAGEMENT
020206 networking & telecommunications
Computer Science Applications
Computational Theory and Mathematics
ComputingMethodologies_DOCUMENTANDTEXTPROCESSING
Software design
020201 artificial intelligence & image processing
business
computer
Data migration
Information Systems
Subjects
Details
- ISSN :
- 25112112 and 25112104
- Volume :
- 13
- Database :
- OpenAIRE
- Journal :
- International Journal of Information Technology
- Accession number :
- edsair.doi...........f3eb5af25d41ae394f98d01344336811