Skip to main content
SpringerLink
Log in

Towards Conceptual and Logical Modelling of NoSQL Databases

  • Conference paper
  • First Online:
Advances in Information Systems Development

Part of the book series: Lecture Notes in Information Systems and Organisation ((LNISO,volume 55))

Abstract

NoSQL databases (DB) support the ability to handle large volumes of data in the absence of an explicit data schema. On the other hand, schema information is sometimes essential for applications during data retrieval. Consequently, there are approaches to schema construction, e.g., in the JSON DB and graph DB communities. The difference between a conceptual and database schema is often vague in this case. We use functional constructs—typed attributes for a conceptual view of DB that provide a sufficiently structured approach for expressing semantics of document and graph data. Attribute names are natural language expressions. Such typed functional data objects can be manipulated by terms of a typed λ-calculus, providing powerful nonprocedural query features for considered data structures. The calculus is extendible. Logical, arithmetic operations, and aggregation functions can be included there. Really, conceptual and database modelling merge in this case. The paper focuses on conceptual/database schemas for JSON and graph NoSQL data models.

A prior version of this paper has been published in the ISD2021 Proceedings (http://aisel.aisnet.org/isd2014/proceedings2021).

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 99.00
Price excludes VAT (USA)
  • Available as EPUB and PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book
USD 129.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://redis.io/ (retrieved on 27.1. 2022).

  2. 2.

    https://aws.amazon.com/dynamodb/ (retrieved on 27. 1. 2022).

  3. 3.

    https://www.mongodb.com/ (retrieved on  27. 1. 2022).

  4. 4.

    https://couchdb.apache.org/ (retrieved on 27. 1. 2022).

  5. 5.

    https://hbase.apache.org/ (retrieved on 27. 1. 2022).

  6. 6.

    https://hypertable.org /(retrieved on 27. 1. 2022).

  7. 7.

    https://cassandra.apache.org/ (retrieved on 27. 1. 2022).

  8. 8.

    https://www.vertica.com/overview/ (retrieved on 27. 1. 2022).

  9. 9.

    https://neo4j.com/ (retrieved on 27. 1. 2022).

  10. 10.

    https://searchsqlserver.techtarget.com/definition/OLE-DB (retrieved on 27. 1. 2022)

  11. 11.

    https://docs.oracle.com/javase/7/docs/technotes/guides/jdbc/jdbc_41.html (retrieved on 27. 6. 2022).

  12. 12.

    https://www.arangodb.com/ (retrieved on 27. 1. 2022).

  13. 13.

    http://json-schema.org (retrieved on 27. 1. 2022).

  14. 14.

    https://mongoosejs.com (retrieved on 27. 1. 2022).

  15. 15.

    https://github.com/sideway/joi (retrieved on 27. 1. 2022).

References

  1. Abdelhédi, F., Brahim A.A., Atigui, F., Zurfluh, G.: MDA-based approach for nosql databases modelling. In: Proceedings of International Conference on Big Data Analytics and Knowledge Discovery, DaWAK 2017, LNCS 10440, pp. 88–102 (2017)

    Google Scholar 

  2. Atzeni, P., Bugiotti, F., Cabibbo, C., Torlone, R.: Data modelling in the NoSQL world. Comput. Stand. Interfaces, Elsevier, 67, pp.103–149 (2020)

    Google Scholar 

  3. Baazizi, M.A., Colazzo, D. Ghelli, G., Sartiani, C.: Schemas and types for JSON data: from theory to practice. In: Proceedings of SIGMOD Conference 2019, pp. 2060–2063 (2019)

    Google Scholar 

  4. Chaves, D., Malinowski, E.: Document data modelling: a conceptual perspective. In: Proceedings of ADBIS 2019 Conference, CCIS 1064, pp. 19–27 (2019)

    Google Scholar 

  5. Duzi, M., Pokorny, J.: Semantics of general data structures. In: Charrel, P.J., Jaakkola, H., Kangassalo, H. (eds.) Information modelling and knowledge bases IX, pp. 115–130. IOS Press, Amsterdam, Netherlands (1998)

    Google Scholar 

  6. Gaspar, D., Coric, I.: Bridging Relational and NoSQL Databases. ADMDM Book Series, IGI Global (2017)

    Google Scholar 

  7. Hills, T.: NoSQL and SQL Data Modelling: Bringing Together Data, Semantics, and Software. 1st Edition, Technics Publications (2016)

    Google Scholar 

  8. Hull, R., King, R.: Semantic database modelling: survey, applications and research issues. ACM Comp. Survey 19(3), 201–260 (1987)

    Article  Google Scholar 

  9. Klein, H.K., Hirschheim, R.: A comparative framework of data modelling paradigms and approaches. The Comp. Journ. 30(1), 8–15 (1987)

    Article  Google Scholar 

  10. Laux, F.: The typed graph model. In: Proceedings of DBKDA 2020, pp. 13–19. Lisbon, Portugal (2020)

    Google Scholar 

  11. Lawley, M., Topor, R.: A query language for EER schemas. In: Proceedings of the 5th Australasian Database Conference, ADC ‘94, pp. 292–304. Christchurch, New Zealand (1994)

    Google Scholar 

  12. Materna, P.: Pokorný, J: Applying the simple theory of types to data bases. Inf. Syst. 6(4), 283–300 (1981)

    Article  Google Scholar 

  13. Nečaský, M.: XSEM—a conceptual model for XML. In: Proceedings of Asia Pacific Conference on Conceptual Modelling, pp. 37–48. Ballarat, Australia. CRPIT, 67 (2007)

    Google Scholar 

  14. Pautasso, C., Wilde, E., Alarcon, R.: REST: Advanced Research Topics and Practical Applications, Springer (2014)

    Google Scholar 

  15. Pokorný, J.: A function: unifying mechanism for entity-oriented database models. In: Proceedings of ER 1988 Conference, pp. 165–181 (1988)

    Google Scholar 

  16. Pokorný, J.: Semantic relativism in conceptual modelling. In: Proceedings of DEXA 1993 Conference, pp. 48–55 (1993)

    Google Scholar 

  17. Pokorný, J.: Modelling of graph databases. J. Adv. Eng. Comput. 1(1), 4–15 (2017)

    Article  Google Scholar 

  18. Pokorný, J.: Integration of relational and NoSQL databases. Vietnam J. Comput. Sci. 6(4), 389–405 (2019)

    Article  Google Scholar 

  19. Pokorný, J.: Integration of relational and graph databases functionally. Found. Comput. Decis. Sci. 44(4), 427–441 (2019)

    Article  Google Scholar 

  20. Pokorný, J.: JSON functionally. In: Proceedings of ADBIS 2020 Conference, LNCS 12245, pp. 139–153. Springer Nature Switzerland AG, Cham (2020)

    Google Scholar 

  21. Roy‑Hubara, N., Sturm, A.: Design methods for the new database era: a systematic literature review. Softw. Syst. Model. 19, 297–312 (2020)

    Google Scholar 

  22. Shin, K., Hwang, Ch., 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 

Download references

Acknowledgements

This work was supported by the Charles University project Q48.

Author information

Authors and Affiliations

  1. Charles University, Faculty of Mathematics and Physics, Prague, Czech Republic

    Jaroslav Pokorný

  2. University College of Polytechnics, Jihlava, Czech Republic

    Karel Richta

Authors
  1. Jaroslav Pokorný
    View author publications

    You can also search for this author in PubMed Google Scholar

  2. Karel Richta
    View author publications

    You can also search for this author in PubMed Google Scholar

Corresponding author

Correspondence to Jaroslav Pokorný .

Editor information

Editors and Affiliations

  1. Department of Computer Systems and Computation, Universitat Politècnica de València, Valencia, Spain

    Emilio Insfran

  2. Department of Business and Economics, Universitat Politècnica de València, Valencia, Spain

    Fernando González

  3. Department of Computer Systems and Computation, Universitat Politècnica de València, Valencia, Spain

    Silvia Abrahão

  4. Department of Business and Economics, Universitat Politècnica de València, Valencia, Spain

    Marta Fernández

  5. Cairnes School of Business & Economics, National University of Ireland Galway, Galway, Ireland

    Chris Barry

  6. Cairnes School of Business & Economics, National University of Ireland Galway, Galway, Ireland

    Michael Lang

  7. Faculty of Information Technology, Monash University, Melbourne, VIC, Australia

    Henry Linger

  8. IESE Business School, University of Navarra, Barcelona, Spain

    Christoph Schneider

Rights and permissions

Reprints and permissions

Copyright information

© 2022 The Author(s), under exclusive license to Springer Nature Switzerland AG

About this paper

Check for updates. Verify currency and authenticity via CrossMark

Cite this paper

Pokorný, J., Richta, K. (2022). Towards Conceptual and Logical Modelling of NoSQL Databases. In: Insfran, E., et al. Advances in Information Systems Development. Lecture Notes in Information Systems and Organisation, vol 55. Springer, Cham. https://doi.org/10.1007/978-3-030-95354-6_15

Download citation

  • DOI: https://doi.org/10.1007/978-3-030-95354-6_15

  • Published:

  • Publisher Name: Springer, Cham

  • Print ISBN: 978-3-030-95353-9

  • Online ISBN: 978-3-030-95354-6

  • eBook Packages: Computer ScienceComputer Science (R0)

Publish with us

Policies and ethics

Search

Navigation