Skip to main content
Top
Published in: Software and Systems Modeling 2/2020

27-06-2019 | Special Section Paper

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

Authors: Noa Roy-Hubara, Arnon Sturm

Published in: Software and Systems Modeling | Issue 2/2020

Log in

Activate our intelligent search to find suitable subject content or patents.

search-config
loading …

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.

Dont have a licence yet? Then find out more about our products and how to get one now:

Springer Professional "Wirtschaft+Technik"

Online-Abonnement

Mit Springer Professional "Wirtschaft+Technik" erhalten Sie Zugriff auf:

  • über 102.000 Bücher
  • über 537 Zeitschriften

aus folgenden Fachgebieten:

  • Automobil + Motoren
  • Bauwesen + Immobilien
  • Business IT + Informatik
  • Elektrotechnik + Elektronik
  • Energie + Nachhaltigkeit
  • Finance + Banking
  • Management + Führung
  • Marketing + Vertrieb
  • Maschinenbau + Werkstoffe
  • Versicherung + Risiko

Jetzt Wissensvorsprung sichern!

Springer Professional "Wirtschaft"

Online-Abonnement

Mit Springer Professional "Wirtschaft" erhalten Sie Zugriff auf:

  • über 67.000 Bücher
  • über 340 Zeitschriften

aus folgenden Fachgebieten:

  • Bauwesen + Immobilien
  • Business IT + Informatik
  • Finance + Banking
  • Management + Führung
  • Marketing + Vertrieb
  • Versicherung + Risiko




Jetzt Wissensvorsprung sichern!

Springer Professional "Technik"

Online-Abonnement

Mit Springer Professional "Technik" erhalten Sie Zugriff auf:

  • über 67.000 Bücher
  • über 390 Zeitschriften

aus folgenden Fachgebieten:

  • Automobil + Motoren
  • Bauwesen + Immobilien
  • Business IT + Informatik
  • Elektrotechnik + Elektronik
  • Energie + Nachhaltigkeit
  • Maschinenbau + Werkstoffe




 

Jetzt Wissensvorsprung sichern!

