Skip to main content
SpringerLink
Log in

Design methods for the new database era: a systematic literature review

  • Special Section Paper
  • Published:
Software and Systems Modeling Aims and scope Submit manuscript

Abstract

Over the last decade, a range of new database solutions and technologies have emerged, in line with the new types of applications and requirements that they facilitate. Consequently, various new methods for designing these new databases have evolved, in order to keep pace with progress in the field. In this paper, we systematically review these methods, with a view to better understanding their suitability for designing new database solutions. The study shows that while research in the field has expanded continuously, a range of factors still require further attention. The study identified important criteria in database design and analyzed existing studies accordingly. This analysis will assist in defining and recommending key areas for future research, guiding the evolution of design methods, their usability and adaptability in real-world scenarios. The study found that current database design methods do not address non-functional requirements; tend to refer to a preselected database; and are lacking in their evaluation.

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

Access this article

Log in via an institution

Price excludes VAT (USA)
Tax calculation will be finalised during checkout.

Instant access to the full article PDF.

Institutional subscriptions

Fig. 1

Adapted from [13, 18]

Fig. 2
Fig. 3
Fig. 4
Fig. 5
Fig. 6
Fig. 7
Fig. 8
Fig. 9
Fig. 10
Fig. 11

Similar content being viewed by others

Notes

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

  2. https://www.martinfowler.com/articles/schemaless/.

  3. https://medium.com/capital-one-tech/nosql-database-doesnt-mean-no-schema-a824d591034e.

