Skip to main content
SpringerLink
Log in

Analysis of the Performance of NewSQL Databases Compared to RDBMS Based on Linux OS

  • Conference paper
  • First Online:
Software Engineering Application in Systems Design (CoMeSySo 2022)

Part of the book series: Lecture Notes in Networks and Systems ((LNNS,volume 596))

Included in the following conference series:

Abstract

Besides the well-known relational database management systems (RDBMS) a new kind of databases called NewSQL databases were developed. NewSQL databases aim to combine the advantages of RDBMS and NoSQL databases. In this article the performance of the most popular RDBMS and NewSQL databases is measured and compared to each other. The objective is to measure whether there is a improve of performance for NewSQL databases as promised. To get comparable results a data set was prepared as well as homogeneous test settings were defined. Furthermore KPIs for the measurement were specified. The outcome of the performance tests are displayed and explained. Conclusions as well as recommended actions are made.

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

Access this chapter

Log in via an institution

Subscribe and save

Springer+ Basic
$34.99 /Month
  • Get 10 units per month
  • Download Article/Chapter or eBook
  • 1 Unit = 1 Article or 1 Chapter
  • Cancel anytime
Subscribe now

Buy Now

Chapter
USD 29.95
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
eBook
USD 149.00
Price excludes VAT (USA)
  • Available as EPUB and PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book
USD 199.99
Price excludes VAT (USA)
  • Compact, lightweight edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info

Tax calculation will be finalised at checkout

Purchases are for personal use only

Institutional subscriptions

Similar content being viewed by others

References

  1. Almassabi, A., Bawazeer, O., Adam, S.: Top NewSQL databases and features classification. Int. J. Database Manag. Syst. 10, 11–31 (2018)

    Article  Google Scholar 

  2. Anslett, M.: NoSQL, NewSQL and beyond: the drivers and use cases for database alternatives. The Drivers and Use Cases for Database Alternatives, NoSQL, NewSQL and Beyond (2011)

    Google Scholar 

  3. Anton, C.A., Matei, O., Avram, A.: Collaborative data mining in agriculture for prediction of soil moisture and temperature. In: Computer Science On-Line Conference, pp. 141–151. Springer (2019)

    Google Scholar 

  4. Aslett, M.: How will the database incumbents respond to NoSQL and NewSQL (2011)

    Google Scholar 

  5. Avram, A., Matei, O., Pintea, C.M., Pop, P.C., Anton, C.A.: Context-aware data mining vs classical data mining: case study on predicting soil moisture. In: International Workshop on Soft Computing Models in Industrial and Environmental Applications, pp. 199–208. Springer (2019)

    Google Scholar 

  6. Bakuya, T., Matsui, M.: Relational database management system. US Patent 5,680,614 (21 Oct 1997)

    Google Scholar 

  7. Binani, S., Gutti, A., Upadhyay, S.: SQL vs. NoSQL vs. NewSQL—a comparative study. Database 6(1), 1–4 (2016)

    Google Scholar 

  8. Chandra, U.: A comparative study on: NoSQL, NewSQL and Polygot persistence. Int. J. Soft Comput. Eng. (IJSE) 7 (2017)

    Google Scholar 

  9. Chereja, I., Hahn, S.M.L., Matei, O., Avram, A.: Multidimensional analysis of NewSQL database systems. In: Computer Science On-line Conference, pp. 221–236. Springer (2021)

    Google Scholar 

  10. Chereja, I., Hahn, S.M.L., Matei, O., Avram, A.: Operationalizing analytics with NewSQL. In: Computer Science On-line Conference, pp. 249–263. Springer (2021)

    Google Scholar 

  11. Chopra, R.: Database Management System (DBMS). A Practical Approach. S. Chand Publishing (2010)

    Google Scholar 

  12. Codd, E.F.: A relational model of data for large shared data banks. In: Software Pioneers, pp. 263–294. Springer (2002)

    Google Scholar 

  13. Codd, E.: An evaluation scheme for database management systems that are claimed to be relational. In: 1986 IEEE Second International Conference on Data Engineering, pp. 720–729. IEEE (1986)

    Google Scholar 

  14. Committee, C.S., et al.: CODASYL data base task group: April 1971 report. ACM, New York (1971)

    Google Scholar 

  15. Fatima, H., Wasnik, K.: Comparison of SQL, NoSQL and NewSQL databases for internet of things. In: 2016 IEEE Bombay Section Symposium (IBSS), pp. 1–6. IEEE (2016)

    Google Scholar 

  16. solidIT Consulting & Software Development GmbH: Db-engines (2021). db-engines.com/

    Google Scholar 

  17. Gurevich, Y.: Comparative survey of NoSQL/NewSQL DB systems. Department of Mathematics and Computer Science, The Open University of Israel (2015)

    Google Scholar 

  18. Haerder, T., Reuter, A.: Principles of transaction-oriented database recovery. ACM Comput. Surv. (CSUR) 15(4), 287–317 (1983)

    Article  MathSciNet  Google Scholar 

  19. Hahn, S.M.L., Chereja, I., Matei, O.: Analysis of transformation tools applicable on NewSQL databases. In: Computer Science On-line Conference, pp. 180–195. Springer (2021)

    Google Scholar 

  20. Hahn, S.M.L., Chereja, I., Matei, O.: Comparison of the performance of NewSQL databases based on Linux OS (to appear). In: Proceedings of the Computational Methods in Systems and Software. Springer (2021)

    Google Scholar 

  21. Hahn, S.M.L., Chereja, I., Matei, O.: Evaluation of transformation tools in the context of NoSQL databases. In: Proceedings of SAI Intelligent Systems Conference, pp. 146–165. Springer (2021)

    Google Scholar 

  22. Hajoui, O., Dehbi, R., Talea, M., Batouta, Z.I.: An advanced comparative study of the most promising NoSQL and NewSQL databases with a multi-criteria analysis method. J. Theor. Appl. Inf. Technol. 81(3), 579 (2015)

    Google Scholar 

  23. Han, J., Haihong, E., Le, G., Du, J.: Survey on NoSQL database. In: 2011 6th International Conference on Pervasive Computing and Applications, pp. 363–366 (2011)

    Google Scholar 

  24. Kaur, K., Sachdeva, M.: Performance evaluation of NewSQL databases. In: 2017 International Conference on Inventive Systems and Control (ICISC), pp. 1–5. IEEE (2017)

    Google Scholar 

  25. Kelly, A.: Making sense of NoSQL: a guide for managers and the rest of us by Ann Kelly and Dan McCreary (2013)

    Google Scholar 

  26. Khasawneh, T.N., AL-Sahlee, M.H., Safia, A.A.: SQL, NewSQL, and NoSQL databases: a comparative survey. In: 2020 11th International Conference on Information and Communication Systems (ICICS), pp. 013–021 (2020)

    Google Scholar 

  27. Kumar, R., Gupta, N., Maharwal, H., Charu, S., Yadav, K.: Critical analysis of database management using NewSQL. Int. J. Comput. Sci. Mob. Comput. 3, 434–438 (2014)

    Google Scholar 

  28. Matei, O., Rusu, T., Petrovan, A., Mihuţ, G.: A data mining system for real time soil moisture prediction. Procedia Eng. 181, 837–844 (2017)

    Article  Google Scholar 

  29. Moniruzzaman, A.B.M.: NewSQL: towards next-generation scalable RDBMS for online transaction processing (OLTP) for big data management. Int. J. Database Theory Appl. 7 (2014)

    Google Scholar 

  30. Pavlo, A., Aslett, M.: What’s really new with NewSQL? ACM Sigmod Rec. 45(2), 45–55 (2016)

    Article  Google Scholar 

  31. Sharma, V., Dave, M.: SQL and NoSQL databases. Int. J. Adv. Res. Comput. Sci. Softw. Eng. 2(8) (2012)

    Google Scholar 

  32. Sumathi, S., Esakkirajan, S.: Fundamentals of Relational Database Management Systems, vol. 47. Springer (2007)

    Google Scholar 

  33. Theodorou, V., Abelló, A., Lehner, W.: Quality measures for ETL processes. In: International Conference on Data Warehousing and Knowledge Discovery, pp. 9–22. Springer (2014)

    Google Scholar 

