Skip to main content
SpringerLink
Log in

Schema design advisor model for RDBMS to NoSQL database migration

  • Original Research
  • Published:
International Journal of Information Technology Aims and scope Submit manuscript

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.

This is a preview of subscription content, log in via an institution to check access.

Access this article

Log in via an institution

Price excludes VAT (USA)
Tax calculation will be finalised during checkout.

Instant access to the full article PDF.

Institutional subscriptions

Fig. 1
Fig. 2
Fig. 3
Fig. 4

Similar content being viewed by others

References

  1. Gilbert S, Lynch N (2002) Brewer’s conjecture and the feasibility of consistent, available, partition-tolerant web services. Acm Sigact News 33(2):51–59

    Article  Google Scholar 

  2. MongoDB for absolute beginners (2019) ACID and CAP, 2016. https://mongodbforabsolutebeginners.blogspot.com/2016/06/acid-and-cap-theroems.html. Accessed 9 Oct 2019.

  3. Gopi AP, Jyothi RNS, Narayana VL, Sandeep KS (2020) Classification of tweets data based on polarity using improved RBF kernel of SVM. Int J Inf Technol. https://doi.org/10.1007/s41870-019-00409-4.

    Article  Google Scholar 

  4. NoSQL-Wikipedia (2019). https://en.wikipedia.org/wiki/NoSQL. Accessed 17 Oct 2019.

  5. Varga V, Jánosi-Rancz KT, Kálmán B (2016) Conceptual design of document NoSQL database with formal concept analysis. Acta Polytech Hungarica 13(2):229–248

    Google Scholar 

  6. Namdeo B, Suman U (2019) Performance Analysis of Schema Design approaches for migration from RDBMS to NoSQL Databases. In: 2nd International Conference on Data and Information Sciences.

  7. Atzeni P, Bugiotti F, Cabibbo L, Torlone R (2020) Data modeling in the NoSQL world. Comput Stand Interfaces 67:103149

    Article  Google Scholar 

  8. Mior MJ (2014) Automated schema design for NoSQL databases. In: Proceedings of the ACM SIGMOD International Conference on Management of Data, pp. 41–45

  9. Mior MJ, Salem K, Aboulnaga A, Liu R (2017) NoSE: schema design for NoSQL applications. IEEE Trans Knowl Data Eng 29(10):2275–2289

    Article  Google Scholar 

  10. Imam AA, Basri S, Ahmad R, Watada J, González-Aparicio MT (2018) Automatic schema suggestion model for NoSQL document-stores databases. J Big Data 5(1):1–17

    Article  Google Scholar 

  11. Karnitis G, Arnicans G (2015) Migration of relational database to document-oriented database: structure denormalization and data transformation. In: 7th International Conference on Computational Intelligence, Communication Systems and Networks, pp. 113–118

  12. Lee C, Zheng Y (2015) Automatic SQL-to-NoSQL schema transformation over the MySQL and HBase databases. In: IEEE International Conference on Consumer Electronics-Taiwan, pp. 426–427

  13. Zhao G, Li L, Li Z, Lin Q (2014) Multiple nested schema of HBase for migration from SQL. In: Proceedings-2014 9th International Conference on P2P, Parallel, Grid, Cloud and Internet Computing, 2014, pp. 338–343

  14. Rocha L, Vale F, Cirilo E, Barbosa D, Mourão F (2015) A framework for migrating relational datasets to NoSQL. Proced Comput Sci 51(1):2593–2602

    Article  Google Scholar 

  15. Freitas De MC, Souza DY, Salgado AC (2016) Conceptual mappings to convert relational into NoSQL databases. In: ICEIS 2016-Proceedings of the 18th International Conference on Enterprise Information Systems, pp. 174–181

Download references

Author information

Authors and Affiliations

  1. International Institute of Professional Studies, Devi Ahilya University, Indore, India

    Basant Namdeo

  2. School of Computer Science and IT, Devi Ahilya University, Indore, India

    Ugrasen Suman

Authors
  1. Basant Namdeo
    View author publications

    You can also search for this author in PubMed Google Scholar

  2. Ugrasen Suman
    View author publications

    You can also search for this author in PubMed Google Scholar

Corresponding author

Correspondence to Basant Namdeo.

Rights and permissions

Reprints and permissions

About this article

Check for updates. Verify currency and authenticity via CrossMark

Cite this article

Namdeo, B., Suman, U. Schema design advisor model for RDBMS to NoSQL database migration. Int. j. inf. tecnol. 13, 277–286 (2021). https://doi.org/10.1007/s41870-020-00515-8

Download citation

  • Received:

  • Accepted:

  • Published:

  • Issue Date:

  • DOI: https://doi.org/10.1007/s41870-020-00515-8

Keywords

Search

Navigation