Skip to main content

Towards an Online Multilingual Tool for Automated Conceptual Database Design

  • Conference paper
  • First Online:
Intelligent Distributed Computing XV (IDC 2022)

Abstract

The paper presents an early prototype of an online multilingual tool named TexToData, which is aimed at automatic conceptual database design. TexToData is the first online web-based tool enabling automatic conversion of a natural language text into the target conceptual database model represented by a UML class diagram. It implements the entire process through the orchestration of web services, whereby some core functionalities are carried out by external services. The tool usage is illustrated with examples of automatic generation of a conceptual database model from the text represented in different natural languages.

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

Access this chapter

Subscribe and save

Springer+ Basic
EUR 32.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
eBook
USD 189.00
Price excludes VAT (USA)
  • Available as EPUB and PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book
USD 249.99
Price excludes VAT (USA)
  • Compact, lightweight edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info
Hardcover Book
USD 249.99
Price excludes VAT (USA)
  • Durable hardcover 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

Similar content being viewed by others

Notes

  1. 1.

    Unified Modeling Language.

  2. 2.

    XML Metadata Interchange.

  3. 3.

    http://www.textrazor.com.

  4. 4.

    http://www.bitext.com.

  5. 5.

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

  6. 6.

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

  7. 7.

    JavaScript Object Notation.

  8. 8.

    The implementation is based on jsUML2 (http://www.jrromero.net/tools/jsUML2).

  9. 9.

    Currently, only attribute names are generated, while other properties (such as data type, multiplicity, etc.) will be a part of our future work.

  10. 10.

    This textual specification represent the result of a direct translation of the sample source English text by the Google Translate service (https://translate.google.com). It is possible that CDMs of different structure will be generated for the same source text represented in some other NL, due to some translation inconsistencies.

References

  1. Ambriola, V., Gervasi, V.: On the systematic analysis of natural language requirements with CIRCE. Autom. Softw. Eng. 13(1), 107–168 (2006)

    Article  Google Scholar 

  2. Bird, S., Loper, E.: NLTK: the natural language toolkit. In: Proceedings of the ACL Interactive Poster and Demonstration Sessions, pp. 214–217. ACL (2004)

    Google Scholar 

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

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

    Article  Google Scholar 

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

    Article  Google Scholar 

  6. Dehne, F., Steuten, A., van de Riet, R.: WordNet++: a lexicon for the Color-X-method. Data Knowl. Eng. 38(1), 3–29 (2001)

    Article  MATH  Google Scholar 

  7. Du, S., Metzler, D.P.: An automated multi-component approach to extracting entity relationships from database requirement specification documents. In: Kop, C., Fliedl, G., Mayr, H.C., Métais, E. (eds.) NLDB 2006. LNCS, vol. 3999, pp. 1–11. Springer, Heidelberg (2006). https://doi.org/10.1007/11765448_1

    Chapter  Google Scholar 

  8. Fellbaum, C., Miller, G.: Color-X: Using Knowledge From WordNet for Conceptual Modeling, pp. 353–377. MIT Press, Cambridge (1998)

    Google Scholar 

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

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

  11. Manning, C., Surdeanu, M., Bauer, J., Finkel, J., Bethard, S., McClosky, D.: The stanford CoreNLP natural language processing toolkit. In: Proceedings of the 52nd Annual Meeting of the ACL: System Demonstrations, pp. 55–60. ACL (2014)

    Google Scholar 

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

    Google Scholar 

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

    Google Scholar 

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

  15. Song, I.-Y., Zhu, Y., Ceong, H., Thonggoom, O.: Methodologies for semi-automated conceptual data modeling from requirements. In: Johannesson, P., Lee, M.L., Liddle, S.W., Opdahl, A.L., López, Ó.P. (eds.) ER 2015. LNCS, vol. 9381, pp. 18–31. Springer, Cham (2015). https://doi.org/10.1007/978-3-319-25264-3_2

    Chapter  Google Scholar 

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

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

Authors

Corresponding author

Correspondence to Drazen Brdjanin .

Editor information

Editors and Affiliations

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

Brdjanin, D. et al. (2023). Towards an Online Multilingual Tool for Automated Conceptual Database Design. In: Braubach, L., Jander, K., Bădică, C. (eds) Intelligent Distributed Computing XV. IDC 2022. Studies in Computational Intelligence, vol 1089. Springer, Cham. https://doi.org/10.1007/978-3-031-29104-3_16

Download citation

Publish with us

Policies and ethics