References

  1. Akoka, J., Comyn-Wattiau, I.: Roundtrip engineering of NoSQL databases. Enterp. Model. Inf. Syst. Archit. 13, 281–292 (2018)

    Google Scholar 

  2. Akoka, J., Comyn-Wattiau, I., Prat, N.: A four V’s design approach of NoSQL graph databases. In: International Conference on Conceptual Modeling, pp. 58–68. Springer, Cham (2017)

    Google Scholar 

  3. Atzeni, P., Bugiotti, F., Cabibbo, L., Torlone, R.: Data modeling in the NoSQL world. In: Computer Standards and Interfaces (2016)‏

  4. Atzeni, P., Jensen, C.S., Orsi, G., Ram, S., Tanca, L., Torlone, R.: The relational model is dead, SQL is dead, and I don’t feel so good myself. ACM SIGMOD Rec 42(2), 64–68 (2013)

    Article  Google Scholar 

  5. Banerjee, S., Sarkar, A.: Logical level design of NoSQL databases. In: Region 10 Conference (TENCON), 2016 IEEE, pp. 2360–2365. IEEE (2016)

  6. Banerjee, S., Sarkar, A.: Modeling NoSQL databases: from conceptual to logical level design. In: 3rd International Conference Applications and Innovations in Mobile Computing (AIMoC 2016), Kolkata, India, February, pp. 10–12 (2016)‏

  7. Benmakhlouf, A.: NOSQL implementation of a conceptual data model: UML class diagram to a document-oriented model. Int. J. Database Manage. Syst. 10(2), 1–10 (2018)

    Article  Google Scholar 

  8. Bjeladinovic, S.: A fresh approach for hybrid SQL/NoSQL database design based on data structuredness. Enterp. Inf. Syst. 12, 1–19 (2018)

    Article  Google Scholar 

  9. Boussahoua, M., Boussaid, O., Bentayeb, F.: Logical schema for data warehouse on column-oriented NoSQL databases. In: International Conference on Database and Expert Systems Applications, pp. 247–256. Springer, Cham (2017)

    Google Scholar 

  10. Bugiotti, F., Cabibbo, L., Atzeni, P., Torlone, R.: A logical approach to NoSQL databases (2013). http://cabibbo.dia.uniroma3.it/pub/noam.pdf

  11. Bugiotti, F., Cabibbo, L., Atzeni, P., Torlone, R.: Database design for NoSQL systems. In: International Conference on Conceptual Modeling, pp. 223–231. Springer, Cham (2014)

    Chapter  Google Scholar 

  12. Bugiotti, F., Cabibbo, L., Atzeni, P., Torlone, R.: How I learned to stop worrying and love NoSQL databases. In: SEBD Italian Symposium on Advanced Database Systems (2015)‏

  13. Calvaresi, D., Cesarini, D., Sernani, P., Marinoni, M., Dragoni, A.F., Sturm, A.: Exploring the ambient assisted living domain: a systematic review. J. Ambient Intell. Humaniz. Comput. 8(2), 239–257 (2017)

    Article  Google Scholar 

  14. Chebotko, A., Kashlev, A., Lu, S.: A big data modeling methodology for Apache Cassandra. In: 2015 IEEE International Congress on Big Data (BigData Congress), pp. 238–245. IEEE (2015)‏

  15. Comyn-Wattiau, I., Akoka, J.: Model driven reverse engineering of NoSQL property graph databases: the case of Neo4j. In: 2017 IEEE International Conference on Big Data (Big Data), pp. 453–458. IEEE (2017)‏

  16. Daniel, G., Sunyé, G., Cabot, J.: UMLtoGraphDB: mapping conceptual schemas to graph databases. In: International Conference on Conceptual Modeling, pp. 430–444. Springer, Cham (2016)‏

    Chapter  Google Scholar 

  17. De Virgilio, R., Maccioni, A., Torlone, R: Model-driven design of graph databases. In: International Conference on Conceptual Modeling, pp. 172–185. Springer (2014)

  18. Galster, M., Weyns, D., Tofan, D., Michalik, B., Avgeriou, P.: Variability in software systems: a systematic literature review. IEEE Trans. Softw. Eng. 40(3), 282–306 (2014)

    Article  Google Scholar 

  19. Gómez, P., Casallas, R., Roncancio, C.: Data schema does matter, even in NoSQL systems!. In: 2016 IEEE Tenth International Conference on Research Challenges in Information Science (RCIS), pp. 1–6. IEEE (2016)

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

    Google Scholar 

  21. Herrero, V., Abelló, A., Romero, O.: NOSQL design for analytical workloads: variability matters. In: International Conference on Conceptual Modeling, pp. 50–64. Springer, Cham (2016)‏

    Chapter  Google Scholar 

  22. Imam, A.A., Basri, S., Ahmad, R., Aziz, N., Gonzålez-Aparicio, M.T.: New cardinality notations and styles for modeling NoSQL document-store databases. In: Region 10 Conference, TENCON 2017–2017 IEEE, pp. 2765–2770. IEEE (2017)

  23. Jia, T., Zhao, X., Wang, Z., Gong, D., Ding, G.: Model transformation and data migration from relational database to MongoDB. In: 2016 IEEE International Congress on Big Data (BigData Congress), pp. 60–67. IEEE (2016)‏

  24. Kaur, K., Rani, R.: Modeling and querying data in NoSQL databases. In: 2013 IEEE International Conference on Big Data, pp. 1–7 (2013)

  25. Khazaei, H., Fokaefs, M., Zareian, S., Beigi-Mohammadi, N., Shtern, M., Ramprasad, B., Litoiu, M.: How do I choose the right NoSQL solution? A comprehensive theoretical and experimental survey. Big Data Inf. Anal. (BDIA) 2, 1 (2016)

    Google Scholar 

  26. Kitchenham, B.: Procedures for performing systematic reviews. Keele UK Keele Univ. 33(2004), 1–26 (2004)

    Google Scholar 

  27. 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 and Services, p. 115. ACM (2013)

  28. Leavitt, N.: Whatever happened to object-oriented databases? Computer 8, 16–19 (2000)

    Article  Google Scholar 

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

    Article  Google Scholar 

  30. de Lima, C., dos Santos Mello, R.: A workload-driven logical design approach for NoSQL document databases. In: Proceedings of the 17th International Conference on Information Integration and Web-based Applications and Services, p. 73. ACM (2015)‏

  31. Lima, C., Mello, R.S.: On proposing and evaluating a NoSQL document database logical approach. Int. J. Web Inf. Syst. 12(4), 398–417 (2016)

    Article  Google Scholar 

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

  33. Mason, R.T.: NoSQL databases and data modeling techniques for a document-oriented NoSQL database. In: Proceedings of Informing Science and IT Education Conference (InSITE), pp. 259–268 (2015)

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

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

    Article  Google Scholar 

  36. Pokorný, J.: Conceptual and database modelling of graph databases. In: Proceedings of the 20th International Database Engineering and Applications Symposium, pp. 370–377. ACM (2016)

  37. Pokorny, J.: Modelling of graph databases. J. Adv. Eng. Comput. 1(1), 04–17 (2017)

    Article  Google Scholar 

  38. Rossel, G., Manna, A.: A modeling methodology for NoSQL key-value databases. Database Syst. J. 8(2), 12–18 (2017)

    Google Scholar 

  39. Roy-Hubara, N., Rokach, L., Shapira, B., Shoval, P.: Modeling graph database schema. IT Prof. 19(6), 34–43 (2017)

    Article  Google Scholar 

  40. Ruiz, D.S., Morales, S.F., Molina, J.G.: Inferring versioned schemas from NoSQL databases and its applications. In: International Conference on Conceptual Modeling, pp. 467–480. Springer, Cham (2015)‏

  41. Serrano, D., Stroulia, E.: From relations to multi-dimensional maps: a SQL-to-HBase transformation methodology. In Proceedings of the 26th Annual International Conference on Computer Science and Software Engineering, pp. 156–165. IBM Corp. (2016)

  42. Shin, K., Hwang, C., Jung, H.: NoSQL database design using UML conceptual data model based on Peter Chen’s framework. Int. J. Appl. Eng. Res 12(5), 632–636 (2017)

    Google Scholar 

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

  44. Sturm, A., Shehory, O.: A framework for evaluating agent-oriented methodologies. In: Giorgini, P., Henderson-Sellers, B., Winikoff, M. (eds.) Agent-Oriented Information Systems. AOIS 2003. Lecture Notes in Computer Science, vol. 3030. Springer, Berlin (2004)

    Chapter  Google Scholar 

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

  46. Tudorica, B.G., Bucur, C.: A comparison between several NoSQL databases with comments and notes. In: Roedunet 2011 10th International Conference (RoEduNet), pp. 1–5 (2011)

  47. Varga, V., Jánosi-Rancz, K.T., Kálmán, B.: Conceptual design of document NoSQL database with formal concept analysis. Acta Polytech. Hung. 13(2), 229–248 (2016)

    Google Scholar 

  48. Weilkiens, T., Scheithauer, A., Di Maio, M., Klusmann, N.: Evaluating and comparing MBSE methodologies for practitioners. In: 2016 IEEE International Symposium on Systems Engineering (ISSE), Edinburgh, pp. 1–8 (2016)

  49. Yli-Huumo, J., Ko, D., Choi, S., Park, S., Smolander, K.: Where is current research on blockchain technology? A systematic review. PLoS ONE 11(10), e0163477 (2016)

    Article  Google Scholar 

  50. Zečević, I., Bjeljac, P., Perišić, B., Stankovski, S., Venus, D., Ostojić, G.: Model driven development of hybrid databases using lightweight metamodel extensions. Enterp. Inf. Syst. 12, 1–18 (2018)

    Article  Google Scholar 

Download references

Author information

Authors and Affiliations

  1. Ben-Gurion University of the Negev, Beer-Sheva, Israel

    Noa Roy-Hubara & Arnon Sturm

Authors
  1. Noa Roy-Hubara
    View author publications

    You can also search for this author in PubMed Google Scholar

  2. Arnon Sturm
    View author publications

    You can also search for this author in PubMed Google Scholar

Corresponding author

Correspondence to Noa Roy-Hubara.

Additional information

Communicated by Iris Reinhartz-Berger and Sérgio Guerreiro.

Publisher’s Note

Springer Nature remains neutral with regard to jurisdictional claims in published maps and institutional affiliations.

Rights and permissions

Reprints and permissions

About this article

Check for updates. Verify currency and authenticity via CrossMark

Cite this article

Roy-Hubara, N., Sturm, A. Design methods for the new database era: a systematic literature review. Softw Syst Model 19, 297–312 (2020). https://doi.org/10.1007/s10270-019-00739-8

Download citation

  • Received:

  • Revised:

  • Accepted:

  • Published:

  • Issue Date:

  • DOI: https://doi.org/10.1007/s10270-019-00739-8

Keywords

Search

Navigation