Skip to main content
SpringerLink
Log in

NoSQL: A Real Use Case

  • Conference paper
  • First Online:
New Trends in Disruptive Technologies, Tech Ethics and Artificial Intelligence (DiTTEt 2021)

Part of the book series: Advances in Intelligent Systems and Computing ((AISC,volume 1410))

  • 1269 Accesses

Abstract

As the amount of information flow increases, business companies feel the need to improve on storage systems. Henceforth, to tackle this increasing need, paradigms such as NoSQL emerge to solve the unlimited data growing requirement. However, the NoSQL solution has no proofs given in the field to support their solution claims.

Benchmarks can test and compare different solutions performance by executing queries over a toy dataset (synthetically generated). The problem with benchmarking results is how to extend the conclusions to a real system operating within a real business scenario.

In this paper, an actual corporate case study is used, with real-world data, to evaluate how NoSQL databases perform. First, using big data, write-intensive tests are implemented and evaluated using Cassandra, MongoDB, Couchbase, and compared with the relational database in place, which is within the throughput limit. Results show a throughput comparison for each tested approach.

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

Access this chapter

Log in via an institution
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

References

  1. Acharya, B., Jena, A.K., Chatterjee, J.M., Kumar, R., Le, D.-N.: Nosql database classification: new era of databases for big data. Int. J. Knowl.-Based Organ. (IJKBO) 9(1), 50–65 (2019)

    Google Scholar 

  2. Bach, M., Werner, A.: Standardization of NoSQL database languages. In: Kozielski, S., Mrozek, D., Kasprowski, P., Małysiak-Mrozek, B., Kostrzewa, D. (eds.) BDAS 2014. CCIS, vol. 424, pp. 50–60. Springer, Cham (2014). https://doi.org/10.1007/978-3-319-06932-6_6

    Chapter  Google Scholar 

  3. Banker, K.: MongoDB in Action. Manning Publications Co. (2011)

    Google Scholar 

  4. Băzăr, C., Iosif, C.S., et al.: The transition from rdbms to nosql. a comparative analysis of three popular non-relational solutions: Cassandra, mongodb and couchbase. Database Syst. J. 5(2), 49–59 (2014)

    Google Scholar 

  5. Brewer, E.A.: Towards robust distributed systems. In: PODC, vol. 7 (2000)

    Google Scholar 

  6. Chen, C.P., Zhang, C.-Y.: Data-intensive applications, challenges, techniques and technologies: a survey on big data. Inf. Sci. 275, 314–347 (2014)

    Article  Google Scholar 

  7. Chen, Z., Yang, S., Tan, S., He, L., Yin, H., Zhang, G.: A new fragment re-allocation strategy for nosql database systems. Front. Comput. Sci. 9(1), 111–127 (2015)

    Article  MathSciNet  Google Scholar 

  8. Cooper, B.F., Silberstein, A., Tam, E., Ramakrishnan, R., Sears, R.: Benchmarking cloud serving systems with ycsb. In: Proceedings of the 1st ACM Symposium on Cloud Computing, pp. 143–154. ACM (2010)

    Google Scholar 

  9. Corproration, D.: Benchmarking top nosql databases: a performance comparison for architects and it managers (2013)

    Google Scholar 

  10. Dory, T., Mejías, B., Van Roy, P., Tran, N. L.: Comparative elasticity and scalability measurements of cloud databases. In: Proceedings of the 2nd ACM Symposium on Cloud Computing (SoCC), vol. 11. Citeseer (2011)

    Google Scholar 

  11. Floratou, A., Teletia, N., DeWitt, D.J., Patel, J.M., Zhang, D.: Can the elephants handle the nosql onslaught? Proc. VLDB Endowment 5(12), 1712–1723 (2012)

    Article  Google Scholar 

  12. Hammes, D., Medero, H., Mitchell, H.: Comparison of nosql and sql databases in the cloud. In: Proceedings of the Southern Association for Information Systems (SAIS), Macon, GA, pp. 21–22 (2014)

    Google Scholar 

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

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

  15. Lakshman, A., Malik, P.: Cassandra: a decentralized structured storage system. ACM SIGOPS Oper. Syst. Rev. 44(2), 35–40 (2010)

    Article  Google Scholar 

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

    Article  Google Scholar 

  17. Lomotey, R.K., Deters, R.: Terms mining in document-based nosql: response to unstructured data. In: 2014 IEEE International Congress on Big Data, pp. 661–668. IEEE (2014)

    Google Scholar 

  18. Mazurek, M.: Applying NoSQL databases for operationalizing clinical data mining models. In: Kozielski, S., Mrozek, D., Kasprowski, P., Małysiak-Mrozek, B., Kostrzewa, D. (eds.) BDAS 2014. CCIS, vol. 424, pp. 527–536. Springer, Cham (2014). https://doi.org/10.1007/978-3-319-06932-6_51

    Chapter  Google Scholar 

  19. Moniruzzaman, A., Hossain, S.A.: Nosql database: new era of databases for big data analytics-classification, characteristics and comparison. arXiv preprint arXiv:1307.0191 (2013)

  20. Sellami, R., Bhiri, S., Defude, B.: Odbapi: a unified rest api for relational and nosql data stores. In: 2014 IEEE International Congress on Big Data, pp. 653–660. IEEE (2014)

    Google Scholar 

  21. Silva, L.A.B., Beroud, L., Costa, C., Oliveira, J.L.: Medical imaging archiving: a comparison between several nosql solutions. In: IEEE-EMBS International Conference on Biomedical and Health Informatics (BHI), pp. 65–68. IEEE (2014)

    Google Scholar 

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

    Article  Google Scholar 

  23. Stonebraker, M.: Stonebraker on nosql and enterprises. Commun. ACM 54(8), 10–11 (2011)

    Article  Google Scholar 

  24. Tudorica, B.G., Bucur, C.: A comparison between several nosql databases with comments and notes. In: 2011 RoEduNet International Conference 10th Edition: Networking in Education and Research, pp. 1–5. IEEE (2011)

    Google Scholar 

  25. ul Haque, A., Mahmood, T., Ikram, N.: Performance comparison of state of art NoSql technologies using apache spark. In: Arai, K., Kapoor, S., Bhatia, R. (eds.) IntelliSys 2018. AISC, vol. 869, pp. 563–576. Springer, Cham (2019). https://doi.org/10.1007/978-3-030-01057-7_44

    Chapter  Google Scholar 

  26. Wingerath, W., Gessert, F., Ritter, N.: Nosql & real-time data management in research & practice. In: BTW 2019–Workshopband (2019)

    Google Scholar 

  27. Zhong, T., Doshi, K., Tang, X., Lou, T., Lu, Z., Li, H.: Big data workloads drawn from real-time analytics scenarios across three deployed solutions. In: Rabl, T., Jacobsen, H.-A., Raghunath, N., Poess, M., Bhandarkar, M., Baru, C. (eds.) WBDB 2013. LNCS, vol. 8585, pp. 97–104. Springer, Cham (2014). https://doi.org/10.1007/978-3-319-10596-3_8

    Chapter  Google Scholar 

