Skip to main content
SpringerLink
Log in

Exploring the Design Needs for the New Database Era

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

Part of the book series: Lecture Notes in Business Information Processing ((LNBIP,volume 318))

  • 2081 Accesses

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.

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

    http://www.faculty.rsu.edu/users/c/clayton/www/waide/paper.htm#_Toc38521773.

  3. 3.

    https://www.veracode.com/blog/2012/05/what-is-data-integrity.

  4. 4.

    http://www.25hoursaday.com/WhyArentYouUsingAnOODBMS.html.

  5. 5.

    https://softwareengineering.stackexchange.com/questions/178119/why-arent-object-oriented-databases-used-as-much-as-relational-databases/178124#answer-178124.

  6. 6.

    http://dataconomy.com/2015/08/sql-vs-nosql-vs-newsql-finding-the-right-solution/.

  7. 7.

    http://www.odbms.org/wp-content/uploads/2013/11/Tutorial.Cattell.2009.pdf.

  8. 8.

    https://stackoverflow.com/questions/1100819/how-do-you-design-object-oriented-projects.

  9. 9.

    https://www.datasciencecentral.com/profiles/blogs/newsql-rdbms-on-steroids.

References

  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_6

    Chapter  Google Scholar 

  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 2012

    Google Scholar 

  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)

    Article  Google Scholar 

  4. Badia, A., Lemire, D.: A call to arms: revisiting database design. ACM SIGMOD Rec. 40(3), 61–69 (2011)

    Article  Google Scholar 

  5. Berg, K.L., Seymour, T., Goel, R.: History of databases. Int. J. Manag. Inf. Syst. 17(1), 29 (2013)

    Google Scholar 

  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_20

    Chapter  Google Scholar 

  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_18

    Chapter  Google Scholar 

  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 2015

    Google Scholar 

  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_33

    Chapter  Google Scholar 

  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 2015

    Google Scholar 

  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_14

    Chapter  Google Scholar 

  12. Design, S.: Relational Database Design (1995)

    Google Scholar 

  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_1

    Chapter  Google Scholar 

  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)

    Article  Google Scholar 

  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 2016

    Google Scholar 

  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 2011

    Google Scholar 

  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. Holland, I.M., Lieberherr, K.J.: Object-oriented design. ACM Comput. Surv. (CSUR) 28(1), 273–275 (1996)

    Article  Google Scholar 

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

    Google Scholar 

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

    Google Scholar 

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

    Book  Google Scholar 

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

    Article  Google Scholar 

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

    Article  Google Scholar 

  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)

    Article  Google Scholar 

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

  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_14

    Chapter  Google Scholar 

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

    Article  Google Scholar 

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

    Google Scholar 

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

    Article  Google Scholar 

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

  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 2016

    Google Scholar 

  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 2011

    Google Scholar 

  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. Wesley, D.: Relational database design. J. Insur. Med. NY 32(2), 63–70 (2000)

    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 .

Editor information

Editors and Affiliations

  1. University of Duisburg-Essen, Essen, Germany

    Jens Gulden

  2. University of Haifa, Haifa, Israel

    Iris Reinhartz-Berger

  3. Munich University of Applied Sciences, Munich, Germany

    Rainer Schmidt

  4. INESC-ID, University of Lisbon, Lisbon, Portugal

    Sérgio Guerreiro

  5. Luxembourg Institute of Science and Technology, Esch-sur-Alzette, Luxembourg

    Wided Guédria

  6. Saint Louis University, St. Louis, Missouri, USA

    Palash Bera

Rights and permissions

Reprints and permissions

Copyright information

© 2018 Springer International Publishing AG, part of Springer Nature

About this paper

Check for updates. Verify currency and authenticity via CrossMark

Cite this paper

Roy-Hubara, N., Sturm, A. (2018). Exploring the Design Needs for the New Database Era. In: Gulden, J., Reinhartz-Berger, I., Schmidt, R., Guerreiro, S., Guédria, W., Bera, P. (eds) Enterprise, Business-Process and Information Systems Modeling. BPMDS EMMSAD 2018 2018. Lecture Notes in Business Information Processing, vol 318. Springer, Cham. https://doi.org/10.1007/978-3-319-91704-7_18

Download citation

  • DOI: https://doi.org/10.1007/978-3-319-91704-7_18

  • Published:

  • Publisher Name: Springer, Cham

  • Print ISBN: 978-3-319-91703-0

  • Online ISBN: 978-3-319-91704-7

  • eBook Packages: Computer ScienceComputer Science (R0)

Publish with us

Policies and ethics

Search

Navigation