Skip to main content

A Method for Database Model Selection

  • Conference paper
  • First Online:
Enterprise, Business-Process and Information Systems Modeling (BPMDS 2019, EMMSAD 2019)

Abstract

In the last decade, new types of database models emerged, most notably the NoSQL database models. Within this family of databases there are specific models, such as Document-based, Graph-based and more, each of which, in additional to the Relational model, may fit to specific types of applications. Hence, the issue of which database model to select for a given application becomes important. Nowadays, to the best of our knowledge, the selection of a database model is not based on systematic methods that consider the specific requirements and characteristics of the sought application. In this paper we propose a structured method for database model selection. The method considers a variety of factors, including data-related requirements, functional requirements and non-functional requirements. Based on these factors the method proposes the most appropriate database models for that application. We demonstrate the method through a running example.

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

Access this chapter

Chapter
USD 29.95
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
eBook
USD 39.99
Price excludes VAT (USA)
  • Available as EPUB and PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book
USD 54.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

Notes

  1. 1.

    https://db-engines.com/en/ranking.

  2. 2.

    https://scikit-learn.org/stable/modules/generated/sklearn.cluster.DBSCAN.html.

  3. 3.

    https://xlinux.nist.gov/dads/HTML/manhattanDistance.html.

  4. 4.

    https://www.imdb.com/.

References

  1. Angles, R.: A comparison of current graph database models. In: 2012 IEEE 28th International Conference on Data Engineering Workshops, pp. 171–177. IEEE, April 2012

    Google Scholar 

  2. Gessert, F., Wingerath, W., Friedrich, S., Ritter, N.: NoSQL database systems: a survey and decision guidance. Comput. Sci. Res. Dev. 32(3–4), 353–365 (2017)

    Article  Google Scholar 

  3. 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, October 2011

    Google Scholar 

  4. Haseeb, A., Pattun, G.: A review on NoSQL: applications and challenges. Int. J. Adv. Res. Comput. Sci. 8(1), 203–207 (2017)

    Google Scholar 

  5. Jouili, S., Vansteenberghe, V.: An empirical comparison of graph databases. In: 2013 International Conference on Social Computing, pp. 708–715. IEEE, September 2013

    Google Scholar 

  6. Khazaei, H., et al.: How do I choose the right NoSQL solution? A comprehensive theoretical and experimental survey. Big Data Inf. Anal. (BDIA) 2, 1 (2016)

    Google Scholar 

  7. Kolomičenko, V., Svoboda, M., Mlýnková, I.H.: Experimental comparison of graph databases. In: Proceedings of International Conference on Information Integration and Web-based Applications & Services, p. 115. ACM, December 2013

    Google Scholar 

  8. Kumar, R., Parashar, B.B., Gupta, S., Sharma, Y., Gupta, N.: Apache Hadoop, NoSQL and NewSQL solutions of big data. Int. J. Adv. Found. Res. Sci. Eng. (IJAFRSE) 1(6), 28–36 (2014)

    Google Scholar 

  9. Lourenço, J.R., Cabral, B., Carreiro, P., Vieira, M., Bernardino, J.: Choosing the right NoSQL database for the job: a quality attribute evaluation. J. Big Data 2(1), 18 (2015)

    Article  Google Scholar 

  10. Mior, M.J., Salem, K., Aboulnaga, A., Liu, R.: NoSE: schema design for NoSQL applications. IEEE Trans. Knowl. Data Eng. 29(10), 2275–2289 (2017)

    Article  Google Scholar 

  11. Saaty, T.L.: Decision making with the analytic hierarchy process. Int. J. Serv. Sci. 1(1), 83–98 (2008)

    MathSciNet  Google Scholar 

  12. Storey, V.C., Song, I.Y.: Big data technologies and management: what conceptual modeling can do. Data Knowl. Eng. 108, 50–67 (2017)

    Article  Google Scholar 

  13. Tang, E., Fan, Y.: Performance comparison between five NoSQL databases. In: 2016 7th International Conference on Cloud Computing and Big Data, pp. 105–109. IEEE, November 2016

    Google Scholar 

  14. 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, June 2011

    Google Scholar 

Download references

Author information

Authors and Affiliations

Authors

Corresponding author

Correspondence to Noa Roy-Hubara .

Editor information

Editors and Affiliations

Rights and permissions

Reprints and permissions

Copyright information

© 2019 Springer Nature Switzerland AG

About this paper

Check for updates. Verify currency and authenticity via CrossMark

Cite this paper

Roy-Hubara, N., Shoval, P., Sturm, A. (2019). A Method for Database Model Selection. In: Reinhartz-Berger, I., Zdravkovic, J., Gulden, J., Schmidt, R. (eds) Enterprise, Business-Process and Information Systems Modeling. BPMDS EMMSAD 2019 2019. Lecture Notes in Business Information Processing, vol 352. Springer, Cham. https://doi.org/10.1007/978-3-030-20618-5_18

Download citation

  • DOI: https://doi.org/10.1007/978-3-030-20618-5_18

  • Published:

  • Publisher Name: Springer, Cham

  • Print ISBN: 978-3-030-20617-8

  • Online ISBN: 978-3-030-20618-5

  • eBook Packages: Computer ScienceComputer Science (R0)

Publish with us

Policies and ethics