Advertisement

Abstract

During the last decade, new database solutions and technologies have emerged. These were developed in order to facilitate the new types of applications and requirements. However, these new improvements also affected the desired properties existing in traditional databases (i.e., relational). Thus, there is a need to better understand the tradeoffs among the various solutions and to support such analysis with design and modeling techniques. In this paper, we review database design approaches and explore the requirements for these.

Keywords

Modeling Design Database 

References

  1. 1.
    Akoka, J., Comyn-Wattiau, I., Prat, N.: A four V’s design approach of NoSQL graph databases. In: de Cesare, S., Frank, U. (eds.) ER 2017. LNCS, vol. 10651, pp. 58–68. Springer, Cham (2017).  https://doi.org/10.1007/978-3-319-70625-2_6CrossRefGoogle Scholar
  2. 2.
    Angles, R.: A comparison of current graph database models. In: 2012 IEEE 28th International Conference on Data Engineering Workshops (ICDEW), pp. 171–177, April 2012Google Scholar
  3. 3.
    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)CrossRefGoogle Scholar
  4. 4.
    Badia, A., Lemire, D.: A call to arms: revisiting database design. ACM SIGMOD Rec. 40(3), 61–69 (2011)CrossRefGoogle Scholar
  5. 5.
    Berg, K.L., Seymour, T., Goel, R.: History of databases. Int. J. Manag. Inf. Syst. 17(1), 29 (2013)Google Scholar
  6. 6.
    Boussahoua, M., Boussaid, O., Bentayeb, F.: Logical schema for data warehouse on column-oriented NoSQL databases. In: Benslimane, D., Damiani, E., Grosky, W.I., Hameurlain, A., Sheth, A., Wagner, R.R. (eds.) DEXA 2017. LNCS, vol. 10439, pp. 247–256. Springer, Cham (2017).  https://doi.org/10.1007/978-3-319-64471-4_20CrossRefGoogle Scholar
  7. 7.
    Bugiotti, F., Cabibbo, L., Atzeni, P., Torlone, R.: Database design for NoSQL systems. In: Yu, E., Dobbie, G., Jarke, M., Purao, S. (eds.) ER 2014. LNCS, vol. 8824, pp. 223–231. Springer, Cham (2014).  https://doi.org/10.1007/978-3-319-12206-9_18CrossRefGoogle Scholar
  8. 8.
    Chebotko, A., Kashlev, A., Lu, S.: A big data modeling methodology for Apache Cassandra. In: IEEE International Congress on Big Data, pp. 238–245, June 2015Google Scholar
  9. 9.
    Daniel, G., Sunyé, G., Cabot, J.: UMLtoGraphDB: mapping conceptual schemas to graph databases. In: Comyn-Wattiau, I., Tanaka, K., Song, I.-Y., Yamamoto, S., Saeki, M. (eds.) ER 2016. LNCS, vol. 9974, pp. 430–444. Springer, Cham (2016).  https://doi.org/10.1007/978-3-319-46397-1_33CrossRefGoogle Scholar
  10. 10.
    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, December 2015Google Scholar
  11. 11.
    De Virgilio, R., Maccioni, A., Torlone, R.: Model-driven design of graph databases. In: Yu, E., Dobbie, G., Jarke, M., Purao, S. (eds.) ER 2014. LNCS, vol. 8824, pp. 172–185. Springer, Cham (2014).  https://doi.org/10.1007/978-3-319-12206-9_14CrossRefGoogle Scholar
  12. 12.
    Design, S.: Relational Database Design (1995)Google Scholar
  13. 13.
    Embley, D.W., Liddle, S.W.: Big Data—conceptual modeling to the rescue. In: Ng, W., Storey, Veda C., Trujillo, J.C. (eds.) ER 2013. LNCS, vol. 8217, pp. 1–8. Springer, Heidelberg (2013).  https://doi.org/10.1007/978-3-642-41924-9_1CrossRefGoogle Scholar
  14. 14.
    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)CrossRefGoogle Scholar
  15. 15.
    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, June 2016Google Scholar
  16. 16.
    Han, J., Haihong, E., Le, G., Du, J.: Survey on NoSQL database. In: 2011 6th International Conference on Pervasive Computing and Applications (ICPCA), pp. 363–366. IEEE, October 2011Google Scholar
  17. 17.
    Haseeb, A., Pattun, G.: A review on NoSQL: applications and challenges. Int. J. Adv. Res. Comput. Sci. 8(1), 203–207 (2017)Google Scholar
  18. 18.
    Holland, I.M., Lieberherr, K.J.: Object-oriented design. ACM Comput. Surv. (CSUR) 28(1), 273–275 (1996)CrossRefGoogle Scholar
  19. 19.
    Kaur, K., Rani, R.: Modeling and querying data in NoSQL databases. In: IEEE International Conference on Big Data, pp. 1–7, October 2013Google Scholar
  20. 20.
    Khazaei, H., Fokaefs, M., Zareian, S., Beigi-Mohammadi, N., Ramprasad, B., Shtern, M., 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
  21. 21.
    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, December 2013Google Scholar
  22. 22.
    Lake, P., Crowther, P.: Concise Guide to Databases. Undergraduate Topics in Computer Science. Springer, London (2013).  https://doi.org/10.1007/978-1-4471-5601-7CrossRefGoogle Scholar
  23. 23.
    Leavitt, N.: Whatever happened to object-oriented databases? Computer 8, 16–19 (2000)CrossRefGoogle Scholar
  24. 24.
    Leavitt, N.: Will NoSQL databases live up to their promise? Computer 43(2), 12–14 (2010)CrossRefGoogle Scholar
  25. 25.
    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)CrossRefGoogle Scholar
  26. 26.
    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)Google Scholar
  27. 27.
    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)CrossRefGoogle Scholar
  28. 28.
    Ou, Y.: On using UML class diagrams for object-oriented database design. In: Bézivin, J., Muller, P.-A. (eds.) UML 1998. LNCS, vol. 1618, pp. 173–188. Springer, Heidelberg (1999).  https://doi.org/10.1007/978-3-540-48480-6_14CrossRefGoogle Scholar
  29. 29.
    Pavlo, A., Aslett, M.: What’s really new with NewSQL? ACM SIGMOD Rec. 45(2), 45–55 (2016)CrossRefGoogle Scholar
  30. 30.
    Rossel, G., Manna, A.: A modeling methodology for NoSQL key-value databases. Database Syst. J. 8(2), 12–18 (2017)Google Scholar
  31. 31.
    Roy-Hubara, N., Rokach, L., Shapira, B., Shoval, P.: Modeling graph database schema. IT Prof. 6, 34–43 (2017)CrossRefGoogle Scholar
  32. 32.
    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
  33. 33.
    Storey, V.C., Song, I.Y.: Big data technologies and Management: what conceptual modeling can do. Data Knowl. Eng. 108, 50–67 (2017)CrossRefGoogle Scholar
  34. 34.
    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, November 2016Google Scholar
  35. 35.
    Tudorica, B.G., Bucur, C.: A comparison between several NoSQL databases with comments and notes. In: 2011 10th Roedunet International Conference (RoEduNet), pp. 1–5, June 2011Google Scholar
  36. 36.
    Vera, H., Wagner Boaventura, M.H., Guimaraes, V., Hondo, F.: Data modeling for NoSQL document-oriented databases. In: CEUR Workshop Proceedings, vol. 1478, pp. 129–135 (2015)Google Scholar
  37. 37.
    Wesley, D.: Relational database design. J. Insur. Med. NY 32(2), 63–70 (2000)Google Scholar

Copyright information

© Springer International Publishing AG, part of Springer Nature 2018

Authors and Affiliations

  1. 1.Ben-Gurion University of the NegevBeer ShevaIsrael

Personalised recommendations