Abstract
TexToData is an online tool for automated database design with multilingual support. It enables the automated derivation of an initial conceptual database model from textual specifications in different natural languages, whereby more than a hundred natural languages are supported. The multilingualism is enabled by the translation of a source textual specification into the English language and vice versa. For instance, TexToData first translates the source text into English, then processes the English text, generates the corresponding conceptual model in English, and finally translates the model back into the source natural language. In this paper we analyze the suitability of employing different online translation services in this process.
This is a preview of subscription content, log in via an institution to check access.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Notes
- 1.
For a detailed description we refer the readers to [5].
- 2.
- 3.
Data Definition Language.
- 4.
JavaScript Object Notation.
- 5.
XML MetaData Interchange.
- 6.
REST API (also called RESTful API) is an API that conforms to the design principles of the representational state transfer (REST) architectural style.
- 7.
Textual specifications are translated by the Google Translate service (https://translate.google.com). There may be some minor differences in the generated CDMs, due to some translation inconsistencies.
- 8.
The “concept” term includes classes, attributes, generalizations, associations, and association end multiplicities.
References
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)
Brdjanin, D., Maric, S.: Model-driven techniques for data model synthesis. Electronics 17(2), 130–136 (2013)
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)
Brdjanin, D., Banjac, G., Babic, N., Golubovic, N.: Towards the speech-driven database design. In: Proceedings of TELFOR 2022, pp. 1–4. IEEE (2022)
Brdjanin, D., et al.: Towards an online multilingual tool for automated conceptual database design. In: Braubach, L., Jander, K., Bădică, C. (eds.) Intelligent Distributed Computing XV, pp. 144–153. Springer International Publishing, Cham (2023). https://doi.org/10.1007/978-3-031-29104-3_16
Chen, P.P.-S.: English sentence structure and entity-relationship diagrams. Inf. Sci. 29(2–3), 127–149 (1983). https://doi.org/10.1016/0020-0255(83)90014-2
Choobineh, J., Mannino, M.V., Nunamaker, J.F., Konsynski, B.R.: An expert database design system based on analysis of forms. IEEE Trans. Softw. Eng. 14(2), 242–253 (1988). https://doi.org/10.1109/32.4641
CHOOBINEH, J.O.O.B.I.N., LO, A.M.B.E.R.W.: CABSYDD: case-based system for database design. J. Manage. Inf. Syst. 21(3), 281–314 (2004). https://doi.org/10.1080/07421222.2004.11045813
Date, C.: An Introduction to Database Systems, 8th edn. Addison-Wesley (2003)
Harmain, H., Gaizauskas, R.: CM-Builder: a natural language-based CASE tool for object-oriented analysis. Autom. Softw. Eng. 10(2), 157–181 (2003)
Jouault, F., Allilaire, F., Bezivin, J., Kurtev, I.: ATL: a model transformation tool. Sci. Comput. Program. 72(1–2), 31–39 (2008)
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)
Luisa, M., Mariangela, F., Pierluigi, N.: Market research for requirements analysis using linguistic tools. Requirements Eng. 9, 40–56 (2004)
Lukovic, I., Mogin, P., Pavicevic, J., Ristic, S.: An approach to developing complex database schemas using form types. Softw.: Pract. Exper. 37(15), 1621–1656 (2007)
Neill, C., Laplante, P.: Requirements engineering: the state of the practice. IEEE Softw. 20(6), 40–45 (2003)
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)
Omar, N., Hanna, P., McKevitt, P.: Heuristics-based entity-relationship modelling through natural language processing. In: Proceedings of AICS 2004, pp. 302–313 (2004)
Overmyer, S.P., Benoit, L., Owen, R.: Conceptual modeling through linguistic analysis using LIDA. In: Proceedings of 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)
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)
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., Pastor López, Ó. (eds.) Conceptual Modeling, pp. 18–31. Springer International Publishing, Cham (2015). https://doi.org/10.1007/978-3-319-25264-3_2
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)
Sugumaran, V., Storey, V.C.: Ontologies for conceptual modeling: their creation, use, and management. Data Knowl. Eng. 42(3), 251–271 (2002)
Tan, H.B.K., Yang, Y., Blan, L.: Systematic transformation of functional analysis model in object oriented design and implementation. IEEE Trans. on Soft. Eng. 32(2), 111–135 (2006)
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
© 2025 The Author(s), under exclusive license to Springer Nature Switzerland AG
About this paper
Cite this paper
Banjac, D., Matic, M., Cvijanovic, N., Brdjanin, D., Banjac, G., Stojisavljevic, D. (2025). Employing Multiple Online Translation Services in a Multilingual Database Design Tool. In: Tekli, J., et al. New Trends in Database and Information Systems. ADBIS 2024. Communications in Computer and Information Science, vol 2186. Springer, Cham. https://doi.org/10.1007/978-3-031-70421-5_20
Download citation
DOI: https://doi.org/10.1007/978-3-031-70421-5_20
Published:
Publisher Name: Springer, Cham
Print ISBN: 978-3-031-70420-8
Online ISBN: 978-3-031-70421-5
eBook Packages: Computer ScienceComputer Science (R0)