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.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Notes
- 1.
Unified Modeling Language.
- 2.
XML Metadata Interchange.
- 3.
- 4.
- 5.
- 6.
- 7.
JavaScript Object Notation.
- 8.
The implementation is based on jsUML2 (http://www.jrromero.net/tools/jsUML2).
- 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.
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
Ambriola, V., Gervasi, V.: On the systematic analysis of natural language requirements with CIRCE. Autom. Softw. Eng. 13(1), 107ā168 (2006)
Bird, S., Loper, E.: NLTK: the natural language toolkit. In: Proceedings of the ACL Interactive Poster and Demonstration Sessions, pp. 214ā217. ACL (2004)
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)
Chen, P.: English sentence structure and entity-relationship diagrams. Inf. Sci. 29(2ā3), 127ā149 (1983)
Choobineh, J., Lo, A.W.: CABSYDD: case-based system for database design. J. Manag. Inf. Syst. 21(3), 281ā314 (2004)
Dehne, F., Steuten, A., van de Riet, R.: WordNet++: a lexicon for the Color-X-method. Data Knowl. Eng. 38(1), 3ā29 (2001)
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
Fellbaum, C., Miller, G.: Color-X: Using Knowledge From WordNet for Conceptual Modeling, pp. 353ā377. MIT Press, Cambridge (1998)
Harmain, H., Gaizauskas, R.: CM-Builder: a natural language-based CASE tool for object-oriented analysis. Autom. Softw. Eng. 10(2), 157ā181 (2003)
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)
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)
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)
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)
Purao, S.: APSARA: a tool to automate system design via intelligent pattern retrieval and synthesis. SIGMIS Database 29(4), 45ā57 (1998)
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
Sugumaran, V., Storey, V.C.: Ontologies for conceptual modeling: their creation, use, and management. Data Knowl. Eng. 42(3), 251ā271 (2002)
Thonggoom, O.: Semi-automatic conceptual data modelling using entity and relationship instance repositories. PhD Thesis, Drexel University (2011)
Author information
Authors and Affiliations
Corresponding author
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
Ā© 2023 The Author(s), under exclusive license to Springer Nature Switzerland AG
About this paper
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
DOI: https://doi.org/10.1007/978-3-031-29104-3_16
Published:
Publisher Name: Springer, Cham
Print ISBN: 978-3-031-29103-6
Online ISBN: 978-3-031-29104-3
eBook Packages: Intelligent Technologies and RoboticsIntelligent Technologies and Robotics (R0)