Skip to main content
Springer Nature Link
Log in

Conceptual Modeling of Hybrid Polystores

  • Conference paper
  • First Online:
Conceptual Modeling (ER 2021)

Part of the book series: Lecture Notes in Computer Science ((LNISA,volume 13011))

Included in the following conference series:

Abstract

An increasing number of organisations rely on NoSQL technologies to manage their mission-critical data. However, those technologies were not intended to replace relational database management systems, but rather to complement them. Hence the recent emergence of heterogeneous database architectures, commonly called hybrid polystores, that rely on a combination of several, possibly overlapping relational and NoSQL databases. Unfortunately, there is still a lack of models, methods and tools for data modeling and manipulation in such architectures. With the aim to fill this gap, we introduce HyDRa, a conceptual framework to design and manipulate hybrid polystores. We present the HyDRa textual modeling language allowing one to specify (1) the conceptual schema of a polystore, (2) the physical schemas of each of its databases, and (3) a set of mapping rules to express possibly complex correspondences between the conceptual schema elements and the physical databases.

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

Access this chapter

Log in via an institution

Subscribe and save

Springer+ Basic
$34.99 /Month
  • Get 10 units per month
  • Download Article/Chapter or eBook
  • 1 Unit = 1 Article or 1 Chapter
  • Cancel anytime
Subscribe now

Buy Now

Chapter
USD 29.95
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever

Tax calculation will be finalised at checkout

Purchases are for personal use only

Institutional subscriptions

Similar content being viewed by others

Notes

  1. 1.

    https://www.imdb.com/interfaces/.

References

  1. 6 rules of thumb for MongoDB schema design. https://bit.ly/3gYTh8y

  2. Cassandra data modeling best practices. https://bit.ly/3eeYGGY

  3. Hbase schema case study. https://bit.ly/3nX52y5

  4. Spring data Redis - Retwis-J. https://bit.ly/33hEFcg

  5. Atzeni, P., Bugiotti, F., Cabibbo, L., Torlone, R.: Data modeling in the NoSQL world. Comput. Stand. Interfaces 67, 103149 (2020)

    Article  Google Scholar 

  6. Atzeni, P., Bugiotti, F., Rossi, L.: Uniform access to non-relational database systems: the SOS platform. In: Ralyté, J., Franch, X., Brinkkemper, S., Wrycza, S. (eds.) CAiSE 2012. LNCS, vol. 7328, pp. 160–174. Springer, Heidelberg (2012). https://doi.org/10.1007/978-3-642-31095-9_11

    Chapter  Google Scholar 

  7. Basciani, F., Di Rocco, J., Di Ruscio, D., Pierantonio, A., Iovino, L.: TyphonML: a modeling environment to develop hybrid polystores. In: MoDELS (2020)

    Google Scholar 

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

    Article  Google Scholar 

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

  10. Cabibbo, L.: ONDM: an object-NoSQL datastore mapper. Faculty of Engineering, Roma Tre University (2013)

    Google Scholar 

  11. Carlo, B., Ceri, S., Sham, N.: Conceptual Database Design: An Entity-Relationship Approach. Benjamin/Cummings, Redwood City (1992)

    MATH  Google Scholar 

  12. Duggan, J., et al.: The BigDAWG polystore system. ACM SIGMOD Rec. 44(2), 11–16 (2015)

    Article  Google Scholar 

  13. Fink, J., Gobert, M., Cleve, A.: Adapting queries to database schema changes in hybrid polystores. In: IEEE SCAM, pp. 127–131 (2020)

    Google Scholar 

  14. Gobert, M.: Schema evolution in hybrid database systems. In: VLDB PhD Workshop (2020)

    Google Scholar 

  15. Gobert, M.: HyDRa repository (2021). https://github.com/gobertm/HyDRa

  16. Hecht, R., Jablonski, S.: NoSQL evaluation: a use case oriented survey. In: 2011 International Conference on Cloud and Service Computing, pp. 336–341 (2011)

    Google Scholar 

  17. Herrero, V., Abelló, A., Romero, O.: NOSQL design for analytical workloads: variability matters. In: Comyn-Wattiau, I., Tanaka, K., Song, I.-Y., Yamamoto, S., Saeki, M. (eds.) ER 2016. LNCS, vol. 9974, pp. 50–64. Springer, Cham (2016). https://doi.org/10.1007/978-3-319-46397-1_4

    Chapter  Google Scholar 

  18. de Lima, C., dos Santos Mello, R.: A workload-driven logical design approach for NoSQL document databases. In: iiWAS, pp. 1–10 (2015)

    Google Scholar 

  19. Neo4j: Modeling designs. https://neo4j.com/developer/modeling-designs/

  20. Pokornỳ, J.: Conceptual and database modelling of graph databases. In: IDEAS 2016 (2016)

    Google Scholar 

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

    Google Scholar 

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

    Article  Google Scholar 

  23. Sadalage, P.J., Fowler, M.: NoSQL Distilled: A Brief Guide to the Emerging World of Polyglot Persistence. Pearson Education, Upper Saddle River (2013)

    Google Scholar 

  24. Schaarschmidt, M., Gessert, F., Ritter, N.: Towards automated polyglot persistence. Datenbanksysteme für Business, Technologie und Web (BTW 2015) (2015)

    Google Scholar 

Download references

Acknowledgements

This research is supported by the F.R.S.-FNRS and FWO via the EOS project 30446992 SECO-ASSIST.

Author information

Authors and Affiliations

  1. Namur Digital Institute, University of Namur, Namur, Belgium

    Maxime Gobert, Loup Meurice & Anthony Cleve

Authors
  1. Maxime Gobert
    View author publications

    You can also search for this author in PubMed Google Scholar

  2. Loup Meurice
    View author publications

    You can also search for this author in PubMed Google Scholar

  3. Anthony Cleve
    View author publications

    You can also search for this author in PubMed Google Scholar

Corresponding author

Correspondence to Maxime Gobert .

Editor information

Editors and Affiliations

  1. School of Computing and IT, University of Wollongong, Wollongong, NSW, Australia

    Aditya Ghose

  2. Department of Computer Science and Engineering, Chalmers | University of Gothenburg, Gothenburg, Sweden

    Jennifer Horkoff

  3. Universidade Federal do Espírito Santo, Vitória, Brazil

    Vítor E. Silva Souza

  4. Faculty of Business Administration, Memorial University of Newfoundland, St. John's, NL, Canada

    Jeffrey Parsons

  5. Faculty of Business Administration, Memorial University of Newfoundland, St. John's, NL, Canada

    Joerg Evermann

Rights and permissions

Reprints and permissions

Copyright information

© 2021 Springer Nature Switzerland AG

About this paper

Check for updates. Verify currency and authenticity via CrossMark

Cite this paper

Gobert, M., Meurice, L., Cleve, A. (2021). Conceptual Modeling of Hybrid Polystores. In: Ghose, A., Horkoff, J., Silva Souza, V.E., Parsons, J., Evermann, J. (eds) Conceptual Modeling. ER 2021. Lecture Notes in Computer Science(), vol 13011. Springer, Cham. https://doi.org/10.1007/978-3-030-89022-3_10

Download citation

  • DOI: https://doi.org/10.1007/978-3-030-89022-3_10

  • Published:

  • Publisher Name: Springer, Cham

  • Print ISBN: 978-3-030-89021-6

  • Online ISBN: 978-3-030-89022-3

  • eBook Packages: Computer ScienceComputer Science (R0)

Publish with us

Policies and ethics