Download references

Author information

Authors and Affiliations

  1. Computers and Information Technology, Technical University Cluj Napoca, Cluj-Napoca, Romania

    Sarah Myriam Lydia Hahn, Ionela Chereja & Oliviu Matei

Authors
  1. Sarah Myriam Lydia Hahn
    View author publications

    You can also search for this author in PubMed Google Scholar

  2. Ionela Chereja
    View author publications

    You can also search for this author in PubMed Google Scholar

  3. Oliviu Matei
    View author publications

    You can also search for this author in PubMed Google Scholar

Corresponding author

Correspondence to Sarah Myriam Lydia Hahn .

Editor information

Editors and Affiliations

  1. Faculty of Applied Informatics, Tomas Bata University in Zlín, Zlín, Czech Republic

    Radek Silhavy

  2. Faculty of Applied Informatics, Tomas Bata University in Zlín, Zlín, Czech Republic

    Petr Silhavy

  3. Faculty of Applied Informatics, Tomas Bata University in Zlín, Zlín, Czech Republic

    Zdenka Prokopova

Rights and permissions

Reprints and permissions

Copyright information

© 2023 The Author(s), under exclusive license to Springer Nature Switzerland AG

About this paper

Check for updates. Verify currency and authenticity via CrossMark

Cite this paper

Hahn, S.M.L., Chereja, I., Matei, O. (2023). Analysis of the Performance of NewSQL Databases Compared to RDBMS Based on Linux OS. In: Silhavy, R., Silhavy, P., Prokopova, Z. (eds) Software Engineering Application in Systems Design. CoMeSySo 2022. Lecture Notes in Networks and Systems, vol 596. Springer, Cham. https://doi.org/10.1007/978-3-031-21435-6_59

Download citation

Publish with us

Policies and ethics

Search

Navigation