Abstract
State-of-the-art database paradigm allows data to generate from different types of devices but these data have no fixed format according to RDBMS structure. Due to industrial need for business expansion, these data need to be restructured into effective database. Therefore, there is a need for migrating existing data into new database technology such as NoSQL which can efficiently handle them. NoSQL is a group of technologies, which does not follow the concept of relational database. NoSQL stores information in different types of data model such as column oriented, document oriented, or graph based. These models have their own way of storing information and schema design. Various research works have been performed in finding appropriate schema design for migration of data from relational model to NoSQL. In this paper, we have performed performance analysis of different database schema design for migration from RDBMS to NoSQL databases. The selected replication schema design provides better performance in execution time.
This is a preview of subscription content, log in via an institution to check access.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
References
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.
Cattell, R. (2010). Scalable SQL and NoSQL data stores. ACM Sigmod Record, 39(4) 12–27.
Moniruzzaman, A. B. M. & Hossain, S. A. (2013). NoSQL database: New era of databases for big data analytics—Classification, characteristics and comparison. International Journal of Database Theory and Application, 6(4).
Sadalage, P. J., & Fowler, M. (2013). NoSQL distilled: A brief guide to the emerging world of polyglot persistence. Addison-Wesley Professional.
Mior, M. J. (2014). Automated schema design for NoSQL databases. In Proceedings of 2014 SIGMOD Ph.D. Symposium (pp. 41–45). ACM.
Mior, M. J., Salem, K., Aboulnaga, A., & Liu, R. (2017). NoSE: Schema design for NoSQL applications. IEEE Transactions on Knowledge and Data Engineering, 29(10), 2275–2289.
Kuderu, N., & Kumari, V. (2016). Relational database to NoSQL conversion by schema migration and mapping. International Journal of Computer Engineering in Research Trends, 3(9), 506–513.
Lee, C.-H., & Zheng, Y.-L. (2015). Automatic SQL-to-NoSQL schema transformation over the MySQL and HBase databases. Presented at the 2015 IEEE International Conference on Consumer Electronics—Taiwan (pp. 426–427). Taipei, Taiwan, June 6–8, 2015.
Chongxin, L. (2010). Transforming relational database into HBase: A case study. In IEEE International Conference on Software Engineering and Service Sciences (683–687). Beijing, China.
HBase Information. https://hbase.apache.org/.
Zhao, G., Li, L., Li, Z., & Lin, Q. (2014). Multiple nested schema of HBase for migration from SQL. In 2014 Ninth International Conference on P2P, Parallel, Grid, Cloud and Internet Computing (3PGCIC) (pp. 338–343). Guangdong, China. https://doi.org/10.1109/3pgcic.2014.127.
Vajk, T., Feher, P., Fekete, K., & Charaf, H. (2013). Denormalizing data into schema-free databases. In 2013 IEEE 4th International Conference on Cognitive Infocommunications (CogInfoCom) (pp. 747–752).
Yangui, R., Nabli, A., & Gargouri, F. (2016). Automatic transformation of data warehouse schema to NoSQL data base: Comparative study. Procedia Computer Science, 96, 255–264.
Stanescu, L., Brezovan, M., & Burdescu, D. D. (2016). Automatic mapping of MySQL databases to NoSQL MongoDB. Presented at the 2016 Federated Conference on Computer Science and Information Systems (FedCSIS). Gdansk, Poland, September 11–14, 2016.
Karnitis, G., & Arnicans, G. (2015). Migration of relational database to document-oriented database: Structure Denormalization and data transformation. In 7th International Conf. on Computational Intelligence, Communication Systems and Networks (CICSyN) (pp. 113–118). Riga, Latvia.
Zhao, G., Lin, Q., Li, L., & Li, Z. (2014). Schema conversion model of SQL database to NoSQL. In 9th International Conference on P2P, Parallel, Grid, Cloud and Internet Computing (pp. 355–362). Guangdong, China.
Yoo, J., Lee, K.-H., & Jeon, Y.-H. (2018). Migration from RDBMS to NoSQL using column-level denormalization and atomic aggregates. Journal of Information Science and Engineering, 34(1), 243–259.
Park, Y., Shankar, M., Park, B.-H., & Ghosh, J. (2014). Graph databases for large-scale healthcare systems: A framework for efficient data management and data services. In IEEE 30th International Conference on Data Engineering Workshops (pp. 12–19). Chicago, IL, USA.
De Virgilio, R., Maccioni, A., & Torlone, R. (2013). Converting relational to graph databases. In First International Workshop on Graph Data Management Experiences and Systems. ACM.
Author information
Authors and Affiliations
Corresponding author
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2020 Springer Nature Singapore Pte Ltd.
About this paper
Cite this paper
Namdeo, B., Suman, U. (2020). Performance Analysis of Schema Design Approaches for Migration from RDBMS to NoSQL Databases. In: Kolhe, M., Tiwari, S., Trivedi, M., Mishra, K. (eds) Advances in Data and Information Sciences. Lecture Notes in Networks and Systems, vol 94. Springer, Singapore. https://doi.org/10.1007/978-981-15-0694-9_39
Download citation
DOI: https://doi.org/10.1007/978-981-15-0694-9_39
Published:
Publisher Name: Springer, Singapore
Print ISBN: 978-981-15-0693-2
Online ISBN: 978-981-15-0694-9
eBook Packages: EngineeringEngineering (R0)