Literature
1.
go back to reference Akoka, J., Comyn-Wattiau, I.: Roundtrip engineering of NoSQL databases. Enterp. Model. Inf. Syst. Archit. 13, 281–292 (2018) Akoka, J., Comyn-Wattiau, I.: Roundtrip engineering of NoSQL databases. Enterp. Model. Inf. Syst. Archit. 13, 281–292 (2018)
2.
go back to reference 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) 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)
3.
go back to reference Atzeni, P., Bugiotti, F., Cabibbo, L., Torlone, R.: Data modeling in the NoSQL world. In: Computer Standards and Interfaces (2016)‏ Atzeni, P., Bugiotti, F., Cabibbo, L., Torlone, R.: Data modeling in the NoSQL world. In: Computer Standards and Interfaces (2016)‏
4.
go back to reference 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)CrossRef 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)CrossRef
5.
go back to reference Banerjee, S., Sarkar, A.: Logical level design of NoSQL databases. In: Region 10 Conference (TENCON), 2016 IEEE, pp. 2360–2365. IEEE (2016) Banerjee, S., Sarkar, A.: Logical level design of NoSQL databases. In: Region 10 Conference (TENCON), 2016 IEEE, pp. 2360–2365. IEEE (2016)
6.
go back to reference 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)‏ 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.
go back to reference 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) CrossRef 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) CrossRef
8.
go back to reference Bjeladinovic, S.: A fresh approach for hybrid SQL/NoSQL database design based on data structuredness. Enterp. Inf. Syst. 12, 1–19 (2018)CrossRef Bjeladinovic, S.: A fresh approach for hybrid SQL/NoSQL database design based on data structuredness. Enterp. Inf. Syst. 12, 1–19 (2018)CrossRef
9.
go back to reference 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) 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)
11.
go back to reference 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)CrossRef 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)CrossRef
12.
go back to reference 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)‏ 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.
go back to reference 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)CrossRef 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)CrossRef
14.
go back to reference 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)‏ 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.
go back to reference 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)‏ 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.
go back to reference 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)‏CrossRef 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)‏CrossRef
17.
go back to reference De Virgilio, R., Maccioni, A., Torlone, R: Model-driven design of graph databases. In: International Conference on Conceptual Modeling, pp. 172–185. Springer (2014) 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.
go back to reference 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)CrossRef 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)CrossRef
19.
go back to reference 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) 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.
go back to reference Haseeb, A., Pattun, G.: A review on NoSQL: applications and challenges. Int. J. Adv. Res. Comput. Sci. 8(1), 203–207 (2017) Haseeb, A., Pattun, G.: A review on NoSQL: applications and challenges. Int. J. Adv. Res. Comput. Sci. 8(1), 203–207 (2017)
21.
go back to reference 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)‏CrossRef 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)‏CrossRef
22.
go back to reference 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) 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.
go back to reference 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)‏ 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.
go back to reference Kaur, K., Rani, R.: Modeling and querying data in NoSQL databases. In: 2013 IEEE International Conference on Big Data, pp. 1–7 (2013) Kaur, K., Rani, R.: Modeling and querying data in NoSQL databases. In: 2013 IEEE International Conference on Big Data, pp. 1–7 (2013)
25.
go back to reference 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) 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)
26.
go back to reference Kitchenham, B.: Procedures for performing systematic reviews. Keele UK Keele Univ. 33(2004), 1–26 (2004) Kitchenham, B.: Procedures for performing systematic reviews. Keele UK Keele Univ. 33(2004), 1–26 (2004)
27.
go back to reference 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) 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.
go back to reference Leavitt, N.: Whatever happened to object-oriented databases? Computer 8, 16–19 (2000)CrossRef Leavitt, N.: Whatever happened to object-oriented databases? Computer 8, 16–19 (2000)CrossRef
29.
go back to reference Leavitt, N.: Will NoSQL databases live up to their promise? Computer 43(2), 12–14 (2010)CrossRef Leavitt, N.: Will NoSQL databases live up to their promise? Computer 43(2), 12–14 (2010)CrossRef
30.
go back to reference 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)‏ 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.
go back to reference 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)CrossRef 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)CrossRef
32.
go back to reference 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)CrossRef 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)CrossRef
33.
go back to reference 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) 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.
go back to reference 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)CrossRef 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)CrossRef
35.
go back to reference Pavlo, A., Aslett, M.: What’s really new with NewSQL? ACM Sigmod Rec. 45(2), 45–55 (2016)CrossRef Pavlo, A., Aslett, M.: What’s really new with NewSQL? ACM Sigmod Rec. 45(2), 45–55 (2016)CrossRef
36.
go back to reference 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) 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.
go back to reference Pokorny, J.: Modelling of graph databases. J. Adv. Eng. Comput. 1(1), 04–17 (2017)CrossRef Pokorny, J.: Modelling of graph databases. J. Adv. Eng. Comput. 1(1), 04–17 (2017)CrossRef
38.
go back to reference Rossel, G., Manna, A.: A modeling methodology for NoSQL key-value databases. Database Syst. J. 8(2), 12–18 (2017) Rossel, G., Manna, A.: A modeling methodology for NoSQL key-value databases. Database Syst. J. 8(2), 12–18 (2017)
39.
go back to reference Roy-Hubara, N., Rokach, L., Shapira, B., Shoval, P.: Modeling graph database schema. IT Prof. 19(6), 34–43 (2017)CrossRef Roy-Hubara, N., Rokach, L., Shapira, B., Shoval, P.: Modeling graph database schema. IT Prof. 19(6), 34–43 (2017)CrossRef
40.
go back to reference 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)‏ 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.
go back to reference 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) 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.
go back to reference 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) 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)
43.
go back to reference Storey, V.C., Song, I.Y.: Big data technologies and management: what conceptual modeling can do. Data Knowl. Eng. 108, 50–67 (2017)CrossRef Storey, V.C., Song, I.Y.: Big data technologies and management: what conceptual modeling can do. Data Knowl. Eng. 108, 50–67 (2017)CrossRef
44.
go back to reference 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)CrossRef 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)CrossRef
45.
go back to reference 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 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.
go back to reference 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) 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.
go back to reference 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) 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)
48.
go back to reference 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) 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.
go back to reference 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)CrossRef 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)CrossRef
50.
go back to reference 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)CrossRef 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)CrossRef
Metadata
Title
Design methods for the new database era: a systematic literature review
Authors
Noa Roy-Hubara
Arnon Sturm
Publication date
27-06-2019
Publisher
Springer Berlin Heidelberg
Published in
Software and Systems Modeling / Issue 2/2020
Print ISSN: 1619-1366
Electronic ISSN: 1619-1374
DOI
https://doi.org/10.1007/s10270-019-00739-8

Other articles of this Issue 2/2020

Software and Systems Modeling 2/2020 Go to the issue

Premium Partner