Skip to main content
SpringerLink
Log in

Multidimensional Analysis of NewSQL Database Systems

  • Conference paper
  • First Online:
Software Engineering and Algorithms (CSOC 2021)

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

Included in the following conference series:

Abstract

Collecting, transforming and analyzing data is seeing an all time high interest over the last few years. Due to the large amount of emerging or enhanced data management systems, as well as the high amount of differences in features and options they support, this paper is focused on reviewing the existing systems that are part of the NewSQL category. By looking at the top nine most used and researched implementations this work investigates how these compare in terms of supported data models, transactionality features and querying abilities. Furthermore, it provides an overview of scalability implementations and functionality as well as security assets and liabilities. It also includes an analysis of costs, by looking at both licensing as well as infrastructural support. This work can be used as a guiding analysis for providing insights into what features are supported and offered by the top NewSQL systems available over multiple dimensions.

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 129.00
Price excludes VAT (USA)
  • Available as EPUB and PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book
USD 169.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. Abadi, D.: Consistency tradeoffs in modern distributed database system design: cap is only part of the story. Computer 45(2), 37–42 (2012)

    Article  Google Scholar 

  2. Agrawal, S., Narasayya, V., Yang, B.: Integrating vertical and horizontal partitioning into automated physical database design. In: Proceedings of the 2004 ACM SIGMOD international conference on Management of data, pp. 359–370 (2004)

    Google Scholar 

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

    Article  Google Scholar 

  4. Altibase: Altibase (2020). https://altibase.com/

  5. Aslett, M.: What we talk about when we talk about newsql (2020). https://blogs.451research.com/information_management/2011/04/06/what-we-talk-about-when-we-talk-about-newsql/

  6. Bader, A., Kopp, O., Falkenthal, M.: Survey and comparison of open source time series databases. Datenbanksysteme für Business, Technologie und Web (BTW 2017)-Workshopband (2017)

    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. Brewer, E.: Spanner, truetime and the cap theorem (2017)

    Google Scholar 

  9. Burchall, L.D., Goodsell, A.E., Shirley, B.A.: Delaying database writes for database consistency (2014). uS Patent 8,768,890

    Google Scholar 

  10. Chandra, U.: A comparative study on: Nosql, newsql and polygot persistence. Int. J. Soft Comput. Eng. 7 (2017)

    Google Scholar 

  11. Chang, F., et al.: Bigtable: a distributed storage system for structured data. ACM Trans. Comput. Syst. 26(2), 1–26 (2008)

    Google Scholar 

  12. CitusData: Citus (2020). https://www.citusdata.com/

  13. Cockroachlabs: Cockroachdb (2020). https://www.cockroachlabs.com/

  14. Codd, E.F.: Data models in database management. In: Proceedings of the 1980 Workshop on Data Abstraction, Databases and Conceptual Modeling, pp. 112–114 (1980)

    Google Scholar 

  15. 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 

  16. Corbellini, A., Mateos, C., Zunino, A., Godoy, D., Schiaffino, S.: Persisting big-data: the nosql landscape. Inf. Syst. 63, 1–23 (2017)

    Article  Google Scholar 

  17. nosql database.org: Nosql (2020). http://nosql-database.org/

  18. Fauna: Fauna (2020). https://fauna.com

  19. solidIT consulting & software development GmbH: Db-engines (2020). https://db-engines.com/

  20. Grolinger, K., Higashino, W.A., Tiwari, A., Capretz, M.A.: Data management in cloud environments: nosql and newsql data stores. J. Cloud Comput.: Adv. Syst. Appl. 2(1), 22 (2013). https://springerlink.bibliotecabuap.elogim.com/article/10.1186/2192-113X-2-22

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

    Article  MathSciNet  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. IEEE (2011)

    Google Scholar 

  24. Haselmann, T., Thies, G., Vossen, G.: Looking into a rest-based universal api for database-as-a-service systems. In: 2010 IEEE 12th Conference on Commerce and Enterprise Computing, pp. 17–24. IEEE (2010)

    Google Scholar 

  25. Hecht, R., Jablonski, S.: Nosql evaluation: a use case oriented survey. In: 2011 International Conference on Cloud and Service Computing, pp. 336–341. IEEE (2011)

    Google Scholar 

  26. Holenstein, P.J., Holenstein, B.D., Highleyman, W.H.: Referential integrity, consistency, and completeness loading of databases (2011). uS Patent 7,949,640

    Google Scholar 

  27. Huang, D., et al.: Tidb: a raft-based htap database. Proc. VLDB Endowment 13(12), 3072–3084 (2020)

    Google Scholar 

  28. Inc., G.: Spanner (2020). https://cloud.google.com/spanner

  29. Jung, K.C., Lee, K.W., Bae, H.Y.: Design and implementation of replication management in main memory dbms altibase tm. In: International Conference on Parallel and Distributed Computing: Applications and Technologies, pp. 62–67. Springer (2004). https://doi.org/10.1007/b103538

  30. 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 

  31. 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 

  32. Leavitt, N.: Will nosql databases live up to their promise? Computer 43(2), 12–14 (2010)

    Article  Google Scholar 

  33. Lu, J., Holubová, I.: Multi-model databases: a new journey to handle the variety of data. ACM Comput. Surv. 52(3), 1–38 (2019)

    Article  Google Scholar 

  34. Mahfoud, Z., Nouali-Taboudjemat, N.: Consistency in cloud-based database systems. Informatica 43(3) (2019)

    Google Scholar 

  35. May, N., Bohm, A., Lehner, W.: Sap hana–the evolution of an in-memory dbms from pure olap processing towards mixed workloads. Datenbanksysteme für Business, Technologie und Web (BTW 2017) (2017)

    Google Scholar 

  36. Meyer, S., Degener, J., Michener, B., Giannandrea, J.: Database replication (2012). uS Patent 8,204,856

    Google Scholar 

  37. Mohamed, M.A., Altrafi, O.G., Ismail, M.O.: Relational vs. nosql databases: a survey. Int. J. Comput. Inf. Technol. 3(03), 598–601 (2014)

    Google Scholar 

  38. Nayak, A., Poriya, A., Poojary, D.: Type of nosql databases and its comparison with relational databases. Int. J. Appl. Inf. Syst. 5(4), 16–19 (2013)

    Google Scholar 

  39. NuoDB: Nuodb (2020). https://nuodb.com/

  40. O’Neil, P., Cheng, E., Gawlick, D., O’Neil, E.: The log-structured merge-tree (lsm-tree). Acta Informatica 33(4), 351–385 (1996)

    Article  Google Scholar 

  41. Padhy, R.P., Patra, M.R., Satapathy, S.C.: Rdbms to nosql: reviewing some next-generation non-relational database’s. Int. J. Adv. Eng. Sci. Technol. 11(1), 15–30 (2011)

    Google Scholar 

  42. Peng, D., Dabek, F.: Large-scale incremental processing using distributed transactions and notifications (2010)

    Google Scholar 

  43. PingCap: Tidb (2020). https://pingcap.com/

  44. Stonebraker, M.: Sql databases v. nosql databases. Commun. ACM 53(4), 10–11 (2010)

    Google Scholar 

  45. Vatika, S., Meenu, D.: Sql and nosql databases. Int. J. Adv. Res. Comput. Sci. Softw. Eng. 2(8), 20–27 (2012)

    Google Scholar 

  46. VoltDB, I.: Voltdb (2020). https://www.voltdb.com/

