Skip to main content

2020 | OriginalPaper | Buchkapitel

Performance Analysis of Schema Design Approaches for Migration from RDBMS to NoSQL Databases

verfasst von : Basant Namdeo, Ugrasen Suman

Erschienen in: Advances in Data and Information Sciences

Verlag: Springer Singapore

Aktivieren Sie unsere intelligente Suche, um passende Fachinhalte oder Patente zu finden.

search-config
loading …

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.

Sie haben noch keine Lizenz? Dann Informieren Sie sich jetzt über unsere Produkte:

Springer Professional "Wirtschaft+Technik"

Online-Abonnement

Mit Springer Professional "Wirtschaft+Technik" erhalten Sie Zugriff auf:

  • über 102.000 Bücher
  • über 537 Zeitschriften

aus folgenden Fachgebieten:

  • Automobil + Motoren
  • Bauwesen + Immobilien
  • Business IT + Informatik
  • Elektrotechnik + Elektronik
  • Energie + Nachhaltigkeit
  • Finance + Banking
  • Management + Führung
  • Marketing + Vertrieb
  • Maschinenbau + Werkstoffe
  • Versicherung + Risiko

Jetzt Wissensvorsprung sichern!

Springer Professional "Technik"

Online-Abonnement

Mit Springer Professional "Technik" erhalten Sie Zugriff auf:

  • über 67.000 Bücher
  • über 390 Zeitschriften

aus folgenden Fachgebieten:

  • Automobil + Motoren
  • Bauwesen + Immobilien
  • Business IT + Informatik
  • Elektrotechnik + Elektronik
  • Energie + Nachhaltigkeit
  • Maschinenbau + Werkstoffe




 

Jetzt Wissensvorsprung sichern!

Springer Professional "Wirtschaft"

Online-Abonnement

Mit Springer Professional "Wirtschaft" erhalten Sie Zugriff auf:

  • über 67.000 Bücher
  • über 340 Zeitschriften

aus folgenden Fachgebieten:

  • Bauwesen + Immobilien
  • Business IT + Informatik
  • Finance + Banking
  • Management + Führung
  • Marketing + Vertrieb
  • Versicherung + Risiko




Jetzt Wissensvorsprung sichern!

Literatur
1.
Zurück zum Zitat 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. 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.
2.
Zurück zum Zitat Cattell, R. (2010). Scalable SQL and NoSQL data stores. ACM Sigmod Record, 39(4) 12–27. Cattell, R. (2010). Scalable SQL and NoSQL data stores. ACM Sigmod Record, 39(4) 12–27.
3.
Zurück zum Zitat 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). 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).
4.
Zurück zum Zitat Sadalage, P. J., & Fowler, M. (2013). NoSQL distilled: A brief guide to the emerging world of polyglot persistence. Addison-Wesley Professional. Sadalage, P. J., & Fowler, M. (2013). NoSQL distilled: A brief guide to the emerging world of polyglot persistence. Addison-Wesley Professional.
5.
Zurück zum Zitat 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. (2014). Automated schema design for NoSQL databases. In Proceedings of 2014 SIGMOD Ph.D. Symposium (pp. 41–45). ACM.
6.
Zurück zum Zitat 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. 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.
7.
Zurück zum Zitat 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. 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.
8.
Zurück zum Zitat 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. 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.
9.
Zurück zum Zitat 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. 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.
11.
Zurück zum Zitat 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. 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.
12.
Zurück zum Zitat 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). 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).
13.
Zurück zum Zitat 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. 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.
14.
Zurück zum Zitat 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. 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.
15.
Zurück zum Zitat 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. 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.
16.
Zurück zum Zitat 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. 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.
17.
Zurück zum Zitat 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. 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.
19.
Zurück zum Zitat 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. 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.
20.
Zurück zum Zitat 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. 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.
Metadaten
Titel
Performance Analysis of Schema Design Approaches for Migration from RDBMS to NoSQL Databases
verfasst von
Basant Namdeo
Ugrasen Suman
Copyright-Jahr
2020
Verlag
Springer Singapore
DOI
https://doi.org/10.1007/978-981-15-0694-9_39

Neuer Inhalt