Download references

Acknowledgements

“This work is funded by National Funds through the FCT - Foundation for Science and Technology, I.P., within the scope of the project Ref UIDB/05583/2020. Furthermore, we would like to thank the Research Centre in Digital Services (CISeD), the Polytechnic of Viseu for their support”.

Author information

Authors and Affiliations

  1. CISeD – Research Centre in Digital Services, Polytechnic of Viseu, Viseu, Portugal

    Pedro Martins, Filipe Sá & Filipe Caldeira

  2. Department of Computer Sciences, University of Coimbra, Coimbra, Portugal

    Maryam Abbasi

Authors
  1. Pedro Martins
    View author publications

    You can also search for this author in PubMed Google Scholar

  2. Filipe Sá
    View author publications

    You can also search for this author in PubMed Google Scholar

  3. Filipe Caldeira
    View author publications

    You can also search for this author in PubMed Google Scholar

  4. Maryam Abbasi
    View author publications

    You can also search for this author in PubMed Google Scholar

Corresponding authors

Correspondence to Pedro Martins or Filipe Caldeira .

Editor information

Editors and Affiliations

  1. Faculty of Science, University of Salamanca, Salamanca, Spain

    Juan F. de Paz Santana

  2. Facultad de Informática, Universidad Pontificia de Salamanca, Salamanca, Spain

    Daniel H. de la Iglesia

  3. Facultad de Informática, Pontifical University of Salamanca, Salamanca, Spain

    Alfonso José López Rivero

Rights and permissions

Reprints and permissions

Copyright information

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

Martins, P., Sá, F., Caldeira, F., Abbasi, M. (2022). NoSQL: A Real Use Case. In: de Paz Santana, J.F., de la Iglesia, D.H., López Rivero, A.J. (eds) New Trends in Disruptive Technologies, Tech Ethics and Artificial Intelligence. DiTTEt 2021. Advances in Intelligent Systems and Computing, vol 1410. Springer, Cham. https://doi.org/10.1007/978-3-030-87687-6_23

Download citation

Publish with us

Policies and ethics

Search

Navigation