Download references

Acknowledgments

This research was made possible by funding from the ICT-AGRI-FOOD 2020 Joint Call. This work was supported by a grant of the Romanian National Authority for Scientific Research and Innovation, CCCDI - UEFISCDI, project number COFUND-ICT-AGRI-FOOD-MUSHNOMICS 205/2020, within PNCDI III.

Author information

Authors and Affiliations

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

    Ionela Chereja, Sarah Myriam Lydia Hahn, Oliviu Matei & Anca Avram

Authors
  1. Ionela Chereja
    View author publications

    You can also search for this author in PubMed Google Scholar

  2. Sarah Myriam Lydia Hahn
    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

  4. Anca Avram
    View author publications

    You can also search for this author in PubMed Google Scholar

Corresponding author

Correspondence to Ionela Chereja .

Editor information

Editors and Affiliations

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

    Radek Silhavy

Rights and permissions

Reprints and permissions

Copyright information

© 2021 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

Chereja, I., Hahn, S.M.L., Matei, O., Avram, A. (2021). Multidimensional Analysis of NewSQL Database Systems. In: Silhavy, R. (eds) Software Engineering and Algorithms. CSOC 2021. Lecture Notes in Networks and Systems, vol 230. Springer, Cham. https://doi.org/10.1007/978-3-030-77442-4_19

Download citation

Publish with us

Policies and ethics

Search

Navigation