Skip to main content
SpringerLink
Log in

Towards Automatic Conceptual Database Design Based on Heterogeneous Source Artifacts

  • Conference paper
  • First Online:
New Trends in Database and Information Systems (ADBIS 2023)

Part of the book series: Communications in Computer and Information Science ((CCIS,volume 1850))

Included in the following conference series:

Abstract

The paper presents an early prototype of the tool named DBomnia – the first online web-based tool enabling automatic derivation of conceptual database models from heterogeneous source artifacts (business process models and textual specifications). DBomnia employs other pre-existing tools to derive conceptual models from sources of the same type and then integrates those models, whereby the main challenge is related to the integration of conceptual models that are automatically generated and can be considered unreliable. The initial results show that the implemented tool derives models that are more precise and complete compared to the models derived from sources of the same type.

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 84.99
Price excludes VAT (USA)
  • Available as EPUB and PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book
USD 109.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.

    http://m-lab.etf.unibl.org:8080/amadeos.

  2. 2.

    http://m-lab.etf.unibl.org:8080/Textodata.

  3. 3.

    http://m-lab.etf.unibl.org:8080/dbomnia.

  4. 4.

    Implementation is based on the jsUML2 library (http://www.jrromero.net/tool_jsUML2.html).

References

  1. Batini, C., Lenzerini, M.: A methodology for data schema integration in the entity-relationship model. IEEE Trans. Softw. Eng. SE-10(6), 650–664 (1984)

    Google Scholar 

  2. Batini, C., Lenzerini, M., Navathe, S.B.: A comparative analysis of methodologies for database schema integration. ACM Comput. Surv. 18(4), 323–364 (1986)

    Article  Google Scholar 

  3. Bernstein, P., Madhavan, J., Rahm, E.: Generic schema matching, ten years later. Proc. VLDB Endow. 4(11), 695–701 (2011)

    Article  Google Scholar 

  4. Bernstein, P.A., Halevy, A.Y., Pottinger, R.A.: A vision for management of complex models 29(4), 55–63 (2000)

    Google Scholar 

  5. Brdjanin, D., Maric, S.: An approach to automated conceptual database design based on the UML activity diagram. Comput. Sci. Inf. Syst. 9(1), 249–283 (2012)

    Article  Google Scholar 

  6. Brdjanin, D., Maric, S.: Model-driven techniques for data model synthesis. Electronics 17(2), 130–136 (2013)

    Google Scholar 

  7. Brdjanin, D., Banjac, G., Banjac, D., Maric, S.: An experiment in model-driven conceptual database design. Softw. Syst. Model. 18(3), 1859–1883 (2019)

    Article  Google Scholar 

  8. Brdjanin, D., Vukotic, A., Banjac, D., Banjac, G., Maric, S.: Automatic derivation of the initial conceptual database model from a set of business process models. Comput. Sci. Inf. Syst. 19(1), 455–493 (2022)

    Article  Google Scholar 

  9. Brdjanin, D., Banjac, G., Babic, N., Golubovic, N.: Towards the speech-driven database design. In: Proceedings of TELFOR 2022, pp. 1–4. IEEE (2022)

    Google Scholar 

  10. Brdjanin, D., et al.: Towards an online multilingual tool for automated conceptual database design. In: Braubach, L., et al. (eds.) Intelligent Distributed Computing XV, vol. 1089, pp. 144–153. Springer, Cham (2023). https://doi.org/10.1007/978-3-031-29104-3_16

  11. Chen, P.: English sentence structure and entity-relationship diagrams. Inf. Sci. 29(2–3), 127–149 (1983)

    Article  Google Scholar 

  12. Choobineh, J., Mannino, M., Nunamaker, J., Konsynsky, B.: An expert database design system based on analysis of forms. IEEE Trans. Softw. Eng. 14(2), 242–253 (1988)

    Article  Google Scholar 

  13. Choobineh, J., Lo, A.W.: CABSYDD: Case-based system for database design. J. Manage. Inf. Syst. 21(3), 281–314 (2004)

    Article  Google Scholar 

  14. Date, C.: An Introduction to Database Systems, 8th edn. Addison-Wesley, Boston (2003)

    Google Scholar 

  15. Harmain, H., Gaizauskas, R.: CM-builder: a natural language-based CASE tool for object-oriented analysis. Autom. Softw. Eng. 10(2), 157–181 (2003)

    Article  Google Scholar 

  16. Hartmann, S., Link, S.: English sentence structures and EER modeling. In: Proceedings of the 4th Asia-Pacific Conference on Conceptual Modelling, vol. 67, pp. 27–35 (2007)

    Google Scholar 

  17. Jouault, F., Allilaire, F., Bezivin, J., Kurtev, I.: ATL: a model transformation tool. Sci. Comput. Program. 72(1–2), 31–39 (2008)

    Article  MathSciNet  MATH  Google Scholar 

  18. Kriouile, A., Addamssiri, N., Gadi, T.: An MDA method for automatic transformation of models from CIM to PIM. Am. J. Softw. Eng. Appl. 4(1), 1–14 (2015)

    Google Scholar 

  19. Lukovic, I., Mogin, P., Pavicevic, J., Ristic, S.: An approach to developing complex database schemas using form types. Softw. Pract. Exp. 37(15), 1621–1656 (2007)

    Google Scholar 

  20. Madhavan, J., Bernstein, P., Rahm, E.: Generic schema matching with cupid. In: Proceedings of VLDB 2001, pp. 49–58. Morgan Kaufmann (2001)

    Google Scholar 

  21. Magnani, M., Rizopoulos, N., Mc.Brien, P., Montesi, D.: Schema integration based on uncertain semantic mappings. In: Delcambre, L., Kop, C., Mayr, H.C., Mylopoulos, J., Pastor, O. (eds.) ER 2005. LNCS, vol. 3716, pp. 31–46. Springer, Heidelberg (2005). https://doi.org/10.1007/11568322_3

    Chapter  Google Scholar 

  22. Navathe, S., Gadgil, S.: A methodology for view integration in logical database design. In: Eigth International Conference on Very Large Data Bases, pp. 142–164. Morgan Kaufmann (1982)

    Google Scholar 

  23. Nikiforova, O., Gusarovs, K., Gorbiks, O., Pavlova, N.: BrainTool: a tool for generation of the UML class diagrams. In: Proceedings of ICSEA 2012, pp. 60–69. IARIA (2012)

    Google Scholar 

  24. Omar, N., Hanna, P., McKevitt, P.: Heuristics-based entity-relationship modelling through natural language processing. In: Proceedings of AICS 2004, pp. 302–313 (2004)

    Google Scholar 

  25. Overmyer, S.P., Benoit, L., Owen, R.: Conceptual modeling through linguistic analysis using LIDA. In: Proceedings of ICSE 2001, pp. 401–410. IEEE (2001)

    Google Scholar 

  26. Pottinger, R., Bernstein, P.: Merging models based on given correspondences, pp. 862–873. VLDB 2003, VLDB Endowment (2003)

    Google Scholar 

  27. Purao, S.: APSARA: a tool to automate system design via intelligent pattern retrieval and synthesis. SIGMIS Database 29(4), 45–57 (1998)

    Article  Google Scholar 

  28. Rodriguez, A., Garcia-Rodriguez de Guzman, I., Fernandez-Medina, E., Piattini, M.: Semi-formal transformation of secure business processes into analysis class and use case models: an MDA approach. Inf. Softw. Technol. 52(9), 945–971 (2010)

    Google Scholar 

  29. Spasic, Z., Vukotic, A., Brdjanin, D., Banjac, D., Banjac, G.: UML-based forward database engineering. In: Proceedings of INFOTEH 2023, pp. 1–6. IEEE (2023)

    Google Scholar 

  30. Sugumaran, V., Storey, V.C.: Ontologies for conceptual modeling: their creation, use, and management. Data Knowl. Eng. 42(3), 251–271 (2002)

    Article  MATH  Google Scholar 

  31. Tan, H.B.K., Yang, Y., Blan, L.: Systematic transformation of functional analysis model in object oriented design and implementation. IEEE Trans. Softw. Eng. 32(2), 111–135 (2006)

    Article  Google Scholar 

  32. Thonggoom, O.: Semi-automatic conceptual data modelling using entity and relationship instance repositories. PhD Thesis, Drexel University (2011)

    Google Scholar 

Download references

Author information

Authors and Affiliations

  1. Faculty of Electrical Engineering, University of Banja Luka, Patre 5, 78000, Banja Luka, Bosnia and Herzegovina

    Goran Banjac, Drazen Brdjanin & Danijela Banjac

Authors
  1. Goran Banjac
    View author publications

    You can also search for this author in PubMed Google Scholar

  2. Drazen Brdjanin
    View author publications

    You can also search for this author in PubMed Google Scholar

  3. Danijela Banjac
    View author publications

    You can also search for this author in PubMed Google Scholar

Corresponding author

Correspondence to Goran Banjac .

Editor information

Editors and Affiliations

  1. Universitat Politècnica de Catalunya, Barcelona, Spain

    Alberto Abelló

  2. University of Ioannina, Ioannina, Greece

    Panos Vassiliadis

  3. Universitat Politècnica de Catalunya, Barcelona, Spain

    Oscar Romero

  4. Poznań University of Technology, Poznan, Poland

    Robert Wrembel

  5. University of Paris-Saclay, Gif-sur-Yvette, France

    Francesca Bugiotti

  6. Free University of Bozen-Bolzano, Bozen-Bolzano, Italy

    Johann Gamper

  7. CNRS, Villeurbanne Cedex, France

    Genoveva Vargas Solar

  8. University of Calabria, Rende, Italy

    Ester Zumpano

Rights and permissions

Reprints and permissions

Copyright information

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

Banjac, G., Brdjanin, D., Banjac, D. (2023). Towards Automatic Conceptual Database Design Based on Heterogeneous Source Artifacts. In: Abelló, A., et al. New Trends in Database and Information Systems. ADBIS 2023. Communications in Computer and Information Science, vol 1850. Springer, Cham. https://doi.org/10.1007/978-3-031-42941-5_42

Download citation

  • DOI: https://doi.org/10.1007/978-3-031-42941-5_42

  • Published:

  • Publisher Name: Springer, Cham

  • Print ISBN: 978-3-031-42940-8

  • Online ISBN: 978-3-031-42941-5

  • eBook Packages: Computer ScienceComputer Science (R0)

Publish with us

Policies and ethics

Search